MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/DataExchange2/oradata/idep2/redo01.log' SIZE 1024M,
GROUP 2 '/DataExchange2/oradata/idep2/redo02.log' SIZE 1024M,
GROUP 3 '/DataExchange2/oradata/idep2/redo03.log' SIZE 1024M
-- STANDBY LOGFILE
DATAFILE
'/DataExchange2/oradata/idep2/system01.dbf',
'/DataExchange2/oradata/idep2/undotbs01.dbf',
'/DataExchange2/oradata/idep2/sysaux01.dbf',
'/DataExchange2/oradata/idep2/zhjs_index01.dbf',
'/DataExchange2/oradata/idep2/zhjs_param01.dbf',
'/DataExchange2/oradata/idep2/zhjs_log01.dbf',
'/DataExchange2/oradata/idep2/zhjs_log02.dbf'
CHARACTER SET ZHS16GBK;
alter database open resetlogs;
ALTER TABLESPACE TEMP ADD TEMPFILE '/DataExchange2/oradata/idep2/temp01.dbf'
SIZE 2048M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE ZHJS_TEMP ADD TEMPFILE '/DataExchange2/oradata/idep2/zhjs_temp01.dbf'
SIZE 5120M REUSE AUTOEXTEND OFF;
alter database rename global_name to idep2;