RE: Clarification on conventional backup
- From: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
- To: "lambu999@xxxxxxxxx" <lambu999@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Jan 2008 11:44:07 -0600
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.
Pat
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Ram K
Sent: Thursday, January 03, 2008 10:23 AM
To: oracle-l
Subject: Clarification on conventional backup
Listers,
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.
--
Thanks,
Ram.
___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
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:
http://emaildisclaimer.medtronic.com
Other related posts:
