ALTER SYSTEM ARCHIVE LOG ALL;
I have changed the other info to read
?CREATE CONTROLFILE REUSE DATABASE ?SID_NAME? RESETLOGS NOARCHIVELOG?
At the very bottom of the script I have changed it to read
?ALTER DATABASE OPEN RESETLOGS?
All trademarks and copyrights within the FreeLists archives are owned by
their respective owners.
Everything else ©2000-2012 Avenir Technologies, LLC.
FreeLists is a service of Avenir Technologies, LLC.