Skip to Main Content


User_T8VTCJan 24 2022

hello i new to rman and im trying to recover A pluggable database with "recover pluggable database "
before i issue a recover pluggable database command i do these following steps:
1.backup the pluggable database with incremental backup+autobackup
2.shutdown the database
3.delete controlfile from cdb and all file from pdb i wanted to recover(because i wanted to simulate restoring pdb when missing the control file are missing)
4.rman target / and issued startup no mount
5.after that i restore the controlfile from the autobackup(which generated when i do an incremental backup on pdb)
6.then i mount the db and issue restore pluggable database
7.after all file di pdb and controlfile in cdb restored i run "recover pluggable database " but when i run this command an error happen

RMAN> recover pluggable database pdb;

Starting recover at 23-JAN-22

using channel ORA_DISK_1

RMAN-00571: ===========================================================

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

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 01/23/2022 23:59:47

RMAN-06067: RECOVER DATABASE required with a backup or created control file

what causing this error and how to fix it? i already restore the controlfile from backup and this error still occured. do i have to backup both cdb and pdb in order to recover the pdb when the controlfile are missing?

Post Details
Added on Jan 24 2022
1 comment