1 / 38

Oracle 10.2 RAC New Features

Oracle 10.2 RAC New Features. Julian Dyke Independent Consultant. Web Version. juliandyke.com. CLUVFY. CLUVFY. Introduced in Oracle 10.2 Read-only utility that verifies configuration of cluster at each stage of cluster installation Detects many common configuration errors

tamas
Download Presentation

Oracle 10.2 RAC New Features

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Oracle 10.2RAC New Features Julian Dyke Independent Consultant Web Version juliandyke.com

  2. CLUVFY

  3. CLUVFY • Introduced in Oracle 10.2 • Read-only utility that verifies configuration of cluster at each stage of cluster installation • Detects many common configuration errors • Eliminates time-consuming troubleshooting • Supplied with Oracle Clusterware • Can be installed separately • Can also be used with Oracle 10.1 • Requires -r 10gR1 switch

  4. CLUVFY • Written in Java - requires JRE • Supplied with JRE • Alternatively can use existing JRE • Must set CV_JDKHOME environment variable • On Red Hat Linux also requires cvuqdisk package • Supplied on Oracle Clusterware CD rpm --Uvh cvuqdisk-1.0.1-1.rpm

  5. CLUVFY • Checks • stages • components • Stage checks • Verify all steps for specified stage have been completed • Component checks • Verify specified component has been correctly installed sh runcluvfy.sh -helpsh runcluvfy.sh stage -helpsh runcluvfy.sh comp -help

  6. CLUVFY • Stages include:

  7. CLUVFY • Components include:

  8. CLUVFY • For example, to check configuration before installing Oracle Clusterware on node1 and node2 use: sh runcluvfy.sh stage -pre crsinst -n node1,node2 • Checks: • node reachability • user equivalence • administrative privileges • node connectivity • shared stored accessibility • If any checks fail append -verbose to display more information

  9. OracleClusterwareFile Mirroring

  10. OCR and Voting Disk Mirroring • RAC databases contain • controlfiles • datafiles • online redo logs • server parameter files • password files • archive log files • In addition RAC clusters contain • Oracle Cluster Repository (OCR) • formerly SRVM file • Voting Disk • formerly CSS file

  11. OCR and Voting Disk Mirroring • In Oracle 10.1 and below • only one copy of OCR and Voting Disk • can be corrupted • can be deleted • can be inaccessible • loss of either prevents access to all databases in cluster • In Oracle 10.2 and above • OCR can be mirrored • maximum two copies • Voting Disk can be mirrored • recommended three copies

  12. Instance 1 Instance 2 Node1 Node2 OCR and Voting Disk Mirroring Oracle 10.1 OCR Voting Disk 1 Database Files Database Files Database Files

  13. Instance 1 Instance 2 Node1 Node2 OCR and Voting Disk Mirroring Oracle 10.2 OCR OCR Mirror Voting Disk 1 Voting Disk 2 Voting Disk 3 Database Files Database Files Database Files

  14. DBCADatabaseCloning

  15. DBCA - Database Cloning • Creating a Clone Template Manage Templates

  16. DBCA - Database Cloning Create database template from an existing database (structure and data)

  17. DBCA - Database Cloning Choose database from which to create the template

  18. DBCA - Database Cloning Specify name and description of template Specify location where RMAN copies of datafiles will be created.

  19. DBCA - Database Cloning Choose locations of database files

  20. DBCA - Database Cloning • Template creation completion message

  21. DBCA - Database Cloning • Creating a Clone Database Create Database

  22. DBCA - Database Cloning Manage Templates Select nodes on which to create cluster database

  23. DBCA - Database Cloning Select template(Template2) Includes Datafiles = Yes=> Clone

  24. DBCA - Database Cloning Select Global Database Name Select SID

  25. DBCA - Database Cloning Select SID Configure Management Options

  26. DBCA - Database Cloning Select SID Set Passwords

  27. DBCA - Database Cloning Select Storage Option(ASM)

  28. DBCA - Database Cloning Select ASM Diskgroup(DISKGROUP1)

  29. DBCA - Database Cloning Select Oracle-Managed Files (OMF)

  30. DBCA - Database Cloning Optionally enable Flash Recovery Area and Archiving

  31. DBCA - Database Cloning Specify optional; custom initialization scripts Optionally enable Flash Recovery Area and Archiving

  32. DBCA - Database Cloning Add Services

  33. DBCA - Database Cloning Set initialisation parameters

  34. DBCA - Database Cloning Configure storage

  35. DBCA - Database Cloning Create Database or Generate Database Creation Scripts

  36. DBCA - Database Cloning Create Database or Generate Database Creation Scripts Log files in $ORACLE_HOME/cfgtoollogs/dbca/CLONE

  37. DBCA - Database Cloning Create Database or Generate Database Creation Scripts

  38. Thank you for listening info@juliandyke.com

More Related