Winnie
thanks for ur reply.
I am doing online backup by following steps.Is this way is correct or
not.Please correct me.
1)Archive log list
2)alter system switch logfile;
3)alter database backup controlfile to trace;
4)ALter tablespace and copy all datafiles one by one.
5)alter system switch logfile;
6)archive log stop;
7)copy all archive logs
8)archive log start;
9)archive log list
10)binary backup of the controlfile
Please correct IF I am wrong in sequence let me know.
Thanks
-Seema
>From: Winnie_Liu_at_infonet.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: online backup query
>Date: Wed, 28 Mar 2001 13:30:28 -0800
>
>
>In V$INSTANCE, there is a column named PARALLEL which will tell you whether
>the instance is in OPS mode or not.
>
>In online backup mode, you will need to backup
>1) all datafiles
>2) a binary backup of the controlfile
>3) all archivelog files generated during the online backup period of time
>4) I will also backup the init.ora file, a backup trace of the controlfile,
>password file etc.
>
>Winnie
>
>
>
>
>
>"Seema Singh" <oracledbam_at_hotmail.com>@fatcity.com on 03/28/2001 12:25:55
>PM
>
>Please respond to ORACLE-L_at_fatcity.com
>
>Sent by: root_at_fatcity.com
>
>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>cc:
>
>
>
>Hi gurus
>I am new to this group.
>What are those files need to backup in online backup mode?
>how we know the database is setup in OPS mode?
>Please help me.
>Thanks in advance.
>Seema
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
> INET: oracledbam_at_hotmail.com
>
>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: ListGuru_at_fatcity.com (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:
> INET: Winnie_Liu_at_infonet.com
>
>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: ListGuru_at_fatcity.com (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).
Get your FREE download of MSN Explorer at
http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET: oracledbam_at_hotmail.com
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: ListGuru_at_fatcity.com (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).
Received on Thu Mar 29 2001 - 10:22:09 CST
