Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Duplicate online Database

RE: Duplicate online Database

From: david davis <ddoralist_at_hotmail.com>
Date: Tue, 04 Mar 2003 11:22:27 -0800
Message-ID: <F001.0055FD87.20030304112227@fatcity.com>


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).
>



STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
-- 
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US