rman恢复物理standby

备库宕机过久，主库的归档及归档备份已经被删除，使用rman进行恢复

备库：查看监听状态为启动

[oracle@vm21 ~]$ lsnrctl status

Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

 

备库：查看数据库状态，停止备库

SQL> shutdown immediate
ORA-01507: database not mounted

备库：删除dbf、ctl、log、arc，为了节省空间，删除备份文件

[oracle@vm21 ~]$ cd /u01/data/orcl/
[oracle@vm21 orcl]$ ls
arc             control01.ctl  redo07.log  redo10.log  rman               standbyredo03.log  standbyredo06.log  sysaux01.dbf  undotbs01.dbf
arcsb           control02.ctl  redo08.log  redo11.log  standbyredo01.log  standbyredo04.log  standbyredo07.log  system01.dbf  users01.dbf
cmtspay_ts.dbf  control03.ctl  redo09.log  redo12.log  standbyredo02.log  standbyredo05.log  standbyredo08.log  temp01.dbf
[oracle@vm21 orcl]$ rm -rf *dbf *ctl *log */*
[oracle@vm21 orcl]$ du -sh
16K     .
[oracle@vm21 orcl]$ du -sh *
4.0K    arc
4.0K    arcsb
4.0K    rman

备库：由于主备库的rman目录为nfs挂载，考虑网速和io，在本地建立备份传输目录，并检查空间剩余量是否充足

[oracle@vm21 orcl]$ ls
arc  arcsb  rman
[oracle@vm21 orcl]$ mkdir rmanstb
[oracle@vm21 orcl]$ cd rmanstb/
[oracle@vm21 rmanstb]$ pwd
/u01/data/orcl/rmanstb
[oracle@vm21 rmanstb]$ df -Th
Filesystem    Type    Size  Used Avail Use% Mounted on
/dev/sda2     ext4    117G   42G   70G  38% /
tmpfs        tmpfs     50G  3.8G   47G   8% /dev/shm
df: `/root/.gvfs': Permission denied
192.168.0.249:/home/nfsgx
               nfs    209G  101G   98G  51% /sharedir
192.168.0.224:/nfsgx/21arc
               nfs    1.8T  947G  793G  55% /u01/data/orcl/arc
192.168.0.224:/nfsgx/21arcsb
               nfs    1.8T  947G  793G  55% /u01/data/orcl/arcsb
192.168.0.224:/nfsgx/21rman
               nfs    1.8T  947G  793G  55% /u01/data/orcl/rman
              
              
备库：启动至nomount              
[oracle@vm21 orcl]$ sqlplus / as sysdba

SQL> startup nomount
ORACLE instance started.

主库：在本地建立备份传输目录，并检查空间剩余量是否充足
[root@247-vm02 ~]# su - oracle
[oracle@247-vm02 ~]$ cd /u01/data/orcl/rman/
[oracle@247-vm02 rman]$ df -Th
Filesystem    Type    Size  Used Avail Use% Mounted on
/dev/sda2     ext4    341G   99G  225G  31% /
tmpfs        tmpfs    7.9G  3.7G  4.3G  47% /dev/shm
192.168.0.224:/nfsgx/72arc
               nfs    1.8T  947G  793G  55% /u01/data/orcl/arc
192.168.0.224:/nfsgx/72arcsb
               nfs    1.8T  947G  793G  55% /u01/data/orcl/arcsb
192.168.0.224:/nfsgx/72rman
               nfs    1.8T  947G  793G  55% /u01/data/orcl/rman
df: `/root/.gvfs': Permission denied
[oracle@247-vm02 rman]$ cd ../
[oracle@247-vm02 orcl]$ mkdir rmanstb
[oracle@247-vm02 orcl]$ cd rmanstb/
[oracle@247-vm02 rmanstb]$ pwd
/u01/data/orcl/rmanstb

主库：开始恢复过程
[oracle@247-vm02 rmanstb]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 17 10:26:09 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1341321266)

建立备份，包含standby的ctl
RMAN> backup full database format='/u01/data/orcl/rmanstb/for_stb_%u.bkp' include current controlfile for standby;

Starting backup at 17-OCT-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1156 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/data/orcl/cmtspay_ts.dbf
input datafile file number=00002 name=/u01/data/orcl/sysaux01.dbf
input datafile file number=00001 name=/u01/data/orcl/system01.dbf
input datafile file number=00003 name=/u01/data/orcl/undotbs01.dbf
input datafile file number=00004 name=/u01/data/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 17-OCT-13
channel ORA_DISK_1: finished piece 1 at 17-OCT-13
piece handle=/u01/data/orcl/rmanstb/for_stb_qmomkeua.bkp tag=TAG20131017T102826 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including standby control file in backup set
channel ORA_DISK_1: starting piece 1 at 17-OCT-13
channel ORA_DISK_1: finished piece 1 at 17-OCT-13
piece handle=/u01/data/orcl/rmanstb/for_stb_qnomkevd.bkp tag=TAG20131017T102826 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 17-OCT-13

Starting Control File Autobackup at 17-OCT-13
piece handle=/u01/oracle/product/11.2.0/dbs/c-1341321266-20131017-03 comment=NONE
Finished Control File Autobackup at 17-OCT-13

当前日志归档
RMAN> sql 'alter system archive log current';

sql statement: alter system archive log current

连接备库
RMAN> connect auxiliary sys/system@orcl2

connected to auxiliary database: ORCL (not mounted)

duplicate恢复
RMAN> duplicate target database for standby nofilenamecheck;

Starting Duplicate Db at 17-OCT-13
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=572 device type=DISK

contents of Memory Script.:
{
   restore clone standby controlfile;
}
executing Memory Script

Starting restore at 17-OCT-13
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/oracle/product/11.2.0/dbs/c-1341321266-20131017-03
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /u01/oracle/product/11.2.0/dbs/c-1341321266-20131017-03
ORA-19505: failed to identify file "/u01/oracle/product/11.2.0/dbs/c-1341321266-20131017-03"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

failover to previous backup

省略n个报错

由于没有将主库备份传至备库的同目录下

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/17/2013 10:30:25
RMAN-03015: error occurred in stored script. Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

RMAN> exit

Recovery Manager complete.

主库：查看备份，并传输至备库

[oracle@247-vm02 rmanstb]$ ls
for_stb_qmomkeua.bkp  for_stb_qnomkevd.bkp
[oracle@247-vm02 rmanstb]$ scp * 192.168.0.21:/u01/data/orcl/rmanstb/
oracle@192.168.0.21's password:
for_stb_qmomkeua.bkp                                                                                                                           100% 2168MB  38.0MB/s   00:57   
for_stb_qnomkevd.bkp                                                                                                                           100% 9728KB   9.5MB/s   00:01   

 

备库：查看是否接到备份

[oracle@vm21 rmanstb]$ ls
for_stb_qmomkeua.bkp  for_stb_qnomkevd.bkp

 

主库：重新执行恢复

[oracle@247-vm02 rmanstb]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 17 10:35:39 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

cconnected to target database: ORCL (DBID=1341321266)

RMAN> connect auxiliary sys/system@orcl2

connected to auxiliary database: ORCL (not mounted)

RMAN> duplicate target database for standby nofilenamecheck;

Starting Duplicate Db at 17-OCT-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=572 device type=DISK

contents of Memory Script.:
{
   restore clone standby controlfile;
}
executing Memory Script

Starting restore at 17-OCT-13
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/oracle/product/11.2.0/dbs/c-1341321266-20131017-03
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /u01/oracle/product/11.2.0/dbs/c-1341321266-20131017-03
ORA-19505: failed to identify file "/u01/oracle/product/11.2.0/dbs/c-1341321266-20131017-03"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

failover to previous backup

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/data/orcl/rmanstb/for_stb_qnomkevd.bkp
channel ORA_AUX_DISK_1: piece handle=/u01/data/orcl/rmanstb/for_stb_qnomkevd.bkp tag=TAG20131017T102826
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/data/orcl/control01.ctl
output file name=/u01/data/orcl/control02.ctl
Finished restore at 17-OCT-13

contents of Memory Script.:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script.:
{
   set newname for tempfile  1 to
 "/u01/data/orcl/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to
 "/u01/data/orcl/system01.dbf";
   set newname for datafile  2 to
 "/u01/data/orcl/sysaux01.dbf";
   set newname for datafile  3 to
 "/u01/data/orcl/undotbs01.dbf";
   set newname for datafile  4 to
 "/u01/data/orcl/users01.dbf";
   set newname for datafile  5 to
 "/u01/data/orcl/cmtspay_ts.dbf";
   restore
   clone database
   ;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/data/orcl/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 17-OCT-13
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/data/orcl/system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/data/orcl/sysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/data/orcl/undotbs01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/data/orcl/users01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/data/orcl/cmtspay_ts.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/data/orcl/rmanstb/for_stb_qmomkeua.bkp
channel ORA_AUX_DISK_1: piece handle=/u01/data/orcl/rmanstb/for_stb_qmomkeua.bkp tag=TAG20131017T102826
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:02:59
Finished restore at 17-OCT-13

contents of Memory Script.:
{
   switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=2 STAMP=829046452 file name=/u01/data/orcl/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=3 STAMP=829046452 file name=/u01/data/orcl/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=4 STAMP=829046452 file name=/u01/data/orcl/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=5 STAMP=829046452 file name=/u01/data/orcl/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=6 STAMP=829046452 file name=/u01/data/orcl/cmtspay_ts.dbf
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 4 thread 1: '/u01/data/orcl/redo07.log'

RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 5 thread 1: '/u01/data/orcl/redo09.log'

RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 7 thread 1: '/u01/data/orcl/standbyredo01.log'

省略n个报错

RMAN-05535: WARNING: All redo log files were not defined properly.
Finished Duplicate Db at 17-OCT-13
其实并未恢复成功

备库：查看数据库文件，未产生日志文件，和主库的报错符合

[oracle@vm21 rmanstb]$ cd ../
[oracle@vm21 orcl]$ ls
arc  arcsb  cmtspay_ts.dbf  control01.ctl  control02.ctl  rman  rmanstb  sysaux01.dbf  system01.dbf  undotbs01.dbf  users01.dbf

备库：设置数据库恢复模式，尝试开库后能否自动生成日志文件

[oracle@vm21 orcl]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 17 10:41:51 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open read only;

Database altered.

SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

备库：重新查看数据库文件，未产生日志文件

[oracle@vm21 orcl]$ ls
arc  arcsb  cmtspay_ts.dbf  control01.ctl  control02.ctl  rman  rmanstb  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  users01.dbf

备库：告警日志提示ORA-19527

Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_rfs_3902.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 10 thread 0: '/u01/data/orcl/standbyredo07.log'
Clearing online log 10 of thread 0 sequence number 0
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_rfs_3902.trc:
ORA-00313: open failed for members of log group 10 of thread 0
ORA-00312: online log 10 thread 0: '/u01/data/orcl/standbyredo08.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

备库：增加转换参数

[oracle@vm21 orcl]$ pwd
/u01/data/orcl

[oracle@vm21 orcl]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 17 10:45:58 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter convert;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
log_file_name_convert                string
SQL> alter system set log_file_name_convert='/u01/data/orcl','/u01/data/orcl';
alter system set log_file_name_convert='/u01/data/orcl','/u01/data/orcl'
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set log_file_name_convert='/u01/data/orcl','/u01/data/orcl' scope=spfile;

System altered.

备库：停库后启动至nomount状态，删除数据库文件，为重新开始恢复做准备

SQL> shutdown immediate

SQL> startup nomount;

[oracle@vm21 orcl]$ ls
arc  arcsb  cmtspay_ts.dbf  control01.ctl  control02.ctl  rman  rmanstb  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  users01.dbf
[oracle@vm21 orcl]$ rm -rf *dbf *ctl arc/* arcsb/* rman/*
[oracle@vm21 orcl]$ du -sh *
4.0K    arc
4.0K    arcsb
4.0K    rman
2.2G    rmanstb

 

主库：重新开始恢复

RMAN> connect auxiliary sys/system@orcl2

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06167: already connected

RMAN> duplicate target database for standby nofilenamecheck;

Starting Duplicate Db at 17-OCT-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/17/2013 10:54:49
RMAN-06136: ORACLE error from auxiliary database: ORA-03114: not connected to ORACLE

RMAN> exit

由于此期间备库停止过，因此报错，需要重新rman连接

[oracle@247-vm02 rmanstb]$ rman target / auxiliary sys/system@orcl2

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Oct 17 10:55:09 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1341321266)
connected to auxiliary database: ORCL (not mounted)

重新恢复备库

RMAN> duplicate target database for standby nofilenamecheck;

Starting Duplicate Db at 17-OCT-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=572 device type=DISK

contents of Memory Script.:
{
   restore clone standby controlfile;
}
executing Memory Script

Starting restore at 17-OCT-13
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/oracle/product/11.2.0/dbs/c-1341321266-20131017-03
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /u01/oracle/product/11.2.0/dbs/c-1341321266-20131017-03
ORA-19505: failed to identify file "/u01/oracle/product/11.2.0/dbs/c-1341321266-20131017-03"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

failover to previous backup

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/data/orcl/rmanstb/for_stb_qnomkevd.bkp
channel ORA_AUX_DISK_1: piece handle=/u01/data/orcl/rmanstb/for_stb_qnomkevd.bkp tag=TAG20131017T102826
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u01/data/orcl/control01.ctl
output file name=/u01/data/orcl/control02.ctl
Finished restore at 17-OCT-13

contents of Memory Script.:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script.:
{
   set newname for tempfile  1 to
 "/u01/data/orcl/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to
 "/u01/data/orcl/system01.dbf";
   set newname for datafile  2 to
 "/u01/data/orcl/sysaux01.dbf";
   set newname for datafile  3 to
 "/u01/data/orcl/undotbs01.dbf";
   set newname for datafile  4 to
 "/u01/data/orcl/users01.dbf";
   set newname for datafile  5 to
 "/u01/data/orcl/cmtspay_ts.dbf";
   restore
   clone database
   ;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/data/orcl/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 17-OCT-13
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/data/orcl/system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/data/orcl/sysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/data/orcl/undotbs01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/data/orcl/users01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/data/orcl/cmtspay_ts.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/data/orcl/rmanstb/for_stb_qmomkeua.bkp
channel ORA_AUX_DISK_1: piece handle=/u01/data/orcl/rmanstb/for_stb_qmomkeua.bkp tag=TAG20131017T102826
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:02:16
Finished restore at 17-OCT-13

contents of Memory Script.:
{
   switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=2 STAMP=829047480 file name=/u01/data/orcl/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=3 STAMP=829047480 file name=/u01/data/orcl/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=4 STAMP=829047480 file name=/u01/data/orcl/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=5 STAMP=829047480 file name=/u01/data/orcl/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=6 STAMP=829047480 file name=/u01/data/orcl/cmtspay_ts.dbf
Finished Duplicate Db at 17-OCT-13

无任何报错警告，恢复成功

 

备库：查看数据库文件，全部出现

[oracle@vm21 orcl]$ ls
arc             control01.ctl  redo08.log  redo11.log  rmanstb            standbyredo03.log  standbyredo06.log  sysaux01.dbf   users01.dbf
arcsb           control02.ctl  redo09.log  redo12.log  standbyredo01.log  standbyredo04.log  standbyredo07.log  system01.dbf
cmtspay_ts.dbf  redo07.log     redo10.log  rman        standbyredo02.log  standbyredo05.log  standbyredo08.log  undotbs01.dbf

备库：查看数据库状态，设置实时应用日志

[oracle@vm21 orcl]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 17 11:08:04 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> alter database open;

Database altered.

SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY WITH APPLY

备库：告警日志如下
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /u01/oracle/product/11.2.0/dbs/spfileorcl.ora
System parameters with non-default values:
  processes                = 1500
  sessions                 = 2272
  memory_target            = 6464M
  control_files            = "/u01/data/orcl/control01.ctl"
  control_files            = "/u01/data/orcl/control02.ctl"
  log_file_name_convert    = "/u01/data/orcl"
  log_file_name_convert    = "/u01/data/orcl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  log_archive_dest_1       = "location=/u01/data/orcl/arc valid_for=(all_logfiles,all_roles) db_unique_name=orcl2"
  log_archive_dest_2       = "service=orcl1 LGWR ASYNC valid_for=(online_logfiles,primary_role) db_unique_name=orcl1"
  log_archive_dest_3       = "location=/u01/data/orcl/arcsb valid_for=(standby_logfiles,standby_role) db_unique_name=orcl2"
  log_archive_dest_state_1 = "enable"
  log_archive_dest_state_2 = "enable"
  log_archive_dest_state_3 = "enable"
  fal_client               = "orcl2"
  fal_server               = "orcl1"
  log_archive_config       = "dg_config=(orcl1,orcl2)"
  log_archive_format       = "%t_%s_%r.arc"
  log_archive_max_processes= 30
  standby_file_management  = "auto"
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  audit_file_dest          = "/u01/oracle/admin/orcl/adump"
  audit_trail              = "DB"
  db_name                  = "orcl"
  db_unique_name           = "orcl2"
  open_cursors             = 300
  diagnostic_dest          = "/u01/oracle"
Thu Oct 17 10:50:45 2013
PMON started with pid=2, OS id=4243
Thu Oct 17 10:50:46 2013
VKTM started with pid=3, OS id=4245 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Oct 17 10:50:46 2013
GEN0 started with pid=4, OS id=4251
Thu Oct 17 10:50:47 2013
DIAG started with pid=5, OS id=4253
Thu Oct 17 10:50:47 2013
DBRM started with pid=6, OS id=4255
Thu Oct 17 10:50:48 2013
PSP0 started with pid=7, OS id=4257
Thu Oct 17 10:50:48 2013
DIA0 started with pid=8, OS id=4259
Thu Oct 17 10:50:49 2013
MMAN started with pid=9, OS id=4261
Thu Oct 17 10:50:49 2013
DBW0 started with pid=10, OS id=4263
Thu Oct 17 10:50:49 2013
LGWR started with pid=11, OS id=4265
Thu Oct 17 10:50:49 2013
CKPT started with pid=12, OS id=4267
Thu Oct 17 10:50:49 2013
SMON started with pid=13, OS id=4269
Thu Oct 17 10:50:49 2013
RECO started with pid=14, OS id=4271
Thu Oct 17 10:50:49 2013
MMON started with pid=15, OS id=4273
Thu Oct 17 10:50:49 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Oct 17 10:50:49 2013
MMNL started with pid=16, OS id=4275
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/oracle
Thu Oct 17 10:54:22 2013
Using STANDBY_ARCHIVE_DEST parameter default value as /u01/data/orcl/arc
destination database instance is 'started' not 'mounted'
Thu Oct 17 10:55:38 2013
RFS connections have been disallowed
alter database mount standby database
Set as converted control file due to db_unique_name mismatch
Changing di2dbun from orcl1 to orcl2
ARCH: STARTING ARCH PROCESSES
Thu Oct 17 10:55:42 2013
ARC0 started with pid=22, OS id=4492
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thu Oct 17 10:55:43 2013
ARC1 started with pid=23, OS id=4494
Thu Oct 17 10:55:43 2013
Successful mount of redo thread 1, with mount id 1356869290
Physical Standby Database mounted.
Lost write protection disabled
Thu Oct 17 10:55:43 2013
ARC2 started with pid=24, OS id=4496
Thu Oct 17 10:55:43 2013
ARC3 started with pid=25, OS id=4498
Thu Oct 17 10:55:43 2013
ARC4 started with pid=26, OS id=4500
Thu Oct 17 10:55:43 2013
ARC5 started with pid=27, OS id=4502
Thu Oct 17 10:55:43 2013
ARC6 started with pid=28, OS id=4504
Thu Oct 17 10:55:43 2013
ARC7 started with pid=29, OS id=4506
Thu Oct 17 10:55:44 2013
ARC8 started with pid=30, OS id=4508
Thu Oct 17 10:55:44 2013
ARC9 started with pid=31, OS id=4510
Completed: alter database mount standby database
Thu Oct 17 10:55:44 2013
ARCa started with pid=32, OS id=4512
Thu Oct 17 10:55:44 2013
ARCb started with pid=33, OS id=4514
Thu Oct 17 10:55:44 2013
ARCc started with pid=34, OS id=4516
Thu Oct 17 10:55:44 2013
ARCd started with pid=35, OS id=4518
Thu Oct 17 10:55:44 2013
ARCe started with pid=36, OS id=4520
Thu Oct 17 10:55:44 2013
ARCf started with pid=37, OS id=4522
Thu Oct 17 10:55:44 2013
ARCg started with pid=38, OS id=4524
Thu Oct 17 10:55:44 2013
ARCh started with pid=39, OS id=4526
Thu Oct 17 10:55:44 2013
ARCi started with pid=40, OS id=4528
Thu Oct 17 10:55:44 2013
ARCj started with pid=41, OS id=4530
Thu Oct 17 10:55:44 2013
ARCk started with pid=42, OS id=4532
Thu Oct 17 10:55:44 2013
ARCl started with pid=43, OS id=4534
Thu Oct 17 10:55:44 2013
ARCm started with pid=44, OS id=4536
Thu Oct 17 10:55:44 2013
ARCn started with pid=45, OS id=4538
Thu Oct 17 10:55:44 2013
ARCo started with pid=46, OS id=4540
Thu Oct 17 10:55:44 2013
ARCp started with pid=47, OS id=4542
Thu Oct 17 10:55:45 2013
ARCq started with pid=48, OS id=4544
Thu Oct 17 10:55:45 2013
ARCr started with pid=49, OS id=4546
Thu Oct 17 10:55:45 2013
ARCs started with pid=50, OS id=4548
Thu Oct 17 10:55:45 2013
Full restore complete of datafile 4 /u01/data/orcl/users01.dbf.  Elapsed time: 0:00:01
  checkpoint is 25367678
Thu Oct 17 10:55:45 2013
ARCt started with pid=51, OS id=4550
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
ARC5: Archival started
ARC6: Archival started
ARC7: Archival started
ARC8: Archival started
ARC9: Archival started
ARCa: Archival started
ARCb: Archival started
ARCc: Archival started
ARCd: Archival started
ARCe: Archival started
ARCf: Archival started
ARCg: Archival started
ARCh: Archival started
ARCi: Archival started
ARCj: Archival started
ARCk: Archival started
ARCl: Archival started
ARCm: Archival started
ARCn: Archival started
ARCo: Archival started
ARCp: Archival started
ARCq: Archival started
ARCr: Archival started
ARCs: Archival started
ARCr: Becoming the 'no FAL' ARCH
ARCs: Becoming the heartbeat ARCH
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_lgwr_4265.trc:
ORA-00313: open failed for members of log group 7 of thread 1
ORA-00312: online log 7 thread 1: '/u01/data/orcl/standbyredo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 7 thread 1: '/u01/data/orcl/standbyredo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_lgwr_4265.trc:
ORA-00313: open failed for members of log group 7 of thread 1
ORA-00312: online log 7 thread 1: '/u01/data/orcl/standbyredo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 7 thread 1: '/u01/data/orcl/standbyredo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_lgwr_4265.trc:
ORA-00313: open failed for members of log group 8 of thread 0
ORA-00312: online log 8 thread 0: '/u01/data/orcl/standbyredo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 8 thread 0: '/u01/data/orcl/standbyredo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_lgwr_4265.trc:
ORA-00313: open failed for members of log group 8 of thread 0
ORA-00312: online log 8 thread 0: '/u01/data/orcl/standbyredo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 8 thread 0: '/u01/data/orcl/standbyredo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_lgwr_4265.trc:
ORA-00313: open failed for members of log group 9 of thread 0
ORA-00312: online log 9 thread 0: '/u01/data/orcl/standbyredo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 9 thread 0: '/u01/data/orcl/standbyredo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_lgwr_4265.trc:
ORA-00313: open failed for members of log group 9 of thread 0
ORA-00312: online log 9 thread 0: '/u01/data/orcl/standbyredo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 9 thread 0: '/u01/data/orcl/standbyredo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_lgwr_4265.trc:
ORA-00313: open failed for members of log group 10 of thread 0
ORA-00312: online log 10 thread 0: '/u01/data/orcl/standbyredo08.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 10 thread 0: '/u01/data/orcl/standbyredo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_lgwr_4265.trc:
ORA-00313: open failed for members of log group 10 of thread 0
ORA-00312: online log 10 thread 0: '/u01/data/orcl/standbyredo08.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 10 thread 0: '/u01/data/orcl/standbyredo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ARCt: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Full restore complete of datafile 3 /u01/data/orcl/undotbs01.dbf.  Elapsed time: 0:00:02
  checkpoint is 25367678
  last deallocation scn is 25351543
  Undo Optimization current scn is 25362244
Thu Oct 17 10:56:57 2013
Full restore complete of datafile 1 /u01/data/orcl/system01.dbf.  Elapsed time: 0:01:10
  checkpoint is 25367678
  last deallocation scn is 991580
  Undo Optimization current scn is 25362244
Full restore complete of datafile 2 /u01/data/orcl/sysaux01.dbf.  Elapsed time: 0:01:17
  checkpoint is 25367678
  last deallocation scn is 25309014
Thu Oct 17 10:57:51 2013
Full restore complete of datafile 5 /u01/data/orcl/cmtspay_ts.dbf.  Elapsed time: 0:01:33
  checkpoint is 25367678
  last deallocation scn is 21242535
Thu Oct 17 10:58:00 2013
Switch of datafile 1 complete to datafile copy
  checkpoint is 25367678
Switch of datafile 2 complete to datafile copy
  checkpoint is 25367678
Switch of datafile 3 complete to datafile copy
  checkpoint is 25367678
Switch of datafile 4 complete to datafile copy
  checkpoint is 25367678
Switch of datafile 5 complete to datafile copy
  checkpoint is 25367678
alter database clear logfile group 4
Clearing online log 4 of thread 1 sequence number 207
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '/u01/data/orcl/redo08.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 1: '/u01/data/orcl/redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '/u01/data/orcl/redo08.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 1: '/u01/data/orcl/redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Thu Oct 17 10:59:42 2013
Completed: alter database clear logfile group 4
alter database clear logfile group 5
Clearing online log 5 of thread 1 sequence number 206
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/u01/data/orcl/redo10.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 5 thread 1: '/u01/data/orcl/redo09.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/u01/data/orcl/redo10.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 5 thread 1: '/u01/data/orcl/redo09.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Thu Oct 17 11:00:25 2013
Completed: alter database clear logfile group 5
alter database clear logfile group 6
Clearing online log 6 of thread 1 sequence number 208
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 6 of thread 1
ORA-00312: online log 6 thread 1: '/u01/data/orcl/redo12.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 6 thread 1: '/u01/data/orcl/redo11.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 6 of thread 1
ORA-00312: online log 6 thread 1: '/u01/data/orcl/redo12.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 6 thread 1: '/u01/data/orcl/redo11.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Thu Oct 17 11:00:37 2013
Completed: alter database clear logfile group 6
alter database clear logfile group 7
Clearing online log 7 of thread 1 sequence number 0
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 7 of thread 1
ORA-00312: online log 7 thread 1: '/u01/data/orcl/standbyredo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 7 thread 1: '/u01/data/orcl/standbyredo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 7 of thread 1
ORA-00312: online log 7 thread 1: '/u01/data/orcl/standbyredo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 7 thread 1: '/u01/data/orcl/standbyredo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Thu Oct 17 11:01:00 2013
Completed: alter database clear logfile group 7
alter database clear logfile group 8
Clearing online log 8 of thread 0 sequence number 0
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 8 of thread 0
ORA-00312: online log 8 thread 0: '/u01/data/orcl/standbyredo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 8 thread 0: '/u01/data/orcl/standbyredo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 8 of thread 0
ORA-00312: online log 8 thread 0: '/u01/data/orcl/standbyredo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 8 thread 0: '/u01/data/orcl/standbyredo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Thu Oct 17 11:02:18 2013
Completed: alter database clear logfile group 8
alter database clear logfile group 9
Clearing online log 9 of thread 0 sequence number 0
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 9 of thread 0
ORA-00312: online log 9 thread 0: '/u01/data/orcl/standbyredo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 9 thread 0: '/u01/data/orcl/standbyredo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 9 of thread 0
ORA-00312: online log 9 thread 0: '/u01/data/orcl/standbyredo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 9 thread 0: '/u01/data/orcl/standbyredo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Thu Oct 17 11:03:37 2013
Completed: alter database clear logfile group 9
alter database clear logfile group 10
Clearing online log 10 of thread 0 sequence number 0
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 10 of thread 0
ORA-00312: online log 10 thread 0: '/u01/data/orcl/standbyredo08.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 10 thread 0: '/u01/data/orcl/standbyredo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_ora_4473.trc:
ORA-00313: open failed for members of log group 10 of thread 0
ORA-00312: online log 10 thread 0: '/u01/data/orcl/standbyredo08.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 10 thread 0: '/u01/data/orcl/standbyredo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Thu Oct 17 11:05:07 2013
Completed: alter database clear logfile group 10
RFS connections are allowed
Thu Oct 17 11:08:18 2013
RFS[1]: Assigned to RFS process 5065
RFS[1]: Identified database type as 'physical standby': Client is ARCH pid 6743
Thu Oct 17 11:08:19 2013
RFS[2]: Assigned to RFS process 5067
RFS[2]: Identified database type as 'physical standby': Client is ARCH pid 10069
Thu Oct 17 11:08:19 2013
RFS[3]: Assigned to RFS process 5069
RFS[3]: Identified database type as 'physical standby': Client is ARCH pid 6753
Thu Oct 17 11:08:19 2013
RFS[4]: Assigned to RFS process 5071
RFS[4]: Identified database type as 'physical standby': Client is ARCH pid 6751
Thu Oct 17 11:08:19 2013
RFS[5]: Assigned to RFS process 5073
RFS[5]: Identified database type as 'physical standby': Client is ARCH pid 6749
RFS[2]: Opened log for thread 1 sequence 208 dbid 1341321266 branch 813540533
RFS[4]: Opened log for thread 1 sequence 209 dbid 1341321266 branch 813540533
RFS[3]: Opened log for thread 1 sequence 211 dbid 1341321266 branch 813540533
Archived Log entry 1 added for thread 1 sequence 208 rlc 813540533 ID 0x4ff48d5e dest 2:
Archived Log entry 2 added for thread 1 sequence 209 rlc 813540533 ID 0x4ff48d5e dest 2:
RFS[5]: Opened log for thread 1 sequence 210 dbid 1341321266 branch 813540533
Archived Log entry 3 added for thread 1 sequence 211 rlc 813540533 ID 0x4ff48d5e dest 2:
Archived Log entry 4 added for thread 1 sequence 210 rlc 813540533 ID 0x4ff48d5e dest 2:
Thu Oct 17 11:08:21 2013
RFS[6]: Assigned to RFS process 5075
RFS[6]: Identified database type as 'physical standby': Client is LGWR ASYNC pid 7023
Primary database is in MAXIMUM PERFORMANCE mode
Thu Oct 17 11:08:21 2013
alter database open
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
Signalling error 1152 for datafile 1!
Beginning standby crash recovery.
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
RFS[6]: Selected log 7 for thread 1 sequence 212 dbid 1341321266 branch 813540533
Media Recovery Log /u01/data/orcl/arc/1_208_813540533.arc
Incomplete Recovery applied until change 25367715 time 10/17/2013 10:29:02
Completed standby crash recovery.
Thu Oct 17 11:08:23 2013
SMON: enabling cache recovery
RFS[6]: Selected log 8 for thread 1 sequence 213 dbid 1341321266 branch 813540533
Thu Oct 17 11:08:24 2013
Archived Log entry 5 added for thread 1 sequence 212 ID 0x4ff48d5e dest 1:
Archived Log entry 6 added for thread 1 sequence 212 ID 0x4ff48d5e dest 3:
Dictionary check beginning
Thu Oct 17 11:08:24 2013
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_dbw0_4263.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/data/orcl/temp01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/oracle/diag/rdbms/orcl2/orcl/trace/orcl_dbw0_4263.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/data/orcl/temp01.dbf'
File 201 not verified due to error ORA-01157
Dictionary check complete
Re-creating tempfile /u01/data/orcl/temp01.dbf
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Physical standby database opened for read only access.
Completed: alter database open
Thu Oct 17 11:09:06 2013
alter database recover managed standby database using current logfile disconnect from session
Attempt to start background Managed Standby Recovery process (orcl)
Thu Oct 17 11:09:06 2013
MRP0 started with pid=59, OS id=5100
MRP0: Background Managed Standby Recovery process started (orcl)
 started logmerger process
Thu Oct 17 11:09:11 2013
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 4 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /u01/data/orcl/arc/1_208_813540533.arc
Media Recovery Log /u01/data/orcl/arc/1_209_813540533.arc
Completed: alter database recover managed standby database using current logfile disconnect from session
Media Recovery Log /u01/data/orcl/arc/1_210_813540533.arc
Media Recovery Log /u01/data/orcl/arc/1_211_813540533.arc
Media Recovery Log /u01/data/orcl/arcsb/1_212_813540533.arc
Media Recovery Waiting for thread 1 sequence 213 (in transit)
Recovery of Online Redo Log: Thread 1 Group 8 Seq 213 Reading mem 0
  Mem# 0: /u01/data/orcl/standbyredo03.log
  Mem# 1: /u01/data/orcl/standbyredo04.log
Thu Oct 17 11:09:19 2013
RFS[7]: Assigned to RFS process 5116
RFS[7]: Identified database type as 'physical standby': Client is ARCH pid 6743

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26972107/viewspace-774525/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26972107/viewspace-774525/