Oracle归档模式
1Oracle归档模式设置
1.1以系统管理员身份登录
sqlplus /nolog
SQL>connect sys/oracle as sysdba;
Connected.
1.2检查当前数据库是否为归档模式
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 8
Current log sequence 10
1.3设置归档模式
1.全数据库脱机备份(重要),详见全数据库的脱机备份(冷备份)步骤。
2.启动数据库至mount状态
SQL> startup mount;
3.设置数据库为归档模式
SQL> alter database archivelog;
Database altered.
4.检查数据库归档模式是否开启
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 8
Next log sequence to archive 10
Current log sequence 10
5.启动数据库
SQL>alter database open;