kalau pakai ini?
SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
regards,
joey
iwantfree s wrote:
>
>
> 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/
> <http://mail.promotions.yahoo.com/newdomains/sg/>
>
> [Non-text portions of this message have been removed]
>
>
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
[Non-text portions of this message have been removed]
