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 Go to next message
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 #589007 is a reply to message #589005] Mon, 01 July 2013 07:19 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what's around the error message.
Otherwise you have to open a SR to Oracle which will analyze your (big) trace file.

Regards
Michel
Re: RMAN Restore Failure [message #589019 is a reply to message #589007] Mon, 01 July 2013 08:11 Go to previous messageGo to next message
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]
Re: RMAN Restore Failure [message #589161 is a reply to message #589019] Wed, 03 July 2013 00:17 Go to previous message
mitra.kausik
Messages: 21
Registered: June 2006
Junior Member
Any help on this please ?

[Updated on: Wed, 03 July 2013 00:18]

Report message to a moderator

Previous Topic: ORA-01506
Next Topic: Materialized View Issue
Goto Forum:
  


Current Time: Fri Dec 19 00:55:32 CST 2014

Total time taken to generate the page: 0.10654 seconds