t Waiting for ksv slaves to exit Waiting for ksv slaves to exit Waiting for ksv slaves to exit Waiting for ksv slaves to exit KCBR: Redo cache copies/changes = 2/2 *** 2015-10-14 19:34:33.133 Completed Media Recovery Checking to start in-flux buffer recovery from SCN 2.2960216998 to SCN (non-inclusive) 2.2960217494 Influx recovery found in-flux buffers *** 2015-10-14 19:34:33.136 Influx Media Recovery add redo thread 1 *** 2015-10-14 19:34:41.722 *** 2015-10-14 19:34:41.722 1266 krsm.c Managed Recovery: Not Active posted. ORA-00448: normal completion of background process [oracle@localhost ~]$
3，看到是文件1_38052_821708334.dbf坏块，通过dbv检查
[oracle@localhost ~]$ dbv /data/oracle/oradgdata/standby_archive/1_38052_821708334.dbf DBVERIFY: Release 11.2.0.1.0 - Production on Wed Oct 14 22:46:20 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. LRM-00108: invalid positional parameter value '/data/oracle/oradgdata/standby_archive/1_38052_821708334.dbf' DBV-00001: Illegal command line syntax - parse error = (108) [oracle@localhost ~]$
Google出来的解决方案：
shutdown the ADG standby, then mount it, and do media recovery until it has recovered past all the redo generated during the hot backup taken on the primary. Then stop media recovery, and open the database read only, and restart media recovery again.
采用解决方案：duplicate 远程恢复。
4， 关闭standby库
4.1 开始关闭standby库
SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL>
4.2 在standby上删除数据文件和控制文件
去数据文件目录和控制文件目录删除数据文件控制文件，如果一时不记得目录位置，可以通过以下方式查询
select * from v$controlfile; select * from v$datafile;
4.3 再standby上删除归档目录下的旧归档文件
cd /data/oracle/oradgdata/standby_archive/ rm -rf *.dbf
4.4 在standby上启动nomount
SQL> startup nomount ORACLE instance started. Total System Global Area 5344731136 bytes Fixed Size 2213136 bytes Variable Size 3489663728 bytes Database Buffers 1811939328 bytes Redo Buffers 40914944 bytes SQL>
4.5 在primary上操作
主库上
rman target sys/oraclepwd@XTTTESTDB.46 auxiliary sys/oraclepwd@XTTTESTDB.54
rman sys/你的sys密码@46是主库tns auxiliary sys/你的sys密码@54是备库tns
[oracle@localhost ~]$ rlwrap rman target / auxiliary sys/sysplxxx58@PD_DG rlwrap: warning: your $TERM is 'xterm' but rlwrap couldn't find it in the terminfo database. Expect some problems. Recovery Manager: Release 11.2.0.1.0 - Production on Mon Oct 19 17:33:15 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: POWERDES (DBID=3391761643) connected to auxiliary database: POWERDES (not mounted) RMAN> duplicate target database for standby from active database nofilenamecheck; RMAN> duplicate target database for standby from active database nofilenamecheck; Starting Duplicate Db at 19-OCT-15 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=482 device type=DISK contents of Memory Script: { backup as copy reuse targetfile '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/orapwpowerdes' auxiliary format '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/orapwpowerdes' ; } executing Memory Script Starting backup at 19-OCT-15 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=494 device type=DISK Finished backup at 19-OCT-15 contents of Memory Script: { backup as copy current controlfile for standby auxiliary format '/home/oradata/powerdes/contro