[实验]

1.alter database backup controlfile to trace;
(
需更改：
A. reuse->set
B. 修改为新的DB名
C. 去掉#注释
D. 去掉开始的（NORESETLOGS NOARCHIVELOG）和结尾的（RECOVER DATABASE）
E. 在LOGFILE后加resetlogs
2。shutdown immediate
3。修改pfile中db_name(..adminfishpfileinit.ora)
4。删除控制文件
5。startup nomount
6。@D:sqlcreatecontrolfile.sql
内容如下：
CREATE CONTROLFILE set DATABASE "SMFISH"
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1815
LOGFILE
GROUP 1 'E:ORACLEORADATAFISHREDO03.LOG' SIZE 1M,
GROUP 2 'E:ORACLEORADATAFISHREDO02.LOG' SIZE 1M,
GROUP 3 'E:ORACLEORADATAFISHREDO01.LOG' SIZE 1M
RESETLOGS
DATAFILE
'E:ORACLEORADATAFISHSYSTEM01.DBF',
'E:ORACLEORADATAFISHRBS01.DBF',
'E:ORACLEORADATAFISHUSERS01.DBF',
'E:ORACLEORADATAFISHTEMP01.DBF',
'E:ORACLEORADATAFISHTOOLS01.DBF',
'E:ORACLEORADATAFISHINDX01.DBF',
'E:ORACLEORADATAFISHDR01.DBF'
CHARACTER SET ZHS16GBK;
RECOVER DATABASE
ALTER DATABASE OPEN resetlogs;