googling aja "alter system register logfile"
On 3/12/09, Andes Febrian <[email protected]> wrote: > Dear gurus, > > saya punya kasus pada dataguard, karena directory /oradata/archive di > standby penuh, maka archive log dari primary tidak di transfer ke standby, > akhirnya terjadi lagging. archive log yg ketinggalan, sudah saya copy ke > /oradata/archive standby dari primary tp ketika saya coba ALTER DATABASE > RECOVER MANAGED STANDBY DATABASE DISCONNECT; blm terapply jg. > > gimana cara untuk mengatasi masalah lagging tersebut ya ? need help. > > server standby : > SQL> select thread#,max(sequence#) from v$log_history group by thread#; > > THREAD# MAX(SEQUENCE#) > ---------- -------------- > 1 5913 > > server primary : > SQL> select thread#,max(sequence#) from v$log_history group by thread#; > > THREAD# MAX(SEQUENCE#) > ---------- -------------- > 1 5926 > > saya sudah copy semua archive log pada /oradata/archive di standby, dari > archive log 5914 sampai 5926, kemudian jalankan yg paling pertama > 1. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; > karena posisi tadi nya masih ALTER DATABASE RECOVER MANAGED STANDBY DATABASE > / standby jalan. > 2. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; > > many thanks > > -- > Cheers, > ^_^ Andes ^_^ > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > > > -- thanks and regards ujang | oracle dba | mysql dba http://ora62.wordpress.com
