OraFAQ Forum: Data Guard » Does standby redologs are applied online to datafile?

Home » Server Options » Data Guard » Does standby redologs are applied online to datafile?

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

Does standby redologs are applied online to datafile? [message #516729]

Wed, 20 July 2011 05:33

piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

Hi.

I am again with standby issue.
Till now i was prety sure that standby redologs are applied to database without any delay, but everything looks that the process is different.

i did on primary serwer table and add some records to this table.

next i switch to standby and open redologs (with hex editor) to look for this "create table" and "insert" commands. and i succeded. so this is prove that standby log are supplied by primary database.

next i cancelled recovery process and open database in readonly mode and there was no records in this standby db, moreover there wans't any table on standby. so i started to be confused, because i suspected that this table and it content will be on standby database.

hm...

next i started recover process again for standby database and do some switch log on primary serwer. after that i back to standby, cancel recovery process and open database in readonly mode. there was table and contents for it.

so my question is:

does standby redologs should be applied online to database or they are only applied after promoting standby database to primary database?
it looks like contens only from archivelog is applied to standby database. it is correct?

thanks.

database is 9i.

[Updated on: Wed, 20 July 2011 06:10]

Report message to a moderator

Re: Does standby redologs are applied online to datafile? [message #516735 is a reply to message #516729]

Wed, 20 July 2011 06:40

John Watson
Messages: 8869
Registered: January 2010
Location: Global Village

Senior Member

Quote:

next i started recover process again for standby database

Did you include the USING CURRENT LOGFILE clause?

Report message to a moderator

Re: Does standby redologs are applied online to datafile? [message #516823 is a reply to message #516735]

Thu, 21 July 2011 02:08

piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
  2  USING CURRENT LOGFILE disconnect from session;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
*
ERROR at line 1:
ORA-00274: illegal recovery option USING


SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
  2  disconnect from session;

Database altered.

SQL>

... so maybe this option is not supported in 9i database?

Report message to a moderator

Previous Topic:	Data Guard Failover
Next Topic:	standby - ASYNC and NOAFFIRM options seems not work :/

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 22 07:36:52 CDT 2023