数据库名称修改shutdown immediatestartup mounthost nid target=sys/itsys setname=test1 dbname=test1shutdown immediatehost orapwd file=/u/oracle/product/9.2.0/dbs/orapwtest1 password=manager entries=5
修改initSID.ora文件修改环境变量修改tnsnames.orastartup nomountCREATE CONTROLFILE REUSE DATABASE "ora9i" RESETLOGS NOARCHIVELOG-- SET STANDBY TO MAXIMIZE PERFORMANCE MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 56LOGFILE GROUP 1 '/u/oracle/oradata/ora9i/redo01.log' SIZE 10M, GROUP 2 '/u/oracle/oradata/ora9i/redo02.log' SIZE 10M, GROUP 3 '/u/oracle/oradata/ora9i/redo03.log' SIZE 10M-- STANDBY LOGFILEDATAFILE '/u/oracle/oradata/ora9i/system01.dbf', '/u/oracle/oradata/ora9i/undotbs1.dbf', '/u/oracle/oradata/ora9i/cwmlite01.dbf', '/u/oracle/oradata/ora9i/drsys01.dbf', '/u/oracle/oradata/ora9i/example01.dbf', '/u/oracle/oradata/ora9i/indx01.dbf', '/u/oracle/oradata/ora9i/odm01.dbf', '/u/oracle/oradata/ora9i/tools01.dbf', '/u/oracle/oradata/ora9i/users01.dbf', '/u/oracle/oradata/ora9i/xdb01.dbf', '/u/oracle/oradata/ora9i/system02.dbf', '/u/oracle/oradata/ora9i/channel_sys.dbf'CHARACTER SET UTF8;
ZHS16GBK;
SQL> alter database open resetlogs;
完成
特别要注意的是所有的数据文件名必须改为带.dbf的扩展名 ，否则不能成功修改
