I am trying to perform hot backup and recovery, the bckup was taken and then im getting this error.
iam using oracle 220.127.116.11.0 and on windows environment.
SQL> alter database open read only;
alter database open read only
ERROR at line 1:
ORA-16004: backup database required recovery
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\APP\USER\ORADATA\PROD3\SYSTEM01.DBF'
yes sir this is what im trying to do, previously 2 to 3 days before i have taken backup using rman it was successsful
now i ws trying to take hotbackup http://www.youtube.com/watch?v=O9kLA002qjY&feature=relmfu plz find this link it might get u whre im stuck
This error indicates you need to apply more archive redo log files to make it consistent.
Please copy few logs files generated between putting the database in hot backup and end backup mode and apply them.
Edited by: NC on Oct 14, 2012 7:49 PM
Do not use questionable videos for self education, or take them with a grain of criticism.
That author by some reason did not tell that some changes can be stored in redo logs that are not archived yet (for example in current active redo log).
You should recover these changes if you want "to the last change" recovery. You can recover these changes two ways:
- Standard way - using recovery without "backup controlfile" option, where Oracle will use existing controlfile.
- If you use "backup controlfile" for some reason, you should specify not archived redo log(s) when Oracle asks for non-existing archived log file.
Otherwise you will loose changes that are not in archived logs.
I mean that what I saw in youtube is named "User Managed Backup". Not a "hotbackup".
"User Managed Backup" can be online and offline (hot and cold).
Using the term "hotbackup" confused me, I thought id was a 3-rd party product name.