oracle日志文件和控制文件损坏的恢复(二)
GFILES 20
MAXLOGMEMBERS 5
MAXDATAFILES 1000
MAXINSTANCES 8
MAXLOGHISTORY 2337
LOGFILE
GROUP 1 '/database/oradata/skyread/redo01.log' SIZE 512M,
GROUP 2 '/database/oradata/skyread/redo02.log' SIZE 512M,
GROUP 3 '/database/oradata/skyread/redo03.log' SIZE 512M,
GROUP 4 '/database/oradata/skyread/redo04.log' SIZE 512M,
GROUP 5 '/database/oradata/skyread/redo05.log' SIZE 512M
DATAFILE
'/database/oradata/skyread/system01.dbf',
'/database/oradata/skyread/tbs_test.dbf',
'/database/oradata/skyread/sysaux01.dbf',
'/database/oradata/skyread/users01.dbf',
'/database2/oradata/skyread/TBS_MRPMUSIC01.dbf',
'/database/oradata/skyread/sf01.dbf',
'/database2/oradata/skyread/undotbs02'
CHARACTER SET UTF8;
重建控制文件后，重置日志打开数据库，但是丢失之前插入的数据：
SQL> alter database open resetlogs;
Database altered.
SQL> select * from tb1;
此时tb1的表中插入的1不存在