My backup policy was to take three tablespace backups on each Monday, Wednesday and Thursday, as I have only nine tablespaces. This way I took the hot backup of the database in a week.
I don't want to open my new database with reset log so that I can use the control file of the primary database for recovery if required.
Can you tell me what will be the best way to duplicate such a database?
Dig Deeper on Oracle database backup and recovery
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.