Thanks Guys,
Probably i will upgrade to 8.0.5 and then use RMAN.
I did not find the Oracle documentation to be very exhaustive.
One final query, if in RMAN, i am operating in NOARCHIVELOG mode, then can i use the incremental level backups of RMAN, and later restore the database using one 0 level and a couple of level 1 or 2 backups?
I have this doubt for the documentation said that datafiles are restored only from level 0 or full backups, rest is only recovery using archived redologs/incremental backups.
In noarhcivelog mode, i will have no log files to apply, and am willing to open the database using reset logs provided RMAN can recreate the datafiles.
Also, will it allow me to restore the database upto a particular time, something akin to recover until time command. I will have daily level 1 or level 2 backups taken in noarchive log mode with the database cleanly brought down.
I want the limited flexibility of recreating the database to any of those days/time when the incremental backup was done.
The answer to the above two will decide for me whether i should go on Recovery Manager.
(email: [email protected])
Thanks again