给你个格式吧,你按照这个格式去修改吧
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL9" NORESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 907
LOGFILE
GROUP 1 'D:\ORACLE9I\ORA92\ORADATA\ORCL9\REDO01.LOG' SIZE 1M,
GROUP 2 'D:\ORACLE9I\ORA92\ORADATA\ORCL9\REDO02.LOG' SIZE 1M,
GROUP 3 'D:\ORACLE9I\ORA92\ORADATA\ORCL9\REDO03.LOG' SIZE 1M
-- STANDBY LOGFILE
DATAFILE
'D:\ORACLE9I\ORA92\ORADATA\ORCL9\SYSTEM01.DBF',
'D:\ORACLE9I\ORA92\ORADATA\ORCL9\UNDOTBS01.DBF'
CHARACTER SET ZHS16GBK
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN;
# Commands to add tempfiles to temporary tablespaces.
# Online tempfiles have complete space information.
# Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\ORACLE9I\ORA92\ORADATA\ORCL9\TEMP01.DBF'
SIZE 52428800 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
# End of tempfile additions.
#
# Set #2. RESETLOGS case
#
# The following commands will create a new control file and use it
# to open the database.
# The contents of online logs will be lost and all backups will
# be invalidated. Use this only if online logs are damaged.