| RMAN Restore Failure [message #589005] |
Mon, 01 July 2013 07:04  |
mitra.kausik
Messages: 21
Registered: June 2006
|
Junior Member |
|
|
Hi Gurus
I am facing an issue while rebuilding a DR (Physical Standby) site using RMAN.
Rman is failing to restore all the datafiles to the stanby site.
There are 403 datafiles that should be restored among which after restoring 50-60 datafiles the channel is abruptly getting terminated.
Please note this exercise is not new I have done this many times (once a year after a DR testing) and the same script is being used.
The rcv file is as follows
/u03/oracle/admin/mpr/scripts/dataguard/configure_dr.rcv
connect auxiliary sys/XXXX@YYY
run {
duplicate target database for standby nofilenamecheck dorecover;
}
exit
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
configure_dr.rcv: END
The log says
channel ORA_AUX_DISK_1: reading from backup piece /ora/MPR/db_backup1/rman/dguard/d-2504592695-20130625-67od2i33_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/26/2013 15:03:40
RMAN-03015: error occurred in stored script Memory Script
RMAN-10038: database session for channel ORA_AUX_DISK_1 terminated unexpectedly
The trace file says "krso_proc_add: Detected dead process 13828326; subsuming V$MANAGED_STANDBY slot
INFO: krsr_rfs_atc: RFS processes are temporarily disallowed"
I have also started RMAN debug tracing and the trace is also scanned as it is huge I have not uploaded here please let me know if anybody needs that for diagnosing . I have seen the following in the trace
error 3015 signalled during compilation
I do not find any specific oracle error to check on .
The only change that happened is that the Primary production server has been moved to a new datacentre and after its move all the connections seems to be working fine.
Any early response is highly appreciated.
Thanks and Regards
[Updated on: Mon, 01 July 2013 07:14] Report message to a moderator |
|
|
|
|
|
| Re: RMAN Restore Failure [message #589019 is a reply to message #589007] |
Mon, 01 July 2013 08:11  |
mitra.kausik
Messages: 21
Registered: June 2006
|
Junior Member |
|
|
DBGSQL: TARGET> begin sys.dbms_backup_restore.commitRmanStatusRow( row_id => :row_id, row_stamp => :row_stamp, mbytes => :mb, status => :statu
s, ibytes => :ib, obytes => :ob, odevtype => :odevtype); end;
DBGSQL: sqlcode = 0
DBGSQL: B :row_id = 12114
DBGSQL: B :row_stamp = 819458081
DBGSQL: B :mb = 0
DBGSQL: B :status = 4
DBGSQL: B :ib = 0
DBGSQL: B :ob = 0
DBGSQL: B :odevtype =
DBGMISC: EXITED krmkmrsr [14:36:46.517] elapsed time [00:00:00:00.337]
DBGMISC: krmicomp: error 3015 signalled during compilation [14:36:46.517]
DBGMISC: ENTERED krmkmrsr [14:36:46.517]
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
