SHUTDOWN IMMEDIATE; STARTUP NOMOUNT; CREATE CONTROLFILE REUSE DATABASE "TRAIN1" RESETLOGS NOARCHIVELOG -- SET STANDBY TO MAXIMIZE PERFORMANCE MAXLOGFILES 50 MAXLOGMEMBERS 5 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 226 LOGFILE GROUP 1 'E:\ORACLE\ORADATA\TRAIN1\REDO01.LOG' SIZE 100M, GROUP 2 'E:\ORACLE\ORADATA\TRAIN1\REDO02.LOG' SIZE 100M, GROUP 3 'E:\ORACLE\ORADATA\TRAIN1\REDO03.LOG' SIZE 100M DATAFILE 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF', 'E:\ORACLE\ORADATA\TRAIN1\CWMLITE01.DBF', 'E:\ORACLE\ORADATA\TRAIN1\DRSYS01.DBF', 'E:\ORACLE\ORADATA\TRAIN1\EXAMPLE01.DBF', 'E:\ORACLE\ORADATA\TRAIN1\INDX01.DBF', 'E:\ORACLE\ORADATA\TRAIN1\ODM01.DBF', 'E:\ORACLE\ORADATA\TRAIN1\TOOLS01.DBF', 'E:\ORACLE\ORADATA\TRAIN1\USERS01.DBF', 'E:\ORACLE\ORADATA\TRAIN1\XDB01.DBF', 'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM120040519091720_DB.DBF', 'E:\ORACLE\ORADATA\TRAIN1\DM_NTDISTRIB20040514033149_DB.DBF', 'E:\ORACLE\ORADATA\TRAIN1\DM_W2KVM1_INDX1.ORA' CHARACTER SET AL32UTF8 ; RECOVER DATABASE; ALTER DATABASE OPEN RESETLOGS; ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\TRAIN1\TEMP01.DBF' REUSE;