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]
