RAC Post installation Activities.

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

RAC Post installation Activities.

Postby sivakumarocp » Mon Jun 18, 2012 1:25 pm

Hi Tim,

I would like to know the list of RAC post installation activities that we need to do after we installed 2 or 3 node RAC (in both 11g r2 and 10g r2).
Regards
Sivakumar.A
www.sivakumardba.com
sivakumarocp
Advisor
 
Posts: 256
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: RAC Post installation Activities.

Postby Tim... » Mon Jun 18, 2012 2:20 pm

Hi.

Can you be more specific? What type of post-installation things are you thinking about?

- Backups?
- DR testing?
- Monitoring tools?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17967
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: RAC Post installation Activities.

Postby sivakumarocp » Mon Jun 18, 2012 2:46 pm

Yes, tasks like configuring backups, and monitoring tools.

In monitoring tools, what kind of things we need to monitor like logfile purge,node availibility..etc.

do we need to write a scirpt to automate all those things?
Regards
Sivakumar.A
www.sivakumardba.com
sivakumarocp
Advisor
 
Posts: 256
Joined: Sat Jun 27, 2009 3:53 am
Location: India

Re: RAC Post installation Activities.

Postby Tim... » Mon Jun 18, 2012 3:08 pm

Hi.

1) You should be using Grid Control to do just about everything to RAC. The local DBConsole is not idea for RAC and is not supported for Data Guard environments at all.

2) Assuming you are using Grid Control, almost all the monitoring is available out-of-the-box.

3) Backups should be taken using RMAN. If you are using Grid Control, you can schedule the default backup and that is fine. If you have custom needs, then obviously, set the appropriate parameters when defining the job.

4) Consider making specific backups of the OCR location and voting disks.

5) Test failure of all parts of the system, including loss of OCR location and votoing disks, as well as database recoveries.

Remember, Grid Control does not cost any additional money, provided you are using it to monitor servers that are properly licensed. If you are going to use it, you will need to place it on separate hardware, so that failure of any existing hardware will not cause GC to fail.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17967
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle RAC and Clusterware

Who is online

Users browsing this forum: No registered users and 2 guests

cron