使数据库为归档模式

2024-07-21 02:40:10

字体：大中小

来源：转载

供稿：网友

　　1。若数据库为非归档模式，则数据不能保持它的完整。1。su - Oracle
1.1. modify the /opt/oracle/admin/dbora817/pfile/initdbora817.ora,make sure that
    log_archive_start = true
    log_archive_dest_1 = "location=/opt/oracle/admin/dbora817/arch"
    log_archive_format = arch_%t_%s.arc
   are not commented.

2. sqlplus '/ as sysdba'
3. SQL>shutdown
   SQL>startup mount
   SQL>alter database archivelog;
   SQL>alter database open;
4. verify:
   SQL>archive log list

Database log mode              Archive Mode
Automatic archival             ENABLED
Archive destination            /opt/oracle/admin/dbora817/arch
Oldest online log sequence     19
Next log sequence to archive   21
Current log sequence           21

上一篇：[技术]手工建库脚本

下一篇：利用Hibernate Synchronizer插入oralce.CLOB字段