duplicate ORA-01405: fetched column value is NULL

lovehewenyu發表於2013-08-07

DG 用 rman  duplicate 恢復standby 的問題及解決。

SQL> startup nomount pfile=/opt/oracle/product/10g/dbs/initorcl.ora
LRM-00123: invalid character 148 found in the input file
ORA-01078: failure in processing system parameters

RMAN> duplicate target database for standby nofilenamecheck dorecover;

Starting Duplicate Db at 28-MAR-12
using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/28/2012 12:18:13
ORA-01405: fetched column value is NULL


解決方法主庫: alter system switch logfile;

 

RMAN> duplicate target database for standby nofilenamecheck dorecover;

Starting Duplicate Db at 28-MAR-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=155 devtype=DISK

contents of Memory Script.:
{
   set until scn  485861;
   restore clone standby controlfile;
   sql clone 'alter database mount standby database';
}
executing Memory Script

executing command: SET until clause

Starting restore at 28-MAR-12
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/dgdb1_02n70jpe_1_1_20120328
ORA-19870: error reading backup piece /u01/backup/dgdb1_02n70jpe_1_1_20120328
ORA-19505: failed to identify file "/u01/backup/dgdb1_02n70jpe_1_1_20120328"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/28/2012 12:20:16
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> restore database validate;

Starting restore at 28-MAR-12
using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile backupset
channel ORA_DISK_1: reading from backup piece /u01/backup/dgdb1_07n70li1_1_1_20120328
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/backup/dgdb1_07n70li1_1_1_20120328 tag=TAG20120328T123409
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
Finished restore at 28-MAR-12


驗證控制檔案不可用,是我們備份的指令碼有問題。換了一個資料備份指令碼 OK 了
RMAN> restore controlfile validate;

Starting restore at 28-MAR-12
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/28/2012 12:34:50
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

 

SQL> ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/opt/oracle/oradata/research/redo04.log') size 50M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/opt/oracle/oradata/research/redo04.log') size 50M
*
ERROR at line 1:
ORA-01156: recovery in progress may need access to files

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26442936/viewspace-767943/,如需轉載,請註明出處,否則將追究法律責任。

相關文章