RE: Backup Strategy

Hey Igor...

You might want to check out Note: 139327.1 on Metalink... Specifically the part that says...

"To backup you will need to use the utility delivered by Oracle, the ocopy command. Utilities like the NT commands copy, xcopy CANNOT be used to back up.
The Windows NT feature to be aware of is that NT Backup does not allow files in
use to be copied, so you must use the OCOPY utility that Oracle provides to copy the open database files to another disk location."

And...

"OCOPY allows writing to continue while the backup is running. The NT COPY is a
closed copy and the files may be marked either as "fuzzy" or "corrupt." Ocopy
opens the file using CreateFile() with the FILE_SHARE_READ and FILE_SHARE_WRITE
flags. This allows writing to continue while we take the backup. Inconsistencies in the backup are repaired by applying archived redo during recovery. The 'copy' command from NT doesn't use these flags since it wants to
prevent writes to the file while the copy is taking place."

HTH
Tim

-----Original Message-----
Sent: Thursday, January 24, 2002 4:05 PM To: Multiple recipients of list ORACLE-L

I took a quick look at this paper, and found right away, that it's not very accurate, at least in one issue.
i.e., it states :
< quote>
The Windows NT command COPY can be used to create a cold backup of a database. It cannot be used to make a
hot backup. Attempting to perform a hot backup with COPY will usually result in an error message being generated
as the COPY command fails - during a hot backup the database is running and thus the database files are locked by
the Oracle database process, and COPY cannot work on a file that is so locked.
< /quote>

Wrong. NT 'COPY' has no problems copying 'opened' oracle db files. I'm using it in 'hot backup' scripts on many dozens systems, and it works fine.

Don't know about the accuracy of the rest of the paper, didn't have time to read it all.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 24, 2002 7:35 AM

> Hi All,
>
> http://www.geocities.com/tbcox23/
>
> Go here and get the paper.
>
> Regards
> Venkat
> --
>
> On Thu, 24 Jan 2002 03:25:17
> Bunyamin K. Karadeniz wrote:
> >If possible , I want one copy too.
> >Bunyamin
> >----- Original Message -----
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Sent: Thursday, January 24, 2002 12:30 PM
> >
> >
> >> Can you send me one (NT backup strategy)
> >>
> >> Regards,
> >> Ramesh D Papnoi
> >> Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
> >> (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
> >> http://www22.Brinkster.com/rpapnoi
> >>
> >> ---------- Original Text ----------
> >>
> >> To: internet["Multiple recipients of list ORACLE-L"
> ><ORACLE-L_at_fatcity.com>]
> >>
> >> Please send me one. (NT) Thank,
> >>
> >> grace wrote:
> >> >
> >> > can u also send me a copy on backup strategy on nt.
> >> > thanks
> >> >
> >> > ----- Original Message -----
> >> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >> > Sent: Wednesday, January 23, 2002 3:25 PM
> >> >
> >> > > Hello Hamid
> >> > >
> >> > > I would like to have this paper as well.
> >> > > We are now revising our Backup strategy.
> >> > >
> >> > > Yechiel Adar, Mehish Computer Services
> >> > > adary_at_mehish.co.il
> >> > >
> >> > > > -----Original Message-----
> >> > > > From: Mohan, Ross [SMTP:MohanR_at_STARS-SMI.com]
> >> > > > Sent: Tue, January 22, 2002 6:35 PM
> >> > > > To: Multiple recipients of list ORACLE-L
> >> > > > Subject: RE: Backup Strategy
> >> > > >
> >> > > > Hamid,
> >> > > >
> >> > > > Would you be willing to forward a copy of
> >> > > > this paper?
> >> > > >
> >> > > > Thanks,
> >> > > >
> >> > > > Ross Mohan
> >> > > >
> >> > > > -----Original Message-----
> >> > > > Sent: Thursday, January 17, 2002 12:27 PM
> >> > > > To: Multiple recipients of list ORACLE-L
> >> > > >
> >> > > >
> >> > > > Hi List,
> >> > > > I have a white paper for Backup Strategy on Microsoft NT but I am
> >> > looking
> >> > > > for Backup Strategy for Oracle8i on Solaris, If anybody have any
doc
> >or
> >> > > > link
> >> > > > I realy appreciate.
> >> > > >
> >> > > >
> >> > > >
> >> > > >
> >> > > > Hamid Alavi
> >> > > > Office 818 737-0526
> >> > > > Cell 818 402-1987
> >> > > >
> >> > > > The information contained in this message and any attachments is
> >> > intended
> >> > > > only for the use of the individual or entity to which it is
> >addressed,
> >> > and
> >> > > > may contain information that is PRIVILEGED, CONFIDENTIAL and
exempt
> >from
> >> > > > disclosure under applicable law. If you have received this
message
> >in
> >> > > > error,
> >> > > > you are prohibited from copying, distributing, or using the
> >information.
> >> > > > Please contact the sender immediately by return e-mail and delete
> >the
> >> > > > original message from your system.
> >> > > > --
> >> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >> > > > --
> >> > > > Author: Hamid Alavi
> >> > > > INET: hamid.alavi_at_quovadx.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: Mohan, Ross
> >> > > > INET: MohanR_at_STARS-SMI.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).
> >> > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >> > > > This e-mail was scanned by the eSafe Mail Gateway
> >> > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> >> > >
> >> > > --
> >> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >> > > --
> >> > > Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> >> > > INET: adary_at_mehish.co.il
> >> > >
> >> > > 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: grace
> >> > INET: mglim_at_softhome.net
> >> >
> >> > 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: Joan Hsieh
> >> INET: joan.hsieh_at_tufts.edu
> >>
> >> 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: rpapnoi_at_chemtex.co.in
> >>
> >> 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: Bunyamin K. Karadeniz
> > INET: bunyamink_at_havelsan.com.tr
> >
> >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: C.S.Venkata Subramanian
> INET: csvenkata_at_lycos.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: Igor Neyman
  INET: ineyman_at_perceptron.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: Johnston, Tim
  INET: TJohnston_at_quallaby.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).