查看当前归档模式
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence
Current log sequence
重启数据库到mount状态
SQL> shutdown immediate;
Database closed
Database dismounted
ORACLE instance shut down
SQL> startup mount;
ORACLE instance started
Total System Global Area bytes
Fixed Size bytes
Variable Size bytes
Database Buffers bytes
Redo Buffers bytes
Database mounted
开启归档模式
SQL> alter database archivelog;
Database altered
打开数据库
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
Next log sequence to archive
Current log sequence
SQL> archive log start;
Statement processed
关闭归档模式的步骤
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;
i和g的区别
i中需要修改初始化参数
log_archive_start = true
g中已经废弃该参数
