riky, sepertinya file tsb dalam posisi begin backup, tiba2 mesin crash.... coba saja di end backup:
SQL> alter database open; <ORA-1113> SQL> alter database datafile 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF' end backup; SQL> alter database open; jika masih ada error, mungkin datafile yg lain....coba saja repeat step sebelumnya dgn datafile yg error tsb regards ujang On 5/2/08, Riky Kurniawan <[EMAIL PROTECTED]> wrote: > berikut error yang keluar di alert_orcl.log ketika command: "ALTER DATABASE > RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE" dijalankan > > Fri May 02 19:19:52 2008 > ALTER DATABASE RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE > Fri May 02 19:19:52 2008 > Media Recovery Start > WARNING! Recovering data file 1 from a fuzzy file. If not the current file > it might be an online backup taken without entering the begin backup > command. > WARNING! Recovering data file 2 from a fuzzy file. If not the current file > it might be an online backup taken without entering the begin backup > command. > WARNING! Recovering data file 3 from a fuzzy file. If not the current file > it might be an online backup taken without entering the begin backup > command. > WARNING! Recovering data file 4 from a fuzzy file. If not the current file > it might be an online backup taken without entering the begin backup > command. > WARNING! Recovering data file 5 from a fuzzy file. If not the current file > it might be an online backup taken without entering the begin backup > command. > WARNING! Recovering data file 6 from a fuzzy file. If not the current file > it might be an online backup taken without entering the begin backup > command. > WARNING! Recovering data file 7 from a fuzzy file. If not the current file > it might be an online backup taken without entering the begin backup > command. > Starting datafile 1 with incarnation depth 0 in thread 1 sequence 1 > Datafile 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF' > Starting datafile 2 with incarnation depth 0 in thread 1 sequence 1 > Datafile 2: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS.DBF' > Starting datafile 3 with incarnation depth 0 in thread 1 sequence 1 > Datafile 3: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF' > Starting datafile 4 with incarnation depth 0 in thread 1 sequence 1 > Datafile 4: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01.DBF' > Starting datafile 5 with incarnation depth 0 in thread 1 sequence 1 > Datafile 5: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMPLE01.DBF' > Starting datafile 6 with incarnation depth 0 in thread 1 sequence 1 > Datafile 6: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\INVENTORY' > Starting datafile 7 with incarnation depth 0 in thread 1 sequence 1 > Datafile 7: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS02.DBF' > Media Recovery Log > ORA-279 signalled during: ALTER DATABASE RECOVER DATABASE UNTIL CANCEL > USIN... > Fri May 02 19:19:55 2008 > ALTER DATABASE RECOVER CANCEL > ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ... > Fri May 02 19:19:55 2008 > ALTER DATABASE RECOVER CANCEL > ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ... > > Lalu saya menjalankan command: > SQL> alter database open resetlogs; > > di command prompt keluarnya ini: > *SQL> alter database open resetlogs;* > alter database open resetlogs
