OraFAQ Forum: Data Guard » how to apply redo log in standby database

Home » Server Options » Data Guard » how to apply redo log in standby database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to apply redo log in standby database [message #320387]

Wed, 14 May 2008 23:35

malvika
Messages: 55
Registered: May 2008
Location: india

Member

i want to apply redo log in standby database.
how i can do it?

Report message to a moderator

Re: how to apply redo log in standby database [message #320405 is a reply to message #320387]

Thu, 15 May 2008 00:42

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

alter database managed standby database [disconnect];

Regards
Michel

Report message to a moderator

Re: how to apply redo log in standby database [message #320795 is a reply to message #320405]

Fri, 16 May 2008 04:50

mbhavin
Messages: 32
Registered: May 2008
Location: INDIA

Member

where this command run on primary database or in standby database?

Report message to a moderator

Re: how to apply redo log in standby database [message #320799 is a reply to message #320795]

Fri, 16 May 2008 04:54

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

standby

By the way, even if you change your id, I see this is you and I see you still did not read the documentation and tried to guess what you have to do.

Regards
Michel

[Updated on: Fri, 16 May 2008 04:56]

Report message to a moderator

Re: how to apply redo log in standby database [message #320802 is a reply to message #320799]

Fri, 16 May 2008 04:59

mbhavin
Messages: 32
Registered: May 2008
Location: INDIA

Member

i am not change my id but only want to know where this command apply...mbhavin

and by the way malvika and me both working in same company as a juniour DBA.
ok.

Report message to a moderator

Re: how to apply redo log in standby database [message #320828 is a reply to message #320802]

Fri, 16 May 2008 06:46

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So read malvika posts and follow the advices I gave her.

Regards
Michel

Report message to a moderator

Re: how to apply redo log in standby database [message #320979 is a reply to message #320828]

Sat, 17 May 2008 04:48

malvika
Messages: 55
Registered: May 2008
Location: india

Member

while creating physical standby database

i completed all the thing succesfull

even my archived log are receieved at the destination standby location .

but none of my archived log can be applied

give your suggestion please

Report message to a moderator

Re: how to apply redo log in standby database [message #320990 is a reply to message #320387]

Sat, 17 May 2008 08:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>but none of my archived log can be applied
>give your suggestion please

Do it correctly.

A more definitive answer might be forthcoming if you were to use CUT & PASTE so we could actually see what you are doing & EXACTLY how/what RMAN responds.

Report message to a moderator

Re: how to apply redo log in standby database [message #321073 is a reply to message #320990]

Sun, 18 May 2008 23:34

malvika
Messages: 55
Registered: May 2008
Location: india

Member

hi.
thanks.

i got all the archived log file in my specified location in 'standby init.ora' file. and but that all archived log not performe and if i start my database (standby) by using follwing steps.

1. startup nomount pfile='sinit.ora'
2.alter database mount standby database.
3.alter database recover managed standby database disconnect from session.
4.alter open read only.
5.select count(*) from v$archived_log;
at this step i get all the archive file which on primary database same in standby database.
6.select * from test;
here i can't see the same result data which is im primary database test table.
7.alter system switch logfile (on primary database)
after this i cant see the changed data in standby database.
8.recover managed standby database cancel;
masseged i get 'media recovery conpleted'
9.select count(*) from test;
then also not get current change data in primary side.
10.recover standby database
here they want archivedlog file_6.log ,all time when i perform this statement, why this is done tell me .why it required same file all time if i again restart database (standby )why?

tell me if i get all archived log file current postion in standby then why that arcived not performe.

Report message to a moderator

Previous Topic:	Data Guard concept- Redo Transport Services
Next Topic:	Logs are not transmitting and ORA-16047 error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 14:53:47 CST 2025