Setiap incomplete recovery membutuhkan setidaknya 1 archivelog untuk di
apply.
Kemanakah archivelog Anda?
apakah database anda dalam archivelog mode?
2008/5/2 Riky Kurniawan <[EMAIL PROTECTED]>:
> Saya mencoba menggunakan command:
>
> *SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;*
>
> SQL> RECOVER DATABASE UNTIL CANCEL 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\ARCHIVELO\2008_05_02\O1_MF_1_%U_.ARC
> ORA-00280: change 33592856634 for thread 1 is in sequence #1
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> *CANCEL*
>
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
> below
> 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'
> ORA-01112: media recovery not started
>
> Nah, adakah rekan yang pernah dapat solusi untuk error ini?
> *ORA-01194: file 1 needs more recovery to be consistent*
>
> [Non-text portions of this message have been removed]
>
>
>
--
Cheers,
Yoel Susanto
www.indo-oracletech.com
[Non-text portions of this message have been removed]
