Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN not showing controlfile backupset once database recovered

Alex2068Jul 2 2019 — edited Jul 4 2019

My non-cdb 12.2 database is noarchivelog mode.

Also, RMAN is set: CONFIGURE CONTROLFILE AUTOBACKUP OFF;

When mounted, I did back it up. As a result.

RMAN> list backup summary;

List of Backups

===============

Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- --------------- ------- ------- ---------- ---

1       B  F  A DISK        27-JUN-19       1       1       NO         BEFORE IMPORT

2       B  F  A DISK        27-JUN-19       1       1       NO         BEFORE IMPORT

After some time I decided to restore this database.

I set this database in nomount state, restore controlfile from backupset 2, then I mount it and I restore the database.

When I now list my backups, there is only one file being shown (backupset 1). The one with controlfile is missing (backupset 2) though it is still physically on the backup device.

RMAN> list backup summary;

List of Backups

===============

Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- --------------- ------- ------- ---------- ---

1       B  F  A DISK        27-JUN-19       1       1       NO         BEFORE IMPORT

Why is that, and does it mean I cannot repeat database restoration the same way I did for the very first time described above?

Comments
Post Details
Added on Jul 2 2019
8 comments
2,531 views