Home » RDBMS Server » Server Administration » RMAN Restore Failure (OS: AIX Oracle version:11.2.0.1)
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
|
|
|
|
|
|
Goto Forum:
Current Time: Thu May 01 21:55:58 CDT 2025
|