oracle 控制文件丢失后重建立

SQL>startup nomount;

SQL>create controlfile reuse database orcl noresetlogs archivelog
           Logfile group 1 'd:\oracle\oradata\orcl\redo01.log',
                        group 2 'd:\oracle\oradata\orcl\redo02.log',
                        group 3 'd:\oracle\oradata\orcl\redo03.log' 
          datafile 'd:\oracle\oradata\orcl\system01.dbf', 
                        'd:\oracle\oradata\orcl\users01.dbf', 
                        'd:\oracle\oradata\orcl\temp01.dbf', 
                        'd:\oracle\oradata\orcl\tools01.dbf', 
                        'd:\oracle\oradata\orcl\indx01.dbf', 
                        'd:\oracle\oradata\orcl\dr01.dbf', 
                        'd:\oracle\oradata\orcl\rbs01.dbf';
                  语句已处理。

SQL>alter database open;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15142212/viewspace-617594/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15142212/viewspace-617594/