Re: daily clone

>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: 
  INET: Jared.Still_at_radisys.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).