RE: Hot Backup Theory Revisited:
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 28 Jun 2004 13:36:20 -0400
Slight correction.
re:
"I have to do it this way as the database name and file structure names
change slightly."
It is probably easier for you to do it this way, but you also *could* use
datafile renaming. That still works, so if someone finds themselves with
only the "binary" controlfile on hand they are still not painted into a
corner. It's a little trickier, since you have to have the database at the
right point in a warm start and get the syntax right instead of just knowing
your favorite text editor. As usual I recommend belts AND suspendors. Backup
to trace and backup controlfile, and stash them both on tapesets.
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hodgkinson, Stephen
Sent: Sunday, June 27, 2004 7:30 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Hot Backup Theory Revisited:
Thanks everybody,
After I have backed up all the tablespaces I issue an ' alter database
backup controlfile to trace'
I then recreate the controlfile using the SQL.
I have to do it this way as the database name and file structure names
change slightly.
Mike the idea that it might already be in backup mode could be a good one.
We do get alarms if our tablespace our left in Backup mode but this now
seems the only logical explanation.
Stephen.
-----Original Message-----
From: Khedr, Waleed [mailto:Waleed.Khedr@xxxxxxx]
Sent: Saturday, 26 June 2004 3:20
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Hot Backup Theory Revisited:
Updates/Writes to the file during the O/S copy process, possibly, makes =
the copied file inconsistent.
Waleed
-----Original Message-----
From: Guang Mei [mailto:gmei@xxxxxxxxxx]
Sent: Friday, June 25, 2004 1:03 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Hot Backup Theory Revisited:
Why OS copy of control file won't work?
Guang
> -----Original Message-----
Guang,
Under normal circumstances yes, but the control file has to be a "alter
database backup controlfile . . .", not a OS copy.
Mike
-----Original Message-----
From: Guang Mei [mailto:gmei@xxxxxxxxxx]
Sent: Friday, June 25, 2004 11:17 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Hot Backup Theory Revisited:
I am trying to understand:
Is it true that if the copy of control file (just an OS copy) is done =
AFTER issuing
ALTER SYSTEM ARCHIVE LOG CURRENT;
then no earlier (than the log switch) archive log is needed? We still =
need the archive logs generated during tablespace backup process.
Guang=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
************** IMPORTANT MESSAGE **************
This e-mail message is intended only for the addressee(s) and contains
information which may be confidential. If you are not the intended recipient
please advise the sender by return email, do not use or disclose the
contents, and delete the message and any attachments from your system.
Unless specifically indicated, this email does not constitute formal advice
or commitment by the sender or the Commonwealth Bank of Australia (ABN 48
123 123 124) or its subsidiaries. We can be contacted through our web site:
www.commbank.com.au
**************************************************
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
