Setalah saya coba :
SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;
ORA-16136 : Managed Standby Recovery not active;
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
ORA-01196 : File 1 inconsistent due to a failed media recovery session
ORA-01110 : data file 1:' /u01/app/oracle/oradata/sd/system02.dbf'
Thx
--- In indo-oracle@yahoogroups.com, inijoey <inij...@...> wrote:
>
> 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]
>
