I take it you are looking at a trace controlfile. If so, the line that
says 'reuse set', is actually supposed to say 'reuse'.

When you use 'set', you are actually changing the database name. so you
could move all the datafiles, redo logs, and change the name of a
database. For instance you may be moving production to a training
server, and so your name is now changed from PROD to TRAIN. Similarly
your datafiles, and redo logs could be edited in the controlfile to
relocate them according to your conventions.

-----Original Message-----
From: Dustin Hayden
[mailto:oracledba-ezmlmshield-x52229852.[Email address protected]
Sent: Tuesday, November 01, 2005 12:22 PM
To: LazyDBA Discussion
Subject: set and reuse set

Can someone please explain the difference between the using the
following?



Create control file set database "NAME" resetlogs noarchive log

And

Create control file reuse set database "NAME" resetlogs noarchive log





TIA

Dustin





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page