Jump to content

*************ORAACLE DATAGUARD HELP*********************************************

vijay2349

By vijay2349
in Old Discussions

 Share

Recommended Posts

vijay2349 Celebrity

vijay2349

Posted
  • Author
Posted

[quote author=Musugu_Veerudu link=topic=209400.msg2560363#msg2560363 date=1309844020]
entha critical ba e issue ni resolve cheyatam ?

n moreover .. node 1,2 nunchi probs ippude osthondha..lekapothe nuvu ippudee gamaninchaava ?

incase primary database kani STandby db ki ping cheyyalekapoyindi ante.. u will definetly see some ORA errors in primary db's alert log
[/quote]

primary nundi DG ki ping ayutundi.
I found some ora errros in aerltog file like ora-12537/16191/1017 in past (2 weeks back)

but last 2 days nundi emi errors report kaaledu...  but recover got struck

Gachibowli_Diwakar LEGEND

Gachibowli_Diwakar

Posted
Posted

[quote author=SOURYAM link=topic=209400.msg2560368#msg2560368 date=1309844143]
SQL> select PROCESS,THREAD#,SEQUENCE# from  v$managed_standby;

PROCESS      THREAD#  SEQUENCE#
--------- ---------- ----------
ARCH              0          0
ARCH              0          0
RFS                0          0
RFS                0          0
RFS                0          0
MRP0              3      43081
RFS                0          0
RFS                0          0
RFS                0          0
RFS                0          0
RFS                0          0

PROCESS      THREAD#  SEQUENCE#

output ala vacchindi baa.
but rac lo kuda 3 nodes nundi archive files vastayiga... sCo_^Y
[/quote]status kuda print cheyi ba aah view nunchi

also .. multi-node primary ki..multi-node standby database configuration unte (which I guess is your configuration) .. check below link .. it explains clearly
[url=http://www.dba-oracle.com/real_application_clusters_rac_grid/single_instance.htm]http://www.dba-oracle.com/real_application_clusters_rac_grid/single_instance.htm[/url]

primary instance nunchi.. connect avvagalavemo kuda chudu to standby database (sqlplus "sys/password as sysdba"@ORACLE_SID )

vijay2349 Celebrity

vijay2349

Posted
  • Author
Posted

[quote author=Musugu_Veerudu link=topic=209400.msg2560376#msg2560376 date=1309844617]
status kuda print cheyi ba aah view nunchi

also .. multi-node primary ki..multi-node standby database configuration unte (which I guess is your configuration) .. check below link .. it explains clearly
[url=http://www.dba-oracle.com/real_application_clusters_rac_grid/single_instance.htm]http://www.dba-oracle.com/real_application_clusters_rac_grid/single_instance.htm[/url]

primary instance nunchi.. connect avvagalavemo kuda chudu to standby database (sqlplus "sys/password as sysdba"@ORACLE_SID )
[/quote]

PROCESS      THREAD#  SEQUENCE# STATUS
--------- ---------- ---------- ------------
ARCH              0          0 CONNECTED
ARCH              0          0 CONNECTED
RFS                0          0 IDLE
RFS                0          0 IDLE
RFS                0          0 IDLE
MRP0              3      43083 WAIT_FOR_LOG
RFS                0          0 IDLE
RFS                0          0 IDLE
RFS                0          0 IDLE
RFS                0          0 IDLE
RFS                0          0 IDLE

PR

Gachibowli_Diwakar LEGEND

Gachibowli_Diwakar

Posted
Posted

[quote author=SOURYAM link=topic=209400.msg2560371#msg2560371 date=1309844296]
primary nundi DG ki ping ayutundi.
I found some ora errros in aerltog file like ora-12537/16191/1017 in past (2 weeks back)

but last 2 days nundi emi errors report kaaledu...  but recover got struck
[/quote]password file undaali corresponding primary db dhi.. on all standby db's at different nodes under $ORACLE_HOME/dbs folder lo

Gachibowli_Diwakar LEGEND

Gachibowli_Diwakar

Posted
Posted

[quote author=SOURYAM link=topic=209400.msg2560379#msg2560379 date=1309844823]
PROCESS      THREAD#  SEQUENCE# STATUS
--------- ---------- ---------- ------------
ARCH              0          0 CONNECTED
ARCH              0          0 CONNECTED
RFS                0          0 IDLE
RFS                0          0 IDLE
RFS                0          0 IDLE
MRP0              3      43083 WAIT_FOR_LOG
RFS                0          0 IDLE
RFS                0          0 IDLE
RFS                0          0 IDLE
RFS                0          0 IDLE
RFS                0          0 IDLE

PR
[/quote]WAIT_FOR_LOG .. hmm that tells the story .. aah thread# 3 ani undhi ga .. aah corresponding primary/standby database ki velli chudu asalu aah archive log undho ledho ani

u can use Name/deleted and different attributes under v$archived_log on primary db's

something like .. select name,deleted,sequence#,thread# from v$archived_log where dest_id=1;  (dest_id=1 ante.. primary db lo store ayye archive log ani .. so depending on ur standby db service name configured like log_archive_dest_2 etc.. dest_id map cheskoni chudu)

vijay2349 Celebrity

vijay2349

Posted
  • Author
Posted

[quote author=Musugu_Veerudu link=topic=209400.msg2560382#msg2560382 date=1309844890]
password file undaali corresponding primary db dhi.. on all standby db's at different nodes under $ORACLE_HOME/dbs folder lo
[/quote]
ade nenu kuda ade anukuntunnau .aa errors anni kuda password file not in sync unnayi..

but indaka post output  lo  thread# kinda thread 1 and 2 leventi only thread 3 undi...

Gachibowli_Diwakar LEGEND

Gachibowli_Diwakar

Posted
Posted

[quote author=SOURYAM link=topic=209400.msg2560386#msg2560386 date=1309845110]
ade nenu kuda ade anukuntunnau .aa errors anni kuda password file not in sync unnayi..

but indaka post output  lo  thread# kinda thread 1 and 2 leventi only thread 3 undi...
[/quote]primary nunchi radhu.. becos oka node lo ne recovery nadusthundi kabatti .. inko standby nunchi (which is not performing recovery)archive log osthundhi .. as per the link I gave you before

orapwd utility use chesi password file create chesko on primary node.. dhaanni scp cheyi standby ki

also.. standby db lo ekkadaithe recovery avvatledho..akkada kuda password file create chesi.. copy cheyi recovery authunna standby db node ki

Gachibowli_Diwakar LEGEND

Gachibowli_Diwakar

Posted
Posted

naku thala pagilipothondhi mama .. severe headache

google is your guru .. u'll find something for sure ..

worst case lo.. scp chesey archive logs ni to standby node..tarvatha register cheyi (alter database register logfile '<file_name'>;) standby db lo

vijay2349 Celebrity

vijay2349

Posted
  • Author
Posted

[quote author=Musugu_Veerudu link=topic=209400.msg2560389#msg2560389 date=1309845444]
naku thala pagilipothondhi mama .. severe headache

google is your guru .. u'll find something for sure ..

worst case lo.. scp chesey archive logs ni to standby node..tarvatha register cheyi (alter database register logfile '<file_name'>;) standby db lo
[/quote]

thanks for u time baa..present ki log pushing chestunnu.. H&*() H&*() H&*()

repu time unte okasari chustava incase  inka solve avvakapote...naa gmail id pm chesanu  ..add chesuko..

Gachibowli_Diwakar LEGEND

Gachibowli_Diwakar

Posted
Posted

[quote author=SOURYAM link=topic=209400.msg2560391#msg2560391 date=1309845772]
thanks for u time baa..present ki log pushing chestunnu.. H&*() H&*() H&*()

repu time unte okasari chustava incase  inka solve avvakapote...naa gmail id pm chesanu  ..add chesuko..
[/quote]Go through the below document
[url=http://www.oracle.com/technetwork/database/features/availability/dataguard11g-rac-maa-1-134639.pdf]http://www.oracle.com/technetwork/database/features/availability/dataguard11g-rac-maa-1-134639.pdf[/url]

Make sure that you have the TNS settings like the document says in  Page 17

 Share
Go to topic listing
×
×
  • Create New...