OraFAQ Forum: RAC & Failsafe » how to setup archivelog mode in RAC

Home » Server Options » RAC & Failsafe » how to setup archivelog mode in RAC (oracle db,10G,windows 2003)

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

how to setup archivelog mode in RAC [message #425371]

Thu, 08 October 2009 15:45

mamingui
Messages: 81
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

Report message to a moderator

Re: how to setup archivelog mode in RAC [message #425372 is a reply to message #425371]

Thu, 08 October 2009 15:56

Mahesh Rajendran
Messages: 10572
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

Report message to a moderator

Re: how to setup archivelog mode in RAC [message #425373 is a reply to message #425371]

Thu, 08 October 2009 15:58

Mahesh Rajendran
Messages: 10572
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

Report message to a moderator

Re: how to setup archivelog mode in RAC [message #425688 is a reply to message #425373]

Sun, 11 October 2009 19:04

mamingui
Messages: 81
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

Report message to a moderator

Re: how to setup archivelog mode in RAC [message #425818 is a reply to message #425688]

Mon, 12 October 2009 06:45

Mahesh Rajendran
Messages: 10572
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Yes.
The best step-by-step instructions are in manual which is already provided.

Report message to a moderator

Re: how to setup archivelog mode in RAC [message #426125 is a reply to message #425371]

Wed, 14 October 2009 02:52

mamingui
Messages: 81
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