Thursday, November 24, 2022

RMAN-06172:


RMAN> restore controlfile from '/home/oracle/dms_mount/RMAN/STB02/stb02control.ctl';

Starting restore at 26-OCT-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6273 instance=dbm02_dg device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 10/26/2022 10:20:18

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Solution ->

The controlfile was on shared storage.
It is require to copy the controlfile to a local disk.

cp /home/oracle/dms_mount/RMAN/STB02/stb02control.ctl /tmp/


RMAN> restore controlfile from '/tmp/stb02control.ctl';

Starting restore at 26-OCT-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6900 instance=dbm02_dg device type=DISK
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=3 instance=dbm02_dg device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup

channel ORA_SBT_TAPE_1: skipped, AUTOBACKUP already found
channel ORA_DISK_1: copied control file copy
output file name=+DATA/dbm02_dg/controlfile/dbm02_stby.ctl
output file name=+REDO/dbm02_dg/controlfile/dbm02_stby.ctl
Finished restore at 26-OCT-22

RMAN>

No comments:

Post a Comment