系统文件启动数据库

--如果仅仅有数据文件怎样启动和恢复数据库

--参数文件个别信息
#*.undo_management='AUTO'
#*.undo_tablespace='UNDOTBS1'
#_corrupted_rollback_segments=(_SYSSMU1$,_SYSSMU2$)
_allow_resetlogs_corruption=true（这个参数有可能不用设置）
--步骤
1，在相同的机器上创建相同的数据库
2，关闭新创建的数据库
3，更换数据文件
4，以下其他操作
SQL> startup nomount pfile='d:initorcl.ora';
ORACLE instance started.
Total System Global Area 205520896 bytes
Fixed Size 1248116 bytes
Variable Size 79692940 bytes
Database Buffers 121634816 bytes
Redo Buffers 2945024 bytes
SQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS ARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 292
7 LOGFILE
8 GROUP 1 'D:ORACLEPRODUCT10.2.0ORADATAORCLREDO01.LOG' SIZE 50M,
9 GROUP 2 'D:ORACLEPRODUCT10.2.0ORADATAORCLREDO02.LOG' SIZE 50M,
10 GROUP 3 'D:ORACLEPRODUCT10.2.0ORADATAORCLREDO03.LOG' SIZE 50M
11 -- STANDBY LOGFILE
12 DATAFILE
13 'D:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF',
14 'D:ORACLEPRODUCT10.2.0ORADATAORCLSYSAUX01.DBF',
15 'D:ORACLEPRODUCT10.2.0ORADATAORCLUSERS01.DBF',
16 'D:ORACLEPRODUCT10.2.0ORADATAORCLEXAMPLE01.DBF'
17 CHARACTER SET ZHS16GBK
18 ;
Control file created.
SQL> alter database clear logfile group 1;
Database altered.
SQL> alter database clear logfile group 2;
Database altered.
SQL> alter database clear logfile group 3;
Database altered.
SQL> alter database open resetlogs;
Database altered.
SQL>
--其实就是这么简单，但是我用了3个小时才做出来！真够劲的！