Hi all,

I'm using oracle RMAN for hot backup and recovery, its working fine.

My current practice-
I take the RMAN hot backup every night and then restore the contents on
another server. During this phase the ATM machine won't be accessible
due to resource crunching that takes place because of hot backup.

My proposed view -
Once the data is restored, take the archive logs every 2 hours and just
keep running,
Recover database;
The advantage, I need not take hot backup every night in the Live,
instead transfer only the archive logs and apply it on the backup server
database. When situation demands use ALTER DATABASE OPEN RESETLOGS;

Will there be any flaw or data inconsistency will it occur?

Regards,
KARTHIK GANESAN
IT Consultant
Uganda



Oracle LazyDBA home page