Oracle Vote & OCR Disk Migration to New Storage

Oracle Vote & OCR Disk Migration to New Storage

Vote Disk Migration

Prepare the new disks to be used as vote disk by Operating System command/tools. Procedure to configure new disks on AIX system is listed on my blog "Configure Oracle ASM Disks on AIX"

Shutdown the Oracle Clusterware (crsctl stop crs as root) on all nodes before making any modification to the voting disk.

Determine the current voting disk location using. Issue the commands as root user.

# crsctl query css votedisk

You would need to shutdown the Clusterware to replace voting disk

# crsctl stop crs

Add the New voting Disk

# crsctl add css votedisk '/dev/ora_vote3' -force

Delete the voting disk on old storage.

# crsctl delete css votedisk '/dev/ora_vote1' –force

Start the Clusterware

# crsctl start crs

Verify that new voting disks are added:

# crsctl query css votedisk

OCR Migration

Issue the following commands as root user.

Identify the current ocr devices.

# ocrcheck

To replace an OCR mirror device, provide the full path including file name.

# ocrconfig -replace ocrmirror /dev/ora-ocr4

To replace OCR use the following command

# ocrconfig -replace ocr /dev/ora-ocr3

Comments

Load records from csv file in S3 file to RDS MySQL database using AWS Data Pipeline

In this post we will see how to create a data pipeline in AWS which picks data from S3 csv file and inserts records in RDS MySQL table. I am using below csv file which contains a list of passengers. CSV Data stored in the file Passenger.csv Upload Passenger.csv file to S3 bucket using AWS ClI In below screenshot I am connecting the RDS MySQL instance I have created in AWS and the definition of the table that I have created in the database testdb. Once we have uploaded the csv file we will create the data pipeline. There are 2 ways to create the pipeline. Using "Import Definition" option under AWS console. We can use import definition option while creating the new pipeline. This would need a json file which contains the definition of the pipeline in the json format. You can use my Github link below to download the JSON definition: JSON Definition to create the Data Pipeline Using "Edit Architect" ...

How to check progress of dbcc shrinkfile

Query to check progress of dbcc shrinkfile select s.session_id,command,t.text,percent_complete,s.start_time from sys.dm_exec_requests s CROSS APPLY sys.dm_exec_sql_text(s.sql_handle) t where command like '%Dbcc%'

Unix Bash Script

Bash Script that will recursively find all files under a directory and also under sub-directories. It will print all the files and also show the count for the words inside the files. count_words.sh for i in `find $1 -name "*" -type f` do wc -w $i done count_words.sh <directory_name>

Akshay Narang

Search This Blog