Home » RDBMS Server » Backup & Recovery » Database Registered in RMAN
Database Registered in RMAN [message #188076] Wed, 16 August 2006 23:42 Go to next message
b1b2
Messages: 5
Registered: July 2006
Junior Member
Hi,

How do I list or check what database or databases are currently registered in the RMAN repository. Is there such a command in RMAN that gives this list or do I have to directly query the RMAN repository using SQL statements?

Thanks in advance.


Re: Database Registered in RMAN [message #188137 is a reply to message #188076] Thu, 17 August 2006 04:22 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


I guess RMAN respository is the only option and the view to check this would be RC_DATABASE.

Others can correct me if wrong...
Re: Database Registered in RMAN [message #188296 is a reply to message #188137] Thu, 17 August 2006 18:43 Go to previous message
b1b2
Messages: 5
Registered: July 2006
Junior Member
Hi tarundua,

Thanks for your response. The real reason for me wanting to do this is becausae in my new job in a new company, backups of RMAN-TIVOLI are often running out of space and I suspect that there may be some old records in my RMAN repository that are not flagging the backup history in TIVOLI as obsolete or expired and thus not allowing them to be overwritten by TIVOLI and had stayed there forever.

I have 2 RMAN repositories, ORACLE8 and ORACLE10. Since I cannot find any RMAN commands that list what current database/s are registered on my repository. I did a query on the RC_DATABASE instead.


ORACLE8 :

SQL> select dbid, name, resetlogs_time from rc_database;

DBID NAME RESETLOGS_TIME
---------- -------- --------------------
3226173629 MYDB 16-JUL-2004 16:40:29
3226775477 MYDB 23-JUL-2004 15:51:17
3234555138 MYDB 20-OCT-2004 16:52:18

ORACLE10 :

SQL> select dbid, name, resetlogs_time from rc_database;

DBID NAME RESETLOGS_TIME
---------- -------- --------------------
3234555138 MYDB 10-MAR-2006 15:40:30
2226432294 MYDB 06-AUG-2006 08:07:39

Due to company policy, I rename the result set and replace the name of the database as MYDB.

I am assuming that the result set I get is a list of databases that the RMAN repository is aware of and maintaining the backups for. If this is the case, as you can see, the latest registered MYDB that I am interested with is the one ORACLE10, 2226432294 MYDB 06-AUG-2006 08:07:39, and I want to de-register or unregister the rest.

Can someone tell me how to de-register the old ones? I vaguely remember that it is RMAN>unregister [DBID] or is that unregister [DBNAME]? Can I check if there are existing backups for these other registered databases before I unregister them? Not that I want to jeep them since they are long way old already but I want to check if they will be removed after I unregister the database or whether I have to do a crosscheck afterward. The RMAN>LIST BACKUP only list for the current target database that you are connected to so how can I do a LIST BACKUP for a database that is of a different [DBID].

My assumption is if a database of the same name has a new [DBID], RMAN does not do an automatic "crosscheck" and delete or expired the backups from when the database is on its previous DBID and if my assumption is true, then that is the one causing TIVOLI to think that the old backups on the old [DBID] cannot be overwritten yet because I never unregister the database. Thus the space that TIVOLI could have used are now never over-written unless I unregister those databases having old DBIDs.

I have another database that is doing RMAN backup with NOCATALOG, i.e. using the control file as the catalog. In that scenario, how do I query the RMAN metadata or can someone tell me what are the V$ views to query if I am doing RMAN backups as NOCATALOG.

The SAP-BRTOOLS-RMAN backup is not using a catalog because no one knows how to do SAP-BRTOOLS-RMAN backup using a CATALOG. If someone on this forum managed to be able to do so, please provide me with the steps on how you are able to do so.

Hopefully, more people will read my post so I can sort this out ASAP.

Thanks in advance.

Previous Topic: recovery
Next Topic: SAP-BRTOOLS-RMAN-TIVOLI - please help
Goto Forum:
  


Current Time: Sat Dec 03 13:46:32 CST 2016

Total time taken to generate the page: 0.24798 seconds