Home » Server Options » Data Guard » Manual setup of Logical Standby 10g (Oracle 10.2.0.4, RH Linux)
Manual setup of Logical Standby 10g [message #411866] Tue, 07 July 2009 03:52 Go to next message
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!
Re: Manual setup of Logical Standby 10g [message #411869 is a reply to message #411866] Tue, 07 July 2009 03:57 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: Manual setup of Logical Standby 10g [message #411880 is a reply to message #411866] Tue, 07 July 2009 04:17 Go to previous messageGo to next message
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 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


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

Thanks
Re: Manual setup of Logical Standby 10g [message #412130 is a reply to message #411866] Tue, 07 July 2009 22:14 Go to previous messageGo to next message
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 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Read The Fine Manual
http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-BAC
Previous Topic: DataGuard Swithover
Next Topic: DataGuard
Goto Forum:
  


Current Time: Sat Dec 10 13:10:01 CST 2016

Total time taken to generate the page: 0.09424 seconds