Database/standby Help*********

[vijay2349]

Primary database meeda

alter database recover managed standby database cancel

command cheste emayutundi??


Any idea ?

[Gachibowli_Diwakar]

recovery lo lenapudu ..aah command isthe em untundi.. ORA- error osthundhi .. anthe kani .. no impact

[Sastrygaru]

I heard Sreeramudu yiz is a good boy..

[vijay2349]

[quote name='Silence..Please' timestamp='1328419512' post='1301378825']
recovery lo lenapudu ..aah command isthe em untundi.. ORA- error osthundhi .. anthe kani .. no impact
[/quote]

error vacchindi..

but still tension/

alert log log lo errors scroll ayutu unnayi..ippude alert log check chesa..avi feb 02 nundi unnayi..so koddiga relive ayya.



inko twist enante ivvala nenu chesin vp pani.

standby control file ni primary lo create chesi.primary ki scp chesinattu unnanu ??

still confision nenu chesanu evadina chesada ani,?

db shut ayyindi..

kakapote tondaraga alert ayyi malli services start chesa..

Customer escalate cheste tueday naa last day ayutundemo.. !q# !q# !q# !q#

[Gachibowli_Diwakar]

[quote name='AFDB SREERAAMUDU' timestamp='1328420161' post='1301378840']
error vacchindi..

but still tension/

alert log log lo errors scroll ayutu unnayi..ippude alert log check chesa..avi feb 02 nundi unnayi..so koddiga relive ayya.



inko twist enante ivvala nenu chesin vp pani.

standby control file ni primary lo create chesi.primary ki scp chesinattu unnanu ??

still confision nenu chesanu evadina chesada ani,?

db shut ayyindi..

kakapote tondaraga alert ayyi malli services start chesa..

Customer escalate cheste tueday naa last day ayutundemo.. !q# !q# !q# !q#
[/quote]
baabu Control File tho kathalu padaku .. db will become useless.. and u will end up in restoring the db theda aindhi ante .. pay gud attention when u r dealing with Control file

aina Primary lo control file create chesi.akkadi k scp ela authundi ?

[vijay2349]

[quote name='Silence..Please' timestamp='1328420290' post='1301378844']
baabu Control File tho kathalu padaku .. db will become useless.. and u will end up in restoring the db theda aindhi ante .. pay gud attention when u r dealing with Control file

aina Primary lo control file create chesi.akkadi k scp ela authundi ?
[/quote]
ade naaku kuda doubt.

nenu standby host clear ga metion chesinattu clear idea undi..but still PROD ela crash ayyindo inka ardam kaadaledu.


alert log eee errror undi.


CONTROL FILE WAS CHANGED WHILE MOUNTED .PLEASE CHECK IF ANOTHER ORALCE DATABASE IS RUNNING AND ACCESSING THE SAME CONTROL FILE\


dani meaning endi???

[vijay2349]

[quote name='Sastrygaru' timestamp='1328420120' post='1301378839']
I heard Sreeramudu yiz is a good boy..
[/quote]


situation is too bad baa..

[Gachibowli_Diwakar]

[quote name='AFDB SREERAAMUDU' timestamp='1328420540' post='1301378854']
ade naaku kuda doubt.

nenu standby host clear ga metion chesinattu clear idea undi..but still PROD ela crash ayyindo inka ardam kaadaledu.


alert log eee errror undi.


CONTROL FILE WAS CHANGED WHILE MOUNTED .PLEASE CHECK IF ANOTHER ORALCE DATABASE IS RUNNING AND ACCESSING THE SAME CONTROL FILE\


dani meaning endi???
[/quote].history file lo em commands type chesaavo telusthundi Unix level lo adhi check cheyi ..

may be idhe change chesaav emo .. lekapothe mount aina db's controlfile change aindhi ani enduku antundi primary db's alertlog lo

moreover .. standby controlfile ani kada create chesaav primary lo.. before if u have replaced primary's with this standby-control file .. db ela UP aindhi crash ayyaaka? chuusthe kani cheppalem ba

[Sastrygaru]

[quote name='AFDB SREERAAMUDU' timestamp='1328420578' post='1301378855']


situation is too bad baa..
[/quote]
What happened ree? work tension hai kya?

[vijay2349]

[quote name='Silence..Please' timestamp='1328420775' post='1301378859']
.history file lo em commands type chesaavo telusthundi Unix level lo adhi check cheyi ..

may be idhe change chesaav emo .. lekapothe mount aina db's controlfile change aindhi ani enduku antundi primary db's alertlog lo

moreover .. standby controlfile ani kada create chesaav primary lo.. before if u have replaced primary's with this standby-control file .. db ela UP aindhi crash ayyaaka? chuusthe kani cheppalem ba
[/quote]


. history file location ekkada??

[Gachibowli_Diwakar]

[quote name='AFDB SREERAAMUDU' timestamp='1328420944' post='1301378862']


. history file location ekkada??
[/quote]
oracle user home directory lo untundi ba .. nuvu oracle user laga login avvagaane.. ye directory lo untaav .. general ga akkada chudu .. ledhante .profile ekada run chesthaav (if at all u run .profile).. akkada untundi

or else.. try this .. history -100 .. ani type chesi chudu ..emanna osthundhemo