alter database add standby logfile thread 1 group 5 (''/oradata/syk/st_1_5.rdo'') size 50m;
alter database add standby logfile thread 1 group 6 (''/oradata/syk/st_1_6.rdo'') size 50m;
alter database add standby logfile thread 1 group 7 (''/oradata/syk/st_1_7.rdo'') size 50m;
alter database add standby logfile thread 2 group 8 (''/oradata/syk/st_2_8.rdo'') size 50m;
alter database add standby logfile thread 2 group 9 (''/oradata/syk/st_2_9.rdo'') size 50m;
alter database add standby logfile thread 2 group 10 (''/oradata/syk/st_2_10.rdo'') size 50m;
确认日志
select member from v$logfile
九、开始应用,启动MRP(在standby上操作)
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
取消日志应用
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
十、rac各个实例查看日志传送情况(每个实例上都检查)
SQL> select dest_name,status,error from v$archive_dest;
测试:
standby上做检查
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oradata/syk/system.260.765584315
/oradata/syk/undotbs1.262.765584301
/oradata/syk/sysaux.265.765584299
/oradata/syk/users.267.765584315
/oradata/syk/undotbs2.261.765584301
/oradata/syk/moe.264.765584315
/oradata/syk/sunsyk.269.766200437
7 rows selected.
SQL> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
51
rac1做检查
SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
ASM_DATA/syk/datafile/system.260.765584315
ASM_DATA/syk/datafile/undotbs1.262.765584301
ASM_DATA/syk/datafile/sysaux.265.765584299
ASM_DATA/syk/datafile/users.267.765584315
ASM_DATA/syk/datafile/undotbs2.261.765584301
ASM_DATA/syk/datafile/moe.264.765584315
AS