This content has been marked as final. Show 1 reply
1 person found this helpful
Lets say I have 2 DB backups, B1(Taken at *10am*), B2(Taken at *11am*).restore it from B2, because controlfile from B1 has no info about archivelogs needed to recover till 10:30
I want to perform database point in time recovery till *10:30* am.
I have these doubts related to retrieving correct control file for recovery :
1. Should I take control file from B1 or B2 ? Which control file will have information required to recover till 10:30 am ?
2. Can I recover multiple times using control file from B1 or B2(assuming that each time I properly reset the DB incarnation each time) ?yes, you can
3. Should I recover control file from AUTOBACKUP ? What difference does it make retrieving control file from AUTOBACKUP or from a manually specified control file locations(say from B1 or B2) ?autobackup means default destination for controlfile autobackups in Fast Recovery Area, or, if you connect to catalog, location specified by "configure controlfile autobackup"
Edited by: Mihael on 10.03.2013 4:36