Skip to Main Content

RMAN-06172 while restoring control file from RMAN backup to different server in Oracle 19c.

User_R0EYLFeb 1 2022

HI There,
I have Oracle 19c(Version database running on RedHat Linux and I have backed up with following command.
allocate channel ch1 device type disk;
backup as compressed backupset database format '/opt/app/BKP/server1/rman/hotbackup/test/fullback_%T_%U'
plus archivelog format '/opt/app/BKP/server1/rman/hotbackup/test/archive_%T_%U';
backup current controlfile format '/opt/app/BKP/server1/rman/hotbackup/test/controlbkp_%T_%U';
release channel ch1;
The backup ran successfully .
Following are the files were generated by the backup command:
-rw-------. 1 oracle dba 608541184 Feb 2 01:25 archive_20220202_850kpngg_261_1_1
-rw-------. 1 oracle dba 940089344 Feb 2 01:25 fullback_20220202_860kpnj5_262_1_1
-rw-------. 1 oracle dba 600440832 Feb 2 01:26 fullback_20220202_870kpno0_263_1_1
-rw-------. 1 oracle dba 19103744 Feb 2 01:26 controlbkp_20220202_890kpnqd_265_1_1 --< includes the control file
-rw-------. 1 oracle dba 19103744 Feb 2 01:26 controlbkp_20220202_830kpnbs_259_1_1
-rw-------. 1 oracle dba 180224 Feb 2 01:26 archive_20220202_880kpnqc_264_1_1
Then I transferred these files to new server where I want to restore the database, There I have copied init file,spfile as well password files.
I started the database in nomount mode successfully using my init file. But when i issued the following restore controlfile command then it errored out.
RMAN> restore controlfile from '/u02/app/server1/controlbkp_20220202_890kpnqd_265_1_1';

Starting restore at 02-FEB-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1221 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/02/2022 01:30:45
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
Any idea how this issue can be resolved?
Please help me as this is very urgent and a high priority project work.
Thank you for your help in advance!

Post Details
Added on Feb 1 2022