Database Backup and Recovery (MOSC)

MOSC Banner

rmand DELETE BACKUP deletes catalog entries but not actual files.

edited Jul 26, 2017 12:11PM in Database Backup and Recovery (MOSC) 8 commentsAnswered

Oracle 11.2.0.4.0 SE-One, 64bit

Oracle Linux 6

"Executive Brief" sequence

1) take an archival backup (KEEP UNTIL) of a test database

2) re-create the test db via rman DUPLICATE DATABASE, using rman backup of prod database.  This, of course, creates a new db with a new dbid.

3) Attempt to delete the archival backup.  From RMAN:

3.1) Since we have to issue a SET DBID, we cannot connect to a mounted or open database, so start a "dummy" instance in NOMOUNT

3.2) set the dbid to that of the database that was backed up

3.3) issue rman DELETE DATABASE command.  Completes with no error and reports backup pieces that were deleted.

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