ORA-01195:online backup of file needs more recovery to be consistent ORA-01110:data file
The thing is that I am using netapps backup. In the script itself, written after ending the backup, is alter database backup control to c:.....*.bak But whatever clone I have done before, I used the change the certain things in trace file, for e.g, in place of reuse I used to write set, but here, scripts is already written. Could you help me?
ALTER DATABASE RECOVER UNTIL CANCEL;
When prompted for a log, give the database the first archived redo log name and location.
Repeat for each archived redo log
When the last log has been applied, answer CANCEL
ALTER DATABASE OPEN RESETLOGS;
Dig Deeper on Oracle database administration
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading