Re: daily clone

"REUSE" applies to the ControlFile [ie, reuse if file exists, error if file exists and REUSE not specified].

"SET" applies to the Database Name [SET is used when changing the datababase name]

Hemant
At 05:44 AM 03-04-03 -0800, you wrote:
>Jared,
>
>Thanks for the reply. I will try next time. I just feel like combine
>the reuse and set together, seems not that logical.
>
>Thanks,
>Joan
>
>Jared.Still_at_radisys.com wrote:
> >
> > >From TFM:
> >
> > Specify REUSE to indicate that existing control files identified by the
> initialization
> > parameter CONTROL_FILES can be reused, thus ignoring and overwriting
> any information they may
> > currently contain. If you omit this clause and any of these control files
> > already exists, Oracle returns an error.
> >
> > So it would seem a valid syntax.
> >
> > Jared
> >
> > Joan Hsieh <joan.hsieh_at_tufts.edu>
> > Sent by: root_at_fatcity.com
> > 04/02/2003 12:48 PM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: Re: daily clone
> >
> > Bill,
> >
> > Kind of curiosity, I don't know this syntax; I do "create controlfile
> > set database" or "create controlfile resue database". But never did
> > reuse set. Is that a valid syntax? I don't have time to check it by
> > myself. sorry to ask.
> >
> > Joan
> >
> > >CREATE CONTROLFILE REUSE SET DATABASE "SIDB" RESETLOGS NOARCHIVELOG
> >
> > Niall Litchfield wrote:
> > >
> > > Obviously the usual caveats of 'test this first' and ' don't just listen
> > > to some bloke off of email' apply but here would be my contributions.
> > >
> > > 1. Don't copy temp - create a new one - it by definition has nothing in
> > > it.
> > > 2. Don't copy online redo logs - resetlogs means that a) the old ones
> > > are useless and the SCN will be reset b) new ones will get created if
> > > necessary.
> > > 3. I'm not quite clear what is going on with these read/write-read-only
> > > nfs files, are these genuinely copied across to a new location, or are
> > > they the actual datafiles mounted read-only in an nfs environment, or
> > > are they some sort of weird vendor-provided copy of the datafiles? This
> > > is probably all my stupidity in not reading you clearly enough.
> > >
> > > Niall
> > >
> > > > -----Original Message-----
> > > > From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of
> > > > becker.bill_at_marshfieldclinic.org
> > > > Sent: 26 March 2003 19:59
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: daily clone
> > > >
> > > >
> > > >
> > > > Hello,
> > > >
> > > > Env: Oracle 9.2.0.2.0 on Solaris 9 (2 machines)
> > > >
> > > > I'm trying to set up a daily cloning process between 2 Oracle
> > > > instances (SIDA is source, SIDB is target) using the CREATE
> > > > CONTROLFILE REUSE SET DATABASE SIDB ... method. The steps are:
> > > >
> > > > 1) Shutdown immediate SIDB
> > > > 2) Shutdown immediate SIDA, startup restrict, shutdown normal
> > > > 3) Copy system datafile to target machine (I'm going to reset logs,
> > > > dbs are shutdown, shouldn't require any recovery)
> > > > 4) Create read-only copy of all user datafiles using a vendor feature
> > > > called checkpoints (not Oracle checkpoints)
> > > > 5) Startup SIDA
> > > > 6) Run the following script on SIDB (adapted from SIDA backup
> > > > controlfile to trace)
> > > >
> > > > STARTUP NOMOUNT PFILE='/oracle_home_path/dbs/initDWQ.ora'
> > > > CREATE CONTROLFILE REUSE SET DATABASE "SIDB" RESETLOGS NOARCHIVELOG
> > > > MAXLOGFILES 5
> > > > MAXLOGMEMBERS 3
> > > > MAXDATAFILES 512
> > > > MAXINSTANCES 1
> > > > MAXLOGHISTORY 1817
> > > > LOGFILE
> > > > GROUP 1 '/redo1/dws/redo01.log' SIZE 100M,
> > > > GROUP 2 '/redo1/dws/redo02.log' SIZE 100M,
> > > > GROUP 3 '/redo1/dws/redo03.log' SIZE 100M
> > > > DATAFILE
> > > > '/dwdata1/dwq/sys/system01.dbf',
> > > > '/rbs/dws/undotbs01.dbf',
> > > > '/data1/dws/users.dbf',
> > > > '/data1/dws/tools.dbf',
> > > > '/dwdata1.chkpnt/ckpt1/dws/data/lvl1_data/LVL1_DATA01.dbf',
> > > > '/dwdata2.chkpnt/ckpt1/dws/index/lvl1_ndex/LVL1_NDEX01.dbf',
> > > > '/dwdata1.chkpnt/ckpt1/dws/data/lvl2_data/LVL2_DATA01.dbf',
> > > > '/dwdata2.chkpnt/ckpt1/dws/index/lvl2_ndex/LVL2_NDEX01.dbf',
> > > > ...
> > > > CHARACTER SET WE8ISO8859P1
> > > > ;
> > > >
> > > > ALTER DATABASE OPEN RESETLOGS;
> > > > ALTER TABLESPACE TEMP ADD TEMPFILE '/oratmp1/dwq/temp01.dbf'
> > > > SIZE 2049M REUSE AUTOEXTEND OFF;
> > > >
> > > > There are a couple of twists. The datafiles listed with
> > > > .chkpnt in their path are in a read-only nfs-mounted
> > > > filesystem; when shutdown before copying, their status within
> > > > Oracle was READ WRITE.
> > > >
> > > > The databases were both shutdown when the copies were made,
> > > > SIDB is using RESETLOGS, so I'm thinking this will work OK
> > > > and Oracle will not try and write anything to these when
> > > > opening SIDB.
> > > >
> > > > Does this sound OK?
> > > >
> > > > The next question is, do I need to copy any redo logs, undo
> > > > tblspc (using auto undo), or temp datafiles from SIDA to
> > > > SIDB? Again, since I'm shutting
> > > > down cleanly, and doing a resetlogs on opening, I am hoping
> > > > that I can simply reuse the existing redo logs, undo tblspc
> > > > and tempfile.
> > > >
> > > > The next twist is that we want to preserve some read write
> > > > tablespaces in SIDB, like users.dbf and tools.dbf listed
> > > > above, and not wipe them out when re-creating the controlfile
> > > > each day. Again, since we shut down SIDB cleanly, and I list
> > > > the existing datafiles under the datafile section of the
> > > > CREATE CONTROLFILE command, I am hoping this will preserve
> > > > their contents. Am I wrong?
> > > >
> > > > We will be testing these scenarios, but I am hoping for some
> > > > insightful advice from others who have gone before.
> > > >
> > > > Sorry for the lengthy message, and as always, thanks to any
> > > > responders. Bill
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author:
> > > > INET: becker.bill_at_marshfieldclinic.org
> > > >
> > > > 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: Niall Litchfield
> > > INET: niall.litchfield_at_dial.pipex.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: Joan Hsieh
> > INET: joan.hsieh_at_tufts.edu
> >
> > 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: Joan Hsieh
> INET: joan.hsieh_at_tufts.edu
>
>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).

Hemant K Chitale
My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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