RE: Clarification on conventional backup

From: Elliott, Patrick <>
Date: Thu, 3 Jan 2008 11:44:07 -0600
Message-ID: <>

The current scenario is fine for a complete recovery as long as you put the tablespaces in backup mode and archive all of the current redo log files before you start the backup, you will have all of the database changes and SCN's in the archived log files. This is true whether you use a binary controlfile or a controlfile backup to trace.


From: [] On Behalf Of Ram K Sent: Thursday, January 03, 2008 10:23 AM To: oracle-l
Subject: Clarification on conventional backup


I am on a new assigment where they are still using user managed recovery in 9i. Before I move to RMAN, I was looking at the scripts to see things are OK as is. The way it is set up now, it backs up the datafiles, arch logs after doing the switch and then the control file to trace. I thought the control file would have to be backed up in binary mode to perform a complete recovery. Would we not lose SCN information if control files are backed up to trace? With control file trace backup, I think that the database has to be opened with 'reset logs' losing any latest changes to the database.

Can you please confirm. Thanks.



Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.

To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser:
-- Received on Thu Jan 03 2008 - 11:44:07 CST

Original text of this message