RAC1:
SQL> alter system set log_archive_dest_1='LOCATION=/racdb1_arch' scope=spfile sid='racdb1';
RAC2:
SQL> alter system set log_archive_dest_1='LOCATION=/racdb2_arch' scope=spfile sid='racdb2';
RAC1:
SQL>shutdown immediate;
RAC2:
SQL>shutdown immediate;
SQL>startup mount;
SQL>alter database archivelog;
SQL>alter database open;
SQL> archive log list
RAC2:
SQL>startup
SQL> archive log list;
$ export ORACLE_SID='racdb1
$ srvctl stop instance -d orcl -i racdb1
$ srvctl start instance -d orcl -i racdb1
$ srvctl start database -d orcl
$ srvctl stop database -d orcl
/
http://space.itpub.net/471666/viewspace-368876
修改数据库为归档模式(RAC 环境)
1. 停止数据库
srvctl stop database -d racdb
2. 第一个实例启动到mount 状态.
srvctl start instance -d racdb -i racdb1
shutdown immediate;
startup mount;
SQL> archive log list
SQL> shutdown immediate;
SQL> startup
mount
SQL
> alter database archivelog;
SQL> alter database open;
3. 启动第二个实例
[oracle@rac1 ~]$ srvctl start instance -d racdb -i racdb2
[oracle@rac1 ~]$ srvctl start service -d racdb -s testdb
[oracle@rac1 ~]$ crs_stat -t
/
$ sqlplus /nolog
SQL> CONNECT SYS/SYS_PASS AS SYSDBA
SQL> STARTUP NOMOUNT
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
/
配置log_archive_dest到正确的目录。
注意两个实例可以不一样的,如果是归档日志在本地的话。
alter system set log_archive_dest='/archlog11/arch' sid='racdb1'
alter system set log_archive_dest='/archlog21/arch' sid='racdb2'
登录到一个节点(即 fjvcdb1),通过在当前实例中将 cluster_database 设置为 FALSE 来禁用集群实例参数:
$ sqlplus "/ as sysdba"
SQL> alter system set cluster_database=false scope=spfile sid='racdb1';
关闭所有 访问集群化数据库的实例:
$ srvctl stop database -d racdb
使用本地实例,挂载 数据库:
$ sqlplus "/ as sysdba"
SQL> startup mount
启用存档:
SQL> alter database archivelog;
通过在当前实例中将实例参数 cluster_database 修改为 TRUE,重新启用对集群的支持:
SQL> alter system set cluster_database=true scope=spfile sid='racdb1';
关闭本地实例:
SQL> shutdown immediate
使用 srvctl 备份所有 实例:
$ srvctl start database -d racdb
登录到本地实例,验证存档日志模式已启用:
$ sqlplus "/ as sysdba"
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /archlog21/arch
Oldest online log sequence 1266
Next log sequence to archive 1269
Current log sequence 1269
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /archlog11/arch
Oldest online log sequence 267
Next log sequence to archive 270
Current log sequence 270