Home » RDBMS Server » Backup & Recovery » backups and DBID (Oracle 11g r2)
backups and DBID [message #486843] Mon, 20 December 2010 10:52 Go to next message
vostrushka@gmail.com
Messages: 2
Registered: August 2009
Junior Member
I try to estimate chances to correct a mistake of changing the DBID for the database that already has backup history in RMAN. The old database was and is perfectly registered in RMAN catalog.
Is it possible to make backups for old DBID available for new DBID?
Is it possible to put back the previous ID and make old backups available again?
Leonid
Re: backups and DBID [message #486844 is a reply to message #486843] Mon, 20 December 2010 11:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is it possible to make backups for old DBID available for new DBID?

No.

Quote:
Is it possible to put back the previous ID and make old backups available again?

No, not in a supported way.

Regards
Michel
Re: backups and DBID [message #486851 is a reply to message #486843] Mon, 20 December 2010 13:22 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
vostrushka wrote on Mon, 20 December 2010 11:52

Is it possible to make backups for old DBID available for new DBID?

Why would you want to do that?

If you need to restore from old DBID backup, you can only restore until the last backup for that DBID.

Else if you restore from new DBID backups the earliest will start from first backup you took after changing the DBID.

I do not see a need to do "cross-dbid" restore, which cannot be done due to opening the database with "reset logs" at the time the DBID was changed.




[Updated on: Mon, 20 December 2010 14:11] by Moderator

Report message to a moderator

Re: backups and DBID [message #486852 is a reply to message #486851] Mon, 20 December 2010 14:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Restore/recover across reset logs can be done since a couple of versions.

Regards
Michel
Re: backups and DBID [message #486855 is a reply to message #486852] Mon, 20 December 2010 15:33 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Cool...But what about across diff DBID?

[Updated on: Mon, 20 December 2010 23:14] by Moderator

Report message to a moderator

Re: backups and DBID [message #486857 is a reply to message #486843] Mon, 20 December 2010 16:10 Go to previous messageGo to next message
vostrushka@gmail.com
Messages: 2
Registered: August 2009
Junior Member
Seems like a fatal mistake, then. Backups for the old DBID become useless for the database with new DBID.
Thank you all.
Regards
Leonid
Re: backups and DBID [message #486861 is a reply to message #486855] Mon, 20 December 2010 23:14 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LKBrwn_DBA wrote on Mon, 20 December 2010 22:33
Cool...But what about across diff DBID?

Just read my previous answer.

Regards
Michel

Previous Topic: MAXPIECESIZE configuration not working
Next Topic: Confusion of Archive log generation and RMAN backup
Goto Forum:
  


Current Time: Thu Mar 28 14:46:22 CDT 2024