Step 7 & 8 has always generated difference of opinions :-). And you are right, I
forgot to mention step 9. Archives are backed up to tape 4x day (10gb/day). Thanks!
Gene
>>> [EMAIL PROTECTED] 03/07/02 01:21PM >>>
I would swap 7) and 8): "backup control file" then "alter system archive log
current".
You also didn't mention step 9: copy archived logs onto backup destination
media.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 07, 2002 12:28 PM
I know this has been mentioned on the list before, but for my sanity check,
will this Hot Backup Method work?
1) Alter system archive log current ; not really needed but can't hurt.
2) Check backup status.
3) Generate datafile listing to be used by step 5.
4) Alter tablespace <tablespace_name> begin backup ;
5) Some other process,script,legato,etc. will copy database file(s)
to disk or to tape.
6) Alter tablespace <tablespace_name> end backup ;
7) Alter system archive log current ; really needed but before or after
backup controlfile?
8) Backup controlfile.
Gene
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Igor Neyman
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
