query to get files needed for recovery...
776823Jan 13 2012 — edited Jan 13 2012i am on 11.2.0.1 both the trgt db and recovery catalog and i wanted to find outwhat query can i ran to get the backup files i need...
so lets say i want to restore my database back to Jan-11-2012 14:00 hours...
so what query do i have to run to find out what are the backup files i need?? The reason for this is...backup are done on tape and tape drives are send offsite once backup is done...so we need to find out these are the backup file needed for restore/recovery and can be found on this tape...so what to query to get that info ??
query should return backup files needed(lets say level 0 backup, level 1 backup peiece, archive log backup peices etc etc )...