*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\ARCHIVELOG\2008_05_02\O1_
1_%U_.ARC
ORA-00280: change 33592856634 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
*auto*
=> Coba pilih yang *CANCEL*
On Fri, May 2, 2008 at 6:52 PM, Riky Kurniawan <[EMAIL PROTECTED]>
wrote:
> Makasih pak Henri atas solusinya,
>
> setelah saya menambahkan parameter tsb, error diatas sudah tidak keluar
> lagi
> tapi tergantikan dengan:
>
> *SQL> recover database;*
>
> ORA-00283: recovery session canceled due to errors
> ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
>
> saya gunakan command:
> *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\ARCHIVELOG\2008_05_02\O1_
>
> 1_%U_.ARC
> ORA-00280: change 33592856634 for thread 1 is in sequence #1
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> *auto*
> ORA-00308: cannot open archived log
>
> 'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_05_02\O1
>
> _1_%U_.ARC'
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
> ORA-00308: cannot open archived log
>
> 'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_05_02\O1
>
> _1_%U_.ARC'
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
> Saya cek di folder
> "D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_05_02\"
> tidak ada file sama sekali
>
> apakah ada langkah-langkah atau parameter yang saya ketinggalan?
>
> >
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
