Skip to content
Home » Oracle » How RMAN List Backup in Standby DB

How RMAN List Backup in Standby DB

Recently, I created a controlfile for standby database in the primary database. After I mounted the newly created controlfile in the standby database. I tested it by RMAN like this:

$ rman target /
connected to target database: ORCL (DBID=3469582309)

RMAN> list backup of database summary;

using target database controlfile instead of recovery catalog

List of Backups
Key     TY LV S Device Type Completion Time     #Pieces #Copies Tag
------- -- -- - ----------- ------------------- ------- ------- ---
7437    B  0  A SBT_TAPE    2014-11-07 11:44:51 1       1       ORCL_FUL_BK
7438    B  0  A SBT_TAPE    2014-11-07 14:02:14 1       1       ORCL_FUL_BK
7439    B  0  A SBT_TAPE    2014-11-07 17:29:42 1       1       ORCL_FUL_BK


Good! because the next job that I was planning to do is to restore the standby database. I can just copy the required backup sets from the primary database to the same backup path for restoring all data files without connecting to the recovery catalog database. RMAN can utilize them automatically to restore and recover the standby database. If you were trying to re-catalog a backup set in Oracle 9i, this could be an alternative for you to solve your situation.

Leave a Reply

Your email address will not be published. Required fields are marked *