重建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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28408358/viewspace-765225/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28408358/viewspace-765225/