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:[email protected]> 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]
