Database Administration (MOSC)

MOSC Banner

Pluggable Database Cold Backup and Restore Recover

edited Aug 27, 2021 10:30AM in Database Administration (MOSC) 17 commentsAnswered

We were following: RMAN Pluggable Database Backup and Recovery in a Multitenant Environment (Doc ID 1521005.1)

And took a PDB level Cold Backup(as this is a Non Archivelog Enabled Database) as per follows:

  1. Make whole CDB in Mount State
  2. RMAN bakcup of PDB:

rman target /

backup pluggable database POCIDM;

And it was success.

After that opened the whole CDB and PDB for Use.


After some time we needed to restore POCIDM PDB for some Application issue and hence trying:

rman target /

RMAN> RESTORE PLUGGABLE DATABASE POCIDM;

RMAN> ALTER PLUGGABLE DATABASE POCIDM open;

Not doing recovery as its Cold Backup. But its is failing with:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center