Oracle DG之--构建Physical Standby

fumingxia

11:40:28 SQL> SELECT status from v$instance;　　
STATUS
　　
------------
　　
MOUNTED
　　

　　
11:45:40 SQL> alter database recover managed standby database disconnect from session;
　　
Database altered.
　　

　　
告警日志：
　　
alter database recover managed standby database disconnect from session
　　
Wed Aug 31 11:46:00 2011
　　
Attempt to start background Managed Standby Recovery process (sh)
　　
MRP0 started with pid=22, OS id=14159
　　
Wed Aug 31 11:46:01 2011
　　
MRP0: Background Managed Standby Recovery process started (sh)
　　
Managed Standby Recovery not using Real Time Apply
　　
Wed Aug 31 11:46:06 2011
　　
Errors in file /u01/app/oracle/admin/sh/bdump/sh_mrp0_14159.trc:
　　
ORA-00313: open failed for members of log group 1 of thread 1
　　
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/sh/redo01.log'
　　
ORA-27037: unable to obtain file status
　　
Linux Error: 2: No such file or directory
　　
Additional information: 3
　　
Wed Aug 31 11:46:06 2011
　　
Errors in file /u01/app/oracle/admin/sh/bdump/sh_mrp0_14159.trc:
　　
ORA-00313: open failed for members of log group 1 of thread 1
　　
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/sh/redo01.log'
　　
ORA-27037: unable to obtain file status
　　
Linux Error: 2: No such file or directory
　　
Additional information: 3
　　
Clearing online redo logfile 1 /u01/app/oracle/oradata/sh/redo01.log
　　
Clearing online log 1 of thread 1 sequence number 23
　　
Wed Aug 31 11:46:06 2011
　　
Errors in file /u01/app/oracle/admin/sh/bdump/sh_mrp0_14159.trc:
　　
ORA-00313: open failed for members of log group 1 of thread 1
　　
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/sh/redo01.log'
　　
ORA-27037: unable to obtain file status
　　
Linux Error: 2: No such file or directory
　　
Additional information: 3
　　
Wed Aug 31 11:46:07 2011
　　
Completed: alter database recover managed standby database disconnect from session
　　
Wed Aug 31 11:46:08 2011
　　
Clearing online redo logfile 1 complete
　　
Wed Aug 31 11:46:08 2011
　　
Errors in file /u01/app/oracle/admin/sh/bdump/sh_mrp0_14159.trc:
　　
ORA-00313: open failed for members of log group 2 of thread 1
　　
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/sh/redo02.log'
　　
ORA-27037: unable to obtain file status
　　
Linux Error: 2: No such file or directory
　　
Additional information: 3
　　
Wed Aug 31 11:46:08 2011
　　
Errors in file /u01/app/oracle/admin/sh/bdump/sh_mrp0_14159.trc:
　　
ORA-00313: open failed for members of log group 2 of thread 1
　　
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/sh/redo02.log'
　　
ORA-27037: unable to obtain file status
　　
Linux Error: 2: No such file or directory
　　
Additional information: 3
　　
Clearing online redo logfile 2 /u01/app/oracle/oradata/sh/redo02.log
　　
Clearing online log 2 of thread 1 sequence number 21
　　
Wed Aug 31 11:46:08 2011
　　
Errors in file /u01/app/oracle/admin/sh/bdump/sh_mrp0_14159.trc:
　　
ORA-00313: open failed for members of log group 2 of thread 1
　　
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/sh/redo02.log'
　　
ORA-27037: unable to obtain file status
　　
Linux Error: 2: No such file or directory
　　
Additional information: 3
　　
Clearing online redo logfile 2 complete
　　
Wed Aug 31 11:46:09 2011
　　
Errors in file /u01/app/oracle/admin/sh/bdump/sh_mrp0_14159.trc:
　　
ORA-00313: open failed for members of log group 3 of thread 1
　　
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/sh/redo03.log'
　　
ORA-27037: unable to obtain file status
　　
Linux Error: 2: No such file or directory
　　
Additional information: 3
　　
Wed Aug 31 11:46:09 2011
　　
Errors in file /u01/app/oracle/admin/sh/bdump/sh_mrp0_14159.trc:
　　
ORA-00313: open failed for members of log group 3 of thread 1
　　
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/sh/redo03.log'
　　
ORA-27037: unable to obtain file status
　　
Linux Error: 2: No such file or directory
　　
Additional information: 3
　　
Clearing online redo logfile 3 /u01/app/oracle/oradata/sh/redo03.log
　　
Clearing online log 3 of thread 1 sequence number 22
　　
Wed Aug 31 11:46:09 2011
　　
Errors in file /u01/app/oracle/admin/sh/bdump/sh_mrp0_14159.trc:
　　
ORA-00313: open failed for members of log group 3 of thread 1
　　
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/sh/redo03.log'
　　
ORA-27037: unable to obtain file status
　　
Linux Error: 2: No such file or directory
　　
Additional information: 3
　　
Clearing online redo logfile 3 complete
　　
Media Recovery Waiting for thread 1 sequence 23
　　
Wed Aug 31 11:47:00 2011
　　
Using STANDBY_ARCHIVE_DEST parameter default value as /u01/disk1/arch/sh/
　　
Redo Shipping Client Connected as PUBLIC
　　
-- Connected User is Valid
　　
RFS[1]: Assigned to RFS process 14219
　　
RFS[1]: Identified database type as 'physical standby'
　　
Wed Aug 31 11:47:00 2011
　　
RFS LogMiner: Client disabled from further notification
　　
Wed Aug 31 11:47:01 2011
　　
Redo Shipping Client Connected as PUBLIC
　　
-- Connected User is Valid
　　
RFS[2]: Assigned to RFS process 14221
　　
RFS[2]: Identified database type as 'physical standby'
　　
Wed Aug 31 11:47:01 2011
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_7_760458507.log'
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_8_760458507.log'
　　
Wed Aug 31 11:47:01 2011
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_6_760458507.log'
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_10_760458507.log'
　　
Wed Aug 31 11:47:01 2011
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_9_760458507.log'
　　
Wed Aug 31 11:47:02 2011
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_11_760458507.log'
　　
Wed Aug 31 11:47:02 2011
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_12_760458507.log'
　　
Wed Aug 31 11:47:02 2011
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_13_760458507.log'
　　
Wed Aug 31 11:47:02 2011
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_14_760458507.log'
　　
Wed Aug 31 11:47:02 2011
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_15_760458507.log'
　　
Wed Aug 31 11:47:02 2011
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_16_760458507.log'
　　
Wed Aug 31 11:47:03 2011
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_17_760458507.log'
　　
Wed Aug 31 11:47:03 2011
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_18_760458507.log'
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_19_760458507.log'
　　
Wed Aug 31 11:47:03 2011
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_20_760458507.log'
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_22_760458507.log'
　　
Wed Aug 31 11:47:04 2011
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_21_760458507.log'
　　
Wed Aug 31 11:47:04 2011
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_24_760458507.log'
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_25_760458507.log'
　　
Wed Aug 31 11:47:05 2011
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_23_760458507.log'
　　
Wed Aug 31 11:47:05 2011
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_26_760458507.log'
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_27_760458507.log'
　　
Wed Aug 31 11:47:05 2011
　　
RFS[1]: Archived Log: '/u01/disk1/arch/sh/arch_1_28_760458507.log'
　　
Wed Aug 31 11:47:05 2011
　　
RFS[2]: Archived Log: '/u01/disk1/arch/sh/arch_1_29_760458507.log'
　　
Wed Aug 31 11:47:05 2011
　　
Media Recovery Log /u01/disk1/arch/sh/arch_1_23_760458507.log
　　
Media Recovery Log /u01/disk1/arch/sh/arch_1_24_760458507.log
　　
Media Recovery Log /u01/disk1/arch/sh/arch_1_25_760458507.log
　　
Media Recovery Log /u01/disk1/arch/sh/arch_1_26_760458507.log
　　
Media Recovery Log /u01/disk1/arch/sh/arch_1_27_760458507.log
　　
Media Recovery Log /u01/disk1/arch/sh/arch_1_28_760458507.log
　　
Media Recovery Log /u01/disk1/arch/sh/arch_1_29_760458507.log
　　
Media Recovery Waiting for thread 1 sequence 30