Does the database need to be running in archive log mode in order to use OCOPY?
Thanks;
Keith Worley
Confidentiality Disclaimer
This email and any files transmitted with it may contain confidential and /or
proprietary information in the possession of WellStar Health System, Inc
Keith.Worley@wel To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
lstar.org cc:
Sent by:Subject: OCOPY
Ocopy is used for hot backups - to copy the datafile etc manually. When you
do hotbackups you have to run in archive log mode.
-Original Message-
Sent: Thursday, 31 January 2002 10:16 AM
To: Multiple recipients of list ORACLE-L
Does the database need to be running in archive log mode
Ocopy is used for hot backups - to copy the datafile etc manually. When you
do hotbackups you have to run in archive log mode.
-Original Message-
Sent: Thursday, 31 January 2002 10:16 AM
To: Multiple recipients of list ORACLE-L
Does the database need to be running in archive log
Not really..
However, if it is not in archive log mode, and files are copied using OCOPY,
those files are basically of no use. You can not recover the database using
those files.
HTH.
- Kirti
-Original Message-
Sent: Wednesday, January 30, 2002 5:16 PM
To: Multiple recipients of list
:
[EMAIL PROTECTED] Subject: Re: OCOPY
Not exactly -- if the database is in NOARCHIVELOG mode, but
is shut down, and you do a cold backup with OCOPY, you're
fine.
However, *any* kind of hot backup attempted in NOARCHIVELOG
mode is pretty much useless. Which is doubtless what Kirti
was saying.
-Tom
--- Deshpande, Kirti [EMAIL
PROTECTED]]
Sent: Mon, January 28, 2002 6:35 AM
To: Multiple recipients of list ORACLE-L
Subject: COPY vs. OCOPY on NT
Your point is (I believe) that the Oracle data files are
opened writeable by Oracle at instance startup time. When
you use the NT command COPY it will prevent additional
.
There are no writes to the tablespace in this situation.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Thomas B. Cox [SMTP:[EMAIL PROTECTED]]
Sent: Mon, January 28, 2002 6:35 AM
To: Multiple recipients of list ORACLE-L
Subject: COPY vs. OCOPY on NT
to the tablespace in this situation.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
-Original Message-
From: Thomas B. Cox [SMTP:[EMAIL PROTECTED]]
Sent: Mon, January 28, 2002 6:35 AM
To: Multiple recipients of list ORACLE-L
Subject:COPY vs. OCOPY on NT
[SMTP:[EMAIL PROTECTED]]
Sent: Mon, January 28, 2002 6:35 AM
To: Multiple recipients of list ORACLE-L
Subject:COPY vs. OCOPY on NT
Your point is (I believe) that the Oracle data files are
opened writeable by Oracle at instance startup time. When
you use the NT command
. OCOPY on NT
Your point is (I believe) that the Oracle data files are
opened writeable by Oracle at instance startup time. When
you use the NT command COPY it will prevent additional
writers, but not those writers that are already holding
write locks.
My comments and questions are:
1
: COPY vs. OCOPY on NT
Your point is (I believe) that the Oracle data files are
opened writeable by Oracle at instance startup time. When
you use the NT command COPY it will prevent additional
writers, but not those writers that are already holding
write locks.
My comments
]
-Original Message-
From: Jared Still [SMTP:[EMAIL PROTECTED]]
Sent: Mon, January 28, 2002 3:41 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: COPY vs. OCOPY on NT
Oh boy, not that old chestnut again.
You better take a close look at the concepts manual
Title: RE: COPY vs. OCOPY on NT
Try http://www.speakeasy.org/~jwilton/oracle/hot-backup.html for a view on this
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2002 09:20
To: Multiple recipients of list ORACLE-L
Subject: RE: COPY vs
]
-Original Message-
From: Thomas B. Cox [SMTP:[EMAIL PROTECTED]]
Sent: Mon, January 28, 2002 6:35 AM
To: Multiple recipients of list ORACLE-L
Subject:COPY vs. OCOPY on NT
Your point is (I believe) that the Oracle data files are
opened writeable by Oracle
questions about my experience recovering from
online
backup and why I don't like MetaLink Note explanation in regard to
advantages of Ocopy versus Copy:
quote
Couple years ago, when we were preparing first release of our
product, I
read of course about NT Copy versus Oracle Ocopy.
Still I
17 matches
Mail list logo