Forum Stats

  • 3,836,735 Users
  • 2,262,175 Discussions
  • 7,900,088 Comments

Discussions

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

User_R0EYL
User_R0EYL Member Posts: 7 Green Ribbon

HI There,

I have Oracle 19c(Version 19.11.0.0.0) database running on RedHat Linux and I have backed up with following command.

run{

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!

Regards,

Ram

Answers