OraFAQ Forum: Data Guard » problem with Next log sequence

Home » Server Options » Data Guard » problem with Next log sequence

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

problem with Next log sequence [message #240361]

Thu, 24 May 2007 12:24

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Hi
I configured Real time Dg. But there is Problem in Next log sequence on standby it shows 0 ,although i checked it by creating a table on primary and then i checked it on standby it was there.

Primary
SQL>  archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u40/oracle/flps/oraarc
Oldest online log sequence     159
Next log sequence to archive   168
Current log sequence           168

Standby
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u40/oracle/flps/oraarc
Oldest online log sequence     159
Next log sequence to archive   0--------------------->>>not as primay
Current log sequence           168

But Mine Dg Works well.
Any recomendations for this???

Report message to a moderator

Re: problem with Next log sequence [message #240552 is a reply to message #240361]

Fri, 25 May 2007 03:37

amit_p_dixit
Messages: 31
Registered: November 2006
Location: Mumbai

Member

hi,

after setting the right parameters in pfile... u take the cold back for DRDB... at this time take the backup of datafiles and standby control files which u have created...don't take the backup of redo log file.... at switchover oracle will automatically make the redos 4 u...

try this solution it should work... u will get the next seq no at DR..

Amit

Report message to a moderator

Re: problem with Next log sequence [message #240668 is a reply to message #240361]

Fri, 25 May 2007 08:12

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

That's good to know, because the documentation recommends that you backup the redo logs and copy them over to the standby database manually, to save time. See:

"The SQL ALTER DATABASE statement used to perform the switchover automatically creates online redo logs if they do not already exist. This might significantly increase the time required to complete the COMMIT operation. Therefore, Oracle Corporation recommends that you always manually add online redo logs to the target standby database when you create it.

"After you manually add the online redo logs, use the following SQL statement on the physical standby database that you want to transition to the primary role:

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;"

See: http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96653/role_management.htm#1024109

Report message to a moderator

Previous Topic:	MR(fg) WAIT_FOR_LOG why ?
Next Topic:	Real Time Apply -- does it apply to DG 9.2?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 17:01:03 CST 2025