rac环境下修改归档模式报ORA-01126错误

jiawang

报错现象：
SQL> startup mount;
ORACLE instance started.

Total System Global Area 2505338880 bytes
Fixed Size                  2255832 bytes
Variable Size             671089704 bytes
Database Buffers         1828716544 bytes
Redo Buffers                3276800 bytes
Database mounted.
SQL>  alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any
instance



报错原因：
节点2数据库仍处于open状态，所以报错。


解决办法：关闭节点2数据库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.


在设置归档模式
SQL>  alter database archivelog;
Database altered.


SQL> alter system set log_archive_dest_1='location=+data';
System altered.


SQL> alter database open;
Database altered.


SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DATA
Oldest online log sequence     1
Next log sequence to archive   2
Current log sequence           2



PS：节点1设置归档后，节点2自动也会转换为归档模式
SQL> startup;
ORACLE instance started.


Total System Global Area 2505338880 bytes
Fixed Size                  2255832 bytes
Variable Size             671089704 bytes
Database Buffers         1828716544 bytes
Redo Buffers                3276800 bytes
Database mounted.
Database opened.
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DATA
Oldest online log sequence     1
Next log sequence to archive   2
Current log sequence           2
SQL>