| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Backup Strategy
> 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.
Igor, you sure about that?
There are backup packages (such as Backup Exec ) that use their own file open copy program to avoid using copy.exe.
Have you restored any of these backups made with copy?
Jared
Note:139327.1
Differences between Windows NT COPY and Oracle
OCOPY When Doing Backups
Creation Date: 03-APR-2001
Last Revision Date: 04-DEC-2001
PURPOSE
A comparison of the differences between the Windows NT "copy" commnad,
and
the Oracle "ocopy" command. Which should be used during an online backup?
SCOPE & APPLICATION
DBAs with databases on the Windows NT platform.
The Differences between Windows NT COPY and Oracle OCOPY When Doing Backups:
When doing an online backup, should you use the Windows NT COPY command,
or the
Oracle OCOPY command?
While doing online backups you should use OCOPY, or Oracle7 EBU, or
Oracle8
(and later) RMAN. With the OCOPY command you could copy to a backup
directory
on the hard drive but cannot use OCOPY to copy a file to tape. The other
option
if you do not want to use ocopy to perform your backup as this does
require a
lot of disk space is EBU/RMAN that comes with Oracle. Depending on your
Oracle
version, the distribution includes a utility called EBU (Oracle7) or RMAN
(Oracle8 and later) that can be used for online recovery as well. You
will need
to use a media management product to move the data from RMAN to tape.
Legato
Storage Manager is provided however there are other products that are
supported
to be used with this tool.
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. Since OCOPY cannot
copy
files directly to tape, you will then need to use NT Backup or copy or a
similar utility to copy the files to tape, as required.
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.
"Igor Neyman" <ineyman_at_perceptron.com>
Sent by: root_at_fatcity.com
01/24/02 01:05 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Re: Backup Strategy
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
> 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
> >> >
-- 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: INET: Jared.Still_at_radisys.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 Jan 24 2002 - 17:44:27 CST
 |
 |