原因:由于之前使用force没有触发SQLPT关闭数据库,导致数据库出现不一致性。为了保证数据库一直性,必须完成实例的恢复,通过日志进行前滚。
解决方法:
1. SQL> alter database open;
2.
3. Database altered.
4.
5. SQL> shutdown immediate;
6. Database closed.
7. Database dismounted.
8. ORACLE instance shut down.
9. SQL> startup mount;
10. ORACLE instance started.
11.
12. Total System Global Area 301305856 bytes
13. Fixed Size 1336148 bytes
14. Variable Size 167775404 bytes
15. Database Buffers 125829120 bytes
16. Redo Buffers 6365184 bytes
17. Database mounted.
18. SQL> alter database archivelog;
19.
20. Database altered.
21.
22. SQL> alter database open;
23.
24. Database altered.
重新查看数据库归档模式:
1. SQL> archive log list
2. Database log mode Archive Mode
3. Automatic archival Enabled
4. Archive destination USE_DB_RECOVERY_FILE_DEST
5. Oldest online log sequence 6
6. Next log sequence to archive 8
7. Current log sequence 8