How To Check And Make A Script For Backup Of Parameters For Complete Exadata Box

Asset ID:	1-71-2268783.1
Update Date:	2017-05-24
Keywords:

Solution Type Technical Instruction Sure

Solution 2268783.1 : How To Check And Make A Script For Backup Of Parameters For Complete Exadata Box

Applies to:

Exadata X5-2 Eighth Rack - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Goal

We need to prepare a script which will backup all the parameters for exadata box
Like for DB ,we can use create pfile ='' from memory and SELECT ksppinm,ksppstvl FROM x$ksppi a,x$ksppsv b WHERE a.indx=b.indx and substr(ksppinm,1,1) = '_' ORDER BY ksppinm ;

we need script for backing up the other parameters at exadata level .(OS,cellserver,infinibadn and other components from Exadata)

Solution

There is no a direct form to check all the config params from exadata box.
there are several compoments involved (db node, cell, IB..) there is not such script to check that.
You can run exacheck which validates across the best practices and does make recomendations.

You can take from dbnode a snapshot from OS ( Snapshot-Based Backup of Oracle Linux Database Server)

https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/db_server.htm#DBMMN2202

for comparison.

References

<NOTE:1070954.1> - Oracle Exadata Database Machine exachk or HealthCheck
https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/db_server.htm#DBMMN2202

Attachments

This solution has no attachment