重庆思庄Oracle、Redhat认证学习论坛

标题: rac环境下修改归档模式报ORA-01126错误 [打印本页]

作者: jiawang 时间: 2018-12-24 17:32
标题: rac环境下修改归档模式报ORA-01126错误
报错现象：
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>

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)