pernah coba mindahin file untuk salah satu tablespace ya? saat database nya
masih nyala?
On Fri, May 2, 2008 at 7:22 PM, 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
> *
> 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]<henri.simatupang%40gmail.com>
> >:
>
> > 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>
> <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]
>
>
>
[Non-text portions of this message have been removed]
