Forum Stats

  • 3,815,638 Users
  • 2,259,064 Discussions
  • 7,893,194 Comments

Discussions

PDB BACKUP FAILED

User_T8VTC
User_T8VTC Member Posts: 2 Green Ribbon

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?

thanks

Tagged:

Answers

  • AJ
    AJ Member Posts: 1,350 Silver Trophy

    Restore controlfile must be followed by a recover database and at last open resetlogs even if no data files has been restored. In other words, you need to "recover database" which would also recover the PDBs.



    AJ