| 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: Duplicate online Database
The last time I had a UNIX SA backup an open database the backup software locked a control file just as Oracle was trying to write a checkpoint. Crashed the database and left the database unopenable. Fortunately (or per Oracle's recommendation) we had multiple copies of the control file and we just copied a good version over the corrupted one. Database worked fine after that.
Personally I would never recommend backing up an open database and, if that were to happen, I would consider that backup to be a 'scratch' tape.
"david davis"
<ddoralist To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
@hotmail.com> cc:
Sent by: root Subject: RE: Duplicate online Database
03/04/2003 09:49
AM
Please respond
to ORACLE-L
I would never want to rely on that method. I had run into that several
years
ago (Y2K), a Unix Admin had backed up a server and restored to a test
machine. Oracle wasn't shutdown at the time of the filesystem backup. The
problems were numerous because of checkpoint information in the datafiles
vs
the control files were out of whack. The database was garbage.
You got real lucky to have a database you could even start.
David
>From: Ofer Harel <oharel_at_barak013.net.il>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Duplicate online Database
>Date: Tue, 04 Mar 2003 04:58:51 -0800
>
>Unfortunately I found one of my database need a recovery back on time
>without a legal backup. There where only the disks backup.
>So I tried, I had nothing to lose.
>And it worked. Not documented, not recommended, but it worked.
>Of course, now this database is backup :)
>
>Ofer
>
>-----Original Message-----
>Sent: Tuesday, March 04, 2003 2:34 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Ofer,
>
>Are you suggesting that it is OK to copy an open database without
>using hot backup mode, as long as there isn't a log switch during
>copy?
>
>Do you use this method at your place of employment?
>
>--
>Jeremiah Wilton
>http://www.speakeasy.net/~jwilton
>
>On Tue, 4 Mar 2003, Ofer Harel wrote:
>
> > if the database is not heavy updateable, i.e., the switching of redo
log
>is
> > rare, and the database is not too large, you can try this scenario:
> > 1. copy (operation system) all the datafiles, redo log, etc..
> > you need to copied the hall database without a redo log switch in
>the
> > middle.
> > 2. Act with those files as its a hot backup
> > 3. Recover the database using a 'backup controlfile to trace'
> > 4. It work to me
> >
> > if you need more, email
> >
> > -----Original Message-----
> > I need to duplicate online database Oracle 8.1.7.
> > It is not possible to shutdown the primary database.
> > Can I do online backup this primary database by RMAN,
> > and + using archivelogs create duplicate database?
> > Inconsistent backups of RMAN + archivelogs = duplicate database??
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.net
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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.net
>--
>Author: Ofer Harel
> INET: oharel_at_barak013.net.il
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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.net -- Author: david davis INET: ddoralist_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Thomas Day INET: tday6_at_csc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Tue Mar 04 2003 - 09:19:35 CST
 |
 |