在测试平台上想用rman备份全库结果发现总是失败，需要启动归档模式，但是总是不成功，后面我做了一下操作，才可以了，遇到类似的朋友可以借鉴下。哈哈

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 10
Current log sequence 12
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SQL> alter database open;
Database altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> SQL> SQL> startup nomount;
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 104859216 bytes
Database Buffers 176160768 bytes
Redo Buffers 2973696 bytes
SQL> alter database mount;
Database altered.

SQL> alter database archivelog;
Database altered.
SQL>

ITPub博客

解决【ORA-00265: instance recovery required, cannot set ARCHIVELOG mode】

最新文章