Dear All, Saya coba : SQL> startup mount; SQL> alter database recover managed standby database finish
ORA-00283: Recover session canceled due to errors ORA-16171: RECOVER....FINISH not allowed due to gap for thr 1, seq 4152-4251 Kalau SQL> alter database activate standby database; ORA-02231: missing or invalid option to ALTER DATABASE Jadi masih error, Mohon pencerahan lagi. Thx & Rgds Iwan --- In [email protected], Mohammad Arief Pradipto <arief.pradi...@...> wrote: > > Karena controlfile tersebut masih berupa standby control file, maka database > standby belum bisa up sebagai primary, karena harus diaktifkan dulu. > Mengaktifkan database dengan command berikut > > -- Database dalam keadaan mount standby database > SQL> alter database recover managed standby database finish > SQL> alter database activate standby database; > > Database sudah dalam keadaan open, tapi sebaiknya bounce database dulu > SQL> shutdown immediate; > SQL> startup; > > > regards, > > adipt > > ----- Original Message ----- > From: iwantfree s<mailto:iwantof...@...> > To: [email protected]<mailto:[email protected]> > Sent: Monday, February 01, 2010 5:40 PM > Subject: External Email: --> [indo-oracle] Tolongin bantu karena masalah di > Standby Oracle server > > > > Dear master-master Oracle, > > Saya ada problem di Oracle Standby Server. karena ternyata ada gap sequence, > sehingga tidak dapat berfungsi lagi. Saya mau ambil 1 schema saya. Saya mau > ubah jadi primary standby server ini . > Saya cari referensi di google , dan saya sudah menjalankan beberapa langkah, > tetapi gagal > > SQL> Alter database recover managed standby database finish force; > alter database recover managed standby database finish > * > ERROR at line 1: > ORA-00283: recovery session canceled due to errors > ORA-16171: RECOVERâ¦FINISH not allowed due to gap for thr 1, seq 4152-4251 > > Then , Try last Step : > > SQL> recover STANDBY database until cancel ; > > ORA-00279 : CHANGE 74829519 GENERATED AT 04/13/2009 05:21:46 NEEDED FOR > THREAD 1 > ORA-00289 : SUGGESTION : /U01/APP/ORACLE/ORADATA/1_4152_648754960.DBF > ORA-00280 : CHANGE 74829519 FOR THREAD 1 IS IN SEQUENCE #4152 > > Specify log: {<RET>=suggested | filename | AUTO | CANCEL} > CANCEL > ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below > ORA-01196: file string is inconsistent due to a failed media recovery session > ORA-01110 : DATA FILE 1 : '/U01/APP/ORACLE/ORADATA/SD/SYSTEM02.DBF' > ORA-01112 : MEDIA RECOVERY NOT STARTED > > SQL> ALTER DATABASE OPEN RESETLOGS; > ALTER DATABASE OPEN RESETLOGS; > * > > ERROR AT LINE 1 > ORA-01666 : CONTROL FILE IS FOR A STANDBY DATABASE > > Tolong lah para master oracle, apa yang harus saya perbuat agar data yg ada > di standby server ini bisa saya ambil > > Thx&Rgds > > Iwan > > New Email addresses available on Yahoo! > Get the Email name you've always wanted on the new @ymail and @rocketmail. > Hurry before someone else does! > http://mail.promotions.yahoo.com/newdomains/sg/ > > [Non-text portions of this message have been removed] > > > > > ________________________________ > Mulai 1 januari 2010 PT. Federal International Finance menempati gedung baru > > MENARA FIF - Jl. TB. Simatupang Kav. 15, Cilandak Barat Jakarta 12340, Telp: > (021) 769 8899, Fax: (021) 7590 5599 > > > [Non-text portions of this message have been removed] >
