ITPub博客

首页 > 数据库 > Oracle > 解决【ORA-00265: instance recovery required, cannot set ARCHIVELOG mode】

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

原创 Oracle 作者:history_xcy 时间:2014-03-17 18:47:54 0 删除 编辑

    在测试平台上想用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博客 ” ,链接:http://blog.itpub.net/29479238/viewspace-1123534/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-02-10

  • 博文量
    10
  • 访问量
    180282