Home » Server Options » Data Guard » how to apply redo log in standby database
how to apply redo log in standby database [message #320387] Wed, 14 May 2008 23:35 Go to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

i want to apply redo log in standby database.
how i can do it?
Re: how to apply redo log in standby database [message #320405 is a reply to message #320387] Thu, 15 May 2008 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter database managed standby database [disconnect];

Regards
Michel
Re: how to apply redo log in standby database [message #320795 is a reply to message #320405] Fri, 16 May 2008 04:50 Go to previous messageGo to next message
mbhavin
Messages: 32
Registered: May 2008
Location: INDIA
Member

where this command run on primary database or in standby database?
Re: how to apply redo log in standby database [message #320799 is a reply to message #320795] Fri, 16 May 2008 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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.
Re: how to apply redo log in standby database [message #320828 is a reply to message #320802] Fri, 16 May 2008 06:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So read malvika posts and follow the advices I gave her.

Regards
Michel
Re: how to apply redo log in standby database [message #320979 is a reply to message #320828] Sat, 17 May 2008 04:48 Go to previous messageGo to next message
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
Re: how to apply redo log in standby database [message #320990 is a reply to message #320387] Sat, 17 May 2008 08:15 Go to previous messageGo to next message
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.
Re: how to apply redo log in standby database [message #321073 is a reply to message #320990] Sun, 18 May 2008 23:34 Go to previous message
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.
Previous Topic: Data Guard concept- Redo Transport Services
Next Topic: Logs are not transmitting and ORA-16047 error
Goto Forum:
  


Current Time: Thu Mar 28 12:16:41 CDT 2024