重建Oracle控制文件的命令(Helloblock写作)
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/orcl/redo01.log' SIZE 100M,
GROUP 2 '/u01/app/oracle/oradata/orcl/redo02.log' SIZE 100M,
GROUP 3 '/u01/app/oracle/oradata/orcl/redo03.log' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/orcl/system01.dbf',
'/u01/app/oracle/oradata/orcl/undotbs01.dbf',
'/u01/app/oracle/oradata/orcl/sysaux01.dbf',
'/u01/app/oracle/oradata/orcl/users01.dbf',
'/u01/app/oracle/oradata/orcl/example01.dbf'
CHARACTER SET AL32UTF8
;
博主:Helloblock
我
即是一块数据块,也是一块系统块。UNIX/LINUX/Oracle
mail:helloblock@126.com
QQ:1654294099