Identify target database

How do you identify what are the all the target databases that are being backed-up with RMAN database?

Questions by shanthiavari

Showing Answers 1 - 20 of 20 Answers

You dont have any view to identifiy whether it is backed up or not . The only option is connect to the target database and give list backup, this will give you the backup information with date and timining.

  Was this answer useful?  Yes

dbxplorer

  • Jul 24th, 2011
 

You only can get information about one particular database at a time, after connecting with RMAN using target as that particular database.
Suppose there are three db A,B,C.

RMAN> connect target userA/pwd

Now whatever query you will execute will only give information about that database A only.

  Was this answer useful?  Yes

mahendra

  • Aug 10th, 2011
 

connect to the catalog database and issue following query. it will list the target databases registered and manged by the catalog databases.

SQL> select name,dbid from rc_database;

  Was this answer useful?  Yes

syed

  • Apr 21st, 2015
 

list db_unique_name all;

  Was this answer useful?  Yes

gopi

  • Mar 21st, 2017
 

Connect to Target and list backup

  Was this answer useful?  Yes

nanda

  • Jun 20th, 2017
 

rman> list db_unique_name all;

  Was this answer useful?  Yes

zakir

  • Jun 21st, 2017
 

We can find out from catalog database.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions