[b]登录Sqlplus,查看数据库归档状态[/b]
[b]查看当前数据库的归档状态[/b]
[b]关闭数据库,并以装载方式启动[/b]
[b]更改数据库日志模式为存档模式[/b]
[b]启动数据库,确认日志模式已更改为存档模式[/b]
SQL> sqlplus /nolog
SQL> conn / as sysdba
[b]查看当前数据库的归档状态[/b]
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 9
Current log sequence 11
[b]关闭数据库,并以装载方式启动[/b]
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.3362E+10 bytes
Fixed Size 2217952 bytes
Variable Size 6777997344 bytes
Database Buffers 6576668672 bytes
Redo Buffers 4960256 bytes
Database mounted.
[b]更改数据库日志模式为存档模式[/b]
SQL> alter database archivelog;
Database altered.
[b]启动数据库,确认日志模式已更改为存档模式[/b]
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 9
Next log sequence to archive 11
Current log sequence 11