1. 查看数据库日志模式
SQL> archive log listDatabase log mode No Archive ModeAutomatic archival DisabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 8Current log sequence 10
2. 关闭数据库
SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.
3. 备份数据库
该备份跟以后产生的日志一起用于将来的灾难恢复(很重要,如要改为归档日志模式,没有这个数据库备份,仅有日志文件是无法从该时间点恢复的)。
4. 启动数据库到MOUNT模式
SQL> startup mountORACLE instance started.Total System Global Area 285212672 bytesFixed Size 1218968 bytesVariable Size 79693416 bytesDatabase Buffers 197132288 bytesRedo Buffers 7168000 bytesDatabase mounted.
5. 切换数据库日志模式到归档模式
SQL> alter database archivelog 2 /Database altered.
6. 打开数据库
SQL> alter database open 2 /Database altered.
7. 查看更改后的数据库日志模式
SQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 8Next log sequence to archive 10Current log sequence 10SQL>