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: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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" <[EMAIL PROTECTED]>@fatcity.com on 03/28/2001 12:25:55
>PM
>
>Please respond to [EMAIL PROTECTED]
>
>Sent by: [EMAIL PROTECTED]
>
>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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: [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:
> 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).
_________________________________________________________________
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: [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).
