RAC开启归档模式
一、将rac数据库重新启动到mount状态
[grid@centosnode1 ~]$ srvctl stop database -d DB2016
二、在任意一节点上执行下面操作:
1、启动节点实例到mount
2、设置归档路径
SQL> alter system set log_archive_dest_1='location=+DATA/db2016/arch' scope=spfile sid='*';
3、更改cluster_database参数,并使之生效
SQL> alter system set cluster_database=false scope=spfile;
SQL> shutdown immediate;
SQL> startup mount;
4、更改为归档模式
SQL> alter database archivelog;
5、更改cluster_database参数
SQL> alter system set cluster_database=true scope=spfile;
SQL> shutdown immediate
三、启动数据库
[grid@centosnode1 ~]$ srvctl start database -d DB2016
备注:另一种开启RAC归档的方法
[grid@centosnode1 ~]$ srvctl stop database -d DB2016
[grid@centosnode1 ~]$ srvctl start database -d DB2016 -o mount
然后使用sqlplus登录所有节点逐一更改归档路径(alter system set log_archive_dest_1='location=+DATA/db2016/arch' scope=spfile sid='DB20161';....),并更改为归档模式(alter database
archivelog)
重启rac数据库
[grid@centosnode1 ~]$ srvctl stop database -d DB2016
[grid@centosnode1 ~]$ srvctl start database -d DB2016
RAC关闭归档模式
[grid@centosnode1 ~]$ srvctl stop database -d DB2016
[grid@centosnode1 ~]$ srvctl start database -d DB2016 -o mount
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA/db2016/arch
Oldest online log sequence 81
Next log sequence to archive 0
Current log sequence 82
SQL> alter database noarchivelog;
[grid@centosnode1 ~]$ srvctl stop database -d DB2016
[grid@centosnode1 ~]$ srvctl start database -d DB2016
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination +DATA/db2016/arch
Oldest online log sequence 82
Current log sequence 83
一、将rac数据库重新启动到mount状态
[grid@centosnode1 ~]$ srvctl stop database -d DB2016
二、在任意一节点上执行下面操作:
1、启动节点实例到mount
2、设置归档路径
SQL> alter system set log_archive_dest_1='location=+DATA/db2016/arch' scope=spfile sid='*';
3、更改cluster_database参数,并使之生效
SQL> alter system set cluster_database=false scope=spfile;
SQL> shutdown immediate;
SQL> startup mount;
4、更改为归档模式
SQL> alter database archivelog;
5、更改cluster_database参数
SQL> alter system set cluster_database=true scope=spfile;
SQL> shutdown immediate
三、启动数据库
[grid@centosnode1 ~]$ srvctl start database -d DB2016
备注:另一种开启RAC归档的方法
[grid@centosnode1 ~]$ srvctl stop database -d DB2016
[grid@centosnode1 ~]$ srvctl start database -d DB2016 -o mount
然后使用sqlplus登录所有节点逐一更改归档路径(alter system set log_archive_dest_1='location=+DATA/db2016/arch' scope=spfile sid='DB20161';....),并更改为归档模式(alter database
archivelog)
重启rac数据库
[grid@centosnode1 ~]$ srvctl stop database -d DB2016
[grid@centosnode1 ~]$ srvctl start database -d DB2016
RAC关闭归档模式
[grid@centosnode1 ~]$ srvctl stop database -d DB2016
[grid@centosnode1 ~]$ srvctl start database -d DB2016 -o mount
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA/db2016/arch
Oldest online log sequence 81
Next log sequence to archive 0
Current log sequence 82
SQL> alter database noarchivelog;
[grid@centosnode1 ~]$ srvctl stop database -d DB2016
[grid@centosnode1 ~]$ srvctl start database -d DB2016
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination +DATA/db2016/arch
Oldest online log sequence 82
Current log sequence 83
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30373263/viewspace-2084529/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30373263/viewspace-2084529/