在控制文件丢失的情况下,有时我们只能重建控制文件,具体语法例如:
- CREATE CONTROLFILE REUSE DATABASE \"SQUAN\" NORESETLOGS ARCHIVELOG
- MAXLOGFILES 16
- MAXLOGMEMBERS 3
- MAXDATAFILES 100
- MAXINSTANCES 8
- MAXLOGHISTORY 292
- LOGFILE
- GROUP 1 \'/opt/oracle/oradatauan/redo01.log\' SIZE 50M,
- GROUP 3 \'/opt/oracle/oradatauan/redo03.log\' SIZE 50M
- -- STANDBY LOGFILE
- DATAFIL
- \'/opt/oracle/oradatauan/system01.dbf\',
- \'/opt/oracle/oradatauan/undotbs01.dbf\',
- \'/opt/oracle/oradatauan/sysaux01.dbf\',
- \'/opt/oracle/oradatauan/users01.dbf\',
- \'/opt/oracle/oradatauan/test01.dbf\',
- \'/opt/oracle/oradatauan/test02.dbf\'
- CHARACTER SET ZHS16GBK;
注意:上面语句datafile里没有temp表空间,数据库恢复完成之后需要重建临时表空间
点击(此处)折叠或打开
- alter tablespace temp add tempfile \'/opt/oracle/oradata/squan/temp01.dbf\' size 30m reuse;
- create temporary tablespace temp tempfile \'/opt/oracle/oradata/squan/temp01.dbf\' size 30m;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26675752/viewspace-1165636/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26675752/viewspace-1165636/