Micronet800.co.uk

Oracle OCR 101: ocrcheck – Status of Oracle Cluster Registry ocrdump –  The ocrdump command can be used to dump the OCR, by default it will output to a text file in the current directory. ocrconfig -showbackup – will show the current status of the automatic OCR backups and location. ocrconfig -restore FILENAME – will…

Oracle DBNEWID change DBID *  Backup the database. *  Mount the database after a clean shutdown: SHUTDOWN IMMEDIATE STARTUP MOUNT * Invoke the DBNEWID utility (nid) specifying the new DBNAME from the command line using a user with SYSDBA privilege: nid TARGET=sys/password@currentdatabase DBNAME=newdatabase Assuming the validation is successful the utility prompts for confirmation before performing…

Full list of Oracle parameters: col name format a35 col value format a35 SELECT name, value FROM v$parameter ORDER BY 1; List modified Oracle Parameters: col name format a35 col value format a35 SELECT name, value FROM v$parameter WHERE isdefault = ‘FALSE’ ORDER BY 1; List unsupported Oracle parameters: set pagesize 0 set linesize 100…

The flash recovery area location and size are specified by the initialization parameters DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE. To change the flash recovery area location and size: Using SQL Command Line, log in and connect to the database as SYSDBA. To change the size of the flash recovery area, enter the following command at the SQL Command…

To list the ocr file locations run ocrcheck To list the  the voting disks setup in Oracle use  crsctl query css votedisk Ainetvst