STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "DEMO1" RESETLOGS FORCE LOGGING ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 113
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/demo1/redo01.log' SIZE 100M,
GROUP 2 '/u01/app/oracle/oradata/demo1/redo02.log' SIZE 100M,
GROUP 3 '/u01/app/oracle/oradata/demo1/redo03.log' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/demo1/system01.dbf',
'/u01/app/oracle/oradata/demo1/undotbs01.dbf',
'/u01/app/oracle/oradata/demo1/drsys01.dbf',
'/u01/app/oracle/oradata/demo1/example01.dbf',
'/u01/app/oracle/oradata/demo1/indx01.dbf',
'/u01/app/oracle/oradata/demo1/odm01.dbf',
'/u01/app/oracle/oradata/demo1/tools01.dbf',
'/u01/app/oracle/oradata/demo1/users01.dbf',
'/u01/app/oracle/oradata/demo1/xdb01.dbf'
CHARACTER SET ZHS16GBK
;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8102208/viewspace-490531/,如需转载,请注明出处,否则将追究法律责任。