Hello All,
Its pretty common question which all DBA's have an answer. I know what it does not but what I find to hard to understand is as follows.
If I have to restore database using an rman online full backup (oracle documentation says - rman online backups are inconsistent )
it asks for more archive ( RMAN-060504 - media recovery ) , sometimes it even prompts you to keep on applying the archived redo logs
to make your database consistent. Is there any way/method/views using which you can restore db without having to open database
with resetlogs using only online full backups.
Few other questions what I have are as follows.
1) how does it actually decides when to make the database consistent ?
2) what best I can do to avoid or not having to use ''Alter database open resetlogs " .with full online backups only.
Thanks
Mohammed
Oracle DBA