The second line is not correct. You can either use "set" or "reuse" command. You use set command whenever you want to change the database name and "reuse" command when you want to maintain the existing database name.

Whenever, you would use set command you will need to use resetlogs invariably because you want the logs to start from 1 again.

Nooarchivelog is simply to tell the control file that you are initially opening database in noarchivelog mode.


Gurmohan
www.onlymath.com - Place to learn and teach math.





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