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/