Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can we resume/rerun RMAN duplicate after fixing issue at recover part ?

user12134799Jul 31 2014 — edited Aug 6 2014


hi,

We got error while the cuplicate is at recover part of the duplicate in our 11.2.0.3 DB duplicate, it was space issue, we cleared space. Now can we rerun the duplicate or should we do it manually? Please help, below is the error message we got before we fixed the space.

regards

Gopal

++

RMAN-06731: command restore:97.8% complete, time left 00:06:48
RMAN-06731: command restore:98.5% complete, time left 00:04:34
RMAN-06731: command restore:99.4% complete, time left 00:01:56
RMAN-08611: channel C1: piece handle=/nfsmount/rman_backup/ORPOGDD1_db_u87pdneei
_s263_p1_t853260754_db tag=ORPOGDD1_HOT
RMAN-08023: channel C1: restored backup piece 1
RMAN-08180: channel C1: restore complete, elapsed time: 05:02:19
RMAN-03091: Finished restore at 30-JUL-14
RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ERPPGFB1" RESE
TLOGS NOARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      2
  MAXDATAFILES     1024
  MAXINSTANCES     1
  MAXLOGHISTORY     4090
LOGFILE
RMAN-08015: datafile 582 switched to datafile copy
RMAN-08507: input datafile copy RECID=350 STAMP=854318140 file name=+ERPPGFB1_DA
TA/erppgfb1/apps_ts_tx_idx_lg08.dbf
RMAN-08015: datafile 583 switched to datafile copy
RMAN-08507: input datafile copy RECID=351 STAMP=854318140 file name=+ERPPGFB1_DA
TA/erppgfb1/apps_ts_tx_idx_lg09.dbf
RMAN-08015: datafile 584 switched to datafile copy
RMAN-08507: input datafile copy RECID=352 STAMP=854318140 file name=+ERPPGFB1_DA
TA/erppgfb1/apps_ts_tx_idx_lg10.dbf
RMAN-08015: datafile 585 switched to datafile copy
RMAN-08507: input datafile copy RECID=353 STAMP=854318140 file name=+ERPPGFB1_DA
TA/erppgfb1/apps_ts_tx_idx_lg11.dbf
RMAN-08015: datafile 586 switched to datafile copy
RMAN-08507: input datafile copy RECID=354 STAMP=854318140 file name=+ERPPGFB1_DA
TA/erppgfb1/apps_ts_tx_idx_lg12.dbf
RMAN-08015: datafile 587 switched to datafile copy
RMAN-08507: input datafile copy RECID=355 STAMP=854318140 file name=+ERPPGFB1_DA
TA/erppgfb1/apps_ts_tx_idx_lg13.dbf

RMAN-08161: contents of Memory Script:
{
   recover
   clone database
   noredo
   ,
    delete archivelog
   ;
}
RMAN-08162: executing Memory Script

RMAN-03090: Starting recover at 30-JUL-14
RMAN-03091: Finished recover at 30-JUL-14

RMAN-08161: contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount ;
}
RMAN-08162: executing Memory Script

RMAN-08031: released channel: C2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/30/2014 22:37:53
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-10997: another startup/shu
tdown operation of this instance inprogress
ORA-09967: unable to create or open lock file
SVR4 Error: 28: No space left on device

RMAN>
RMAN> **end-of-file**

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2014
Added on Jul 31 2014
7 comments
3,398 views