| 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
Thomas,
To prevent the situation from occuring I have the SA exclude the mount points/directories where the database datafiles are located from the filesystem backups. I know this made our people who manage the Tivoli Storage Management system happy.
>From: "Thomas Day" <tday6_at_csc.com>
>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 07:19:35 -0800
>
>
>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).
> >
>
>
>_________________________________________________________________
>Add photos to your messages with MSN 8. Get 2 months FREE*.
>http://join.msn.com/?page=features/featuredemail
>
>--
>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).
>
-- 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).Received on Tue Mar 04 2003 - 13:22:27 CST
 |
 |