OraFAQ Forum: Data Guard » Manual setup of Logical Standby 10g

Home » Server Options » Data Guard » Manual setup of Logical Standby 10g (Oracle 10.2.0.4, RH Linux)

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

Manual setup of Logical Standby 10g [message #411866]

Tue, 07 July 2009 03:52

linuxos
Messages: 31
Registered: April 2009

Member

I want to use generic method to create a logical standby with Oracle 10g, as there are many errors with RMAN.

After normal shutdown of primary database, can I just copy all control file, data files, redo log files and archived log file(only the last one) to standby?

What's the purpose of and when will the process "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;" be finished?

Thanks!

Report message to a moderator

Re: Manual setup of Logical Standby 10g [message #411869 is a reply to message #411866]

Tue, 07 July 2009 03:57

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

>>After normal shutdown of primary database, can I just copy all control file, data files, redo log files and archived log file(only the last one) to standby?

Check Here

>>What's the purpose of and when will the process "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;" be finished?

Try This

Babu

Report message to a moderator

Re: Manual setup of Logical Standby 10g [message #411880 is a reply to message #411866]

Tue, 07 July 2009 04:17

linuxos
Messages: 31
Registered: April 2009

Member

I tried many many times but failed specailly setting the Standby Redo Log. I can see the archived logs are copied to standby but SQL Apply is not work!

After the Logical Standby step:
"ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE"

This error shows in alert log every second, I don't find such file in both side! ==>

failed to read missing logfile /ora10/arc2/primary/1_5_687436091.dbf

p.s. why the init parameter changes are required for logical standby as said by document:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ls.htm#BEIDIBAG

[Updated on: Tue, 07 July 2009 04:39]

Report message to a moderator

Re: Manual setup of Logical Standby 10g [message #411891 is a reply to message #411880]

Tue, 07 July 2009 04:40

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Post complete ORA- error message. Or post your alert log details.

Thanks

Report message to a moderator

Re: Manual setup of Logical Standby 10g [message #412130 is a reply to message #411866]

Tue, 07 July 2009 22:14

linuxos
Messages: 31
Registered: April 2009

Member

Since I've deleted the archived log files in the Primary. Even I run "crosscheck archivelog all" in RMAN, the Standby's alert log still ask for strange missing logs.

Then I export the data from primary, drop the database, recreate the database and import the data. Then I shutdown the database, and copy control files, data files, redo log files, standby redo log files to Standby. Then the error didn't show again.

Instead of deleting old archived log files manually, which RMAN command can be used for delete the archived logs?

CONFIGURE DEFAULT DEVICE TYPE TO DISK;
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-8';

Is this example enouhg?

[Updated on: Tue, 07 July 2009 22:22]

Report message to a moderator

Re: Manual setup of Logical Standby 10g [message #412131 is a reply to message #411866]

Tue, 07 July 2009 22:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Read The Fine Manual
http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-BAC

Report message to a moderator

Previous Topic:	DataGuard Swithover
Next Topic:	DataGuard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 13:50:29 CDT 2024