Home » Server Options » RAC & Failsafe » how to setup archivelog mode in RAC (oracle db,10G,windows 2003)
how to setup archivelog mode in RAC [message #425371] Thu, 08 October 2009 15:45 Go to next message
mamingui
Messages: 83
Registered: July 2006
Member
hi all,

thanks in advance for your help.
someone can give step by step points to put a rac database (2 nodes) in archivelog mode. I want to do it properly.

Thanks
Re: how to setup archivelog mode in RAC [message #425372 is a reply to message #425371] Thu, 08 October 2009 15:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Choose your options.
http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/rmanops.htm#BABBBGCI

Mount in single-instance mode with restricted session and exclusively.

The steps to put the database in archive log mode as just as same in a single instance database.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/archredo.htm#i1106237
Re: how to setup archivelog mode in RAC [message #425373 is a reply to message #425371] Thu, 08 October 2009 15:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And the first hit in google took me here
http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle10gRAC/CLUSTER_30.shtml
Re: how to setup archivelog mode in RAC [message #425688 is a reply to message #425373] Sun, 11 October 2009 19:04 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Thanks for your help,

I want to have a step by step procedure to enabling archivelog mode with more details. For example : is it mandatory to set parameter (log_archive_dest_1) in both nodes ? in what order ?

Thanks Sad



Re: how to setup archivelog mode in RAC [message #425818 is a reply to message #425688] Mon, 12 October 2009 06:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yes.
The best step-by-step instructions are in manual which is already provided.
Re: how to setup archivelog mode in RAC [message #426125 is a reply to message #425371] Wed, 14 October 2009 02:52 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Thanks for your help,

But I want to be sure that my archivelog setup is correct.
So this is the output of command line archive log list.

1)Node1 : archive log list
Database log mode : Archive Mode
Automatic archival: Enabled
Archive destination: M:\
oldest online log sequence: 752
Next log sequence to archive: 753
Current log sequence: 753

2)Node2 : archive log list
Database log mode : Archive Mode
Automatic archival: Enabled
Archive destination: M:\
oldest online log sequence: 269
Next log sequence to archive: 270
Current log sequence: 270

Please tell me if something is wrong !! Razz
Re: how to setup archivelog mode in RAC [message #426141 is a reply to message #426125] Wed, 14 October 2009 03:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From what you posted, nothing seems wrong.

Regards
Michel
Re: how to setup archivelog mode in RAC [message #426221 is a reply to message #426141] Wed, 14 October 2009 07:47 Go to previous message
mamingui
Messages: 83
Registered: July 2006
Member
Thanks Guys
Previous Topic: unable to find rac connection information
Next Topic: Identify IP address of AIX server on Oracle RAC
Goto Forum:
  


Current Time: Thu Mar 28 03:37:06 CDT 2024