34 lines
986 B
MySQL
34 lines
986 B
MySQL
|
STARTUP NOMOUNT
|
||
|
|
|
||
|
|
CREATE CONTROLFILE set DATABASE "test8" RESETLOGS NOARCHIVELOG
|
||
|
|
-- SET STANDBY TO MAXIMIZE PERFORMANCE
|
||
|
|
MAXLOGFILES 50
|
||
|
|
MAXLOGMEMBERS 5
|
||
|
|
MAXDATAFILES 100
|
||
|
|
MAXINSTANCES 1
|
||
|
|
MAXLOGHISTORY 226
|
||
|
|
LOGFILE
|
||
|
|
GROUP 1 '/bms/u04/oradata/test8/redo01.log' SIZE 20M,
|
||
|
|
GROUP 2 '/bms/u04/oradata/test8/redo02.log' SIZE 20M,
|
||
|
|
GROUP 3 '/bms/u04/oradata/test8/redo03.log' SIZE 20M
|
||
|
|
-- STANDBY LOGFILE
|
||
|
|
DATAFILE
|
||
|
|
'/bms/u04/oradata/test8/system01.dbf',
|
||
|
|
'/bms/u04/oradata/test8/undotbs01.dbf',
|
||
|
|
'/bms/u04/oradata/test8/usr01.dbf',
|
||
|
|
'/bms/u04/oradata/test8/indx01.dbf'
|
||
|
|
CHARACTER SET WE8ISO8859P15
|
||
|
|
;
|
||
|
|
|
||
|
|
ALTER DATABASE OPEN RESETLOGS;
|
||
|
|
|
||
|
|
ALTER TABLESPACE TEMPORARY ADD TEMPFILE '/bms/u04/oradata/test8/temporary01.dbf'
|
||
|
|
REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
|
||
|
|
|
||
|
|
alter database rename global_name to test8.world;
|
||
|
|
|
||
|
|
alter user cramer identified by cramer;
|
||
|
|
alter user sys identified by syspass;
|
||
|
|
alter user system identified by syspass;
|
||
|
|
|