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
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF'
2008/5/2 henri simatupang <[EMAIL PROTECTED]>:
> Boss Riky,
>
> Ketika posisi :
>
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> *cancel*
> Media recovery cancelled.
> *SQL>*
>
> Udah dicoba untuk :
>
> SQL> alter database open resetlogs;
>
> Sekalian cek alert_SID.log-nya yach....
>
> Thanks & Regards,
>
> Henri Simatupang
>
> 2008/5/2 Riky Kurniawan <[EMAIL PROTECTED]<riky.kurniawan%40gmail.com>
> >:
>
> > *SQL> recover database using backup controlfile;*
>
> > ORA-00279: change 33592856634 generated at 05/02/2008 15:37:24 needed
> for
> > thread 1
> > ORA-00289: suggestion :
> >
> >
> D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG1\2008_05_02\1_%U_.ARC
> > ORA-00280: change 33592856634 for thread 1 is in sequence #1
> >
> > Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> > *cancel*
> > Media recovery cancelled.
> > *SQL>*
> >
> > sebelumnya saya sudah mencoba opsi tsb, tapi sepertinya tidak
> berpengaruh
> > juga pak...
> >
> > saya sudah googling dengan cara copy-paste kode ORA bersangkutan, tapi
> > belum
> > ketemu solusinya
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
