Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

 
 
 
 Category : Home > Databases > Oracle > RMAN     

How to get list of backed up data files from RMAN catalogue schema


To get a list of datafiles with sizes in Kb for the current incarnation of a database (in this
example TESTDB) directly from RMAN catalogue database - login as the catalogue schema owner
and run the query below:

select d.NAME || ',' || d.BYTES/1024 as name_kb
from RC_DATAFILE d, RC_DATABASE_INCARNATION i
where d.DB_NAME = 'TESTDB'
and d.DB_KEY    = i.DB_KEY
and d.DBINC_KEY = i.DBINC_KEY
and d.DB_NAME   = i.NAME
and i.CURRENT_INCARNATION = 'YES'
order by d.BYTES desc;

To get a list of online redo logs run the following sql query:

select rr.name
from rc_redo_log rr, rc_database rdb
where rr.db_name = rdb.name
and rr.dbinc_key = rdb.dbinc_key
and rr.db_key = rdb.db_key
and rr.db_name = 'TESTDB';


  Options
 
   del.icio.us  |  newsvine  |  digg  |  furl  |  google  |  yahoo  |  Ma.gnolia  |  vigillar  |  reddit  |  technorati  |  icerocket  |  pubsub

       Rate this tip:    

Start discussion or add comment to this tip

  Details
Tip reference : #209
views : 274
Added on : 09/10/08
Submited by : h8dk97
 
Send a message Send a message Printer friendly output Printer friendly output
Display this member's tips Display this member's tips (172)
 
 
<< Previous Next >>
 Most viewed tips 
  Databases > Oracle > Security : How to unlock Oracle user account  
  Operating Systems > Unix : How to kill Unix user session  
  Databases > Oracle > Performance Tuning : How to enable trace in Oracle  
  Databases > Oracle : Kill user session  
   
  All categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Office Software | TipLib FAQ
 
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com