Friday 25 September 2009

Rman Unregister database

I have taken a cold backup of my "test" database. The current archive log sequence is as below
Oldest online log sequence 1053
Next log sequence to archive 1057
Current log sequence 1057

This database is registered with the rman catalog.

After using the database for 10 days i wanted to restore the database to my old flat file backup. But current log sequence is as below

Oldest online log sequence 1105
Next log sequence to archive 1109
Current log sequence 1109

The current archive log sequence is higher than the restored database log sequence So the rman backup with catalog will fail.

So as i have registered the database with rman catalog. i need to resync the database.

Connect to the rman catalog and target database and execute the below commands

rman>unregister database;

rman>register database;

These commands will unregister and re-register the database in the rman catalog.

Now check the latest backup in the catalog database

rman>list backup;

The lastest backup shown is the backup taken before the cold backup which is resynced with the database controlfile.

No comments: