Posts

Raw Disk Migration Steps (OCR,VOTING,ASM) – Oracle RAC 10g

Image
                                                            1)       Disk Migration of the OCR Disks ######################### a).        Backup all OCR-related files.   b).       C urrent Status of OCR disks.   {CRS_HOME}/bin/ocrcheck  c).       Backup the /var/opt/oracle/ocr.loc file:   cp ocr.loc ocr.loc.old     d).        Manually backup OCR: $ocrconfig -export   /exports/OCRFile_exp.dmp   Important : -   As root, run the following commands to replace OCR files. This change can be performed on-line, and will be reflected across the entire cluster. e). Replace new...
Post a Comment
Read more

Relocate/Rename of data files in Oracle 10g

Relocate/Rename of data files in Oracle 10g. Cause and Prerequisites You have created a datafile on the wrong filesystem or drive. You add a new filesystem(s), drive (s) to the system and want to redistribute the data files.You restore some datafiles to a new location because the original is not available any more Following Step perform for relocate data files as per Oracle 1. Full database backup and check consistency of backup. 2. Shutdown Database 3. Take the backup of contolfile. Syntex: - cp –pr control01.dbf /backup cp /ORCL/redolog_1/ctrlfile1/control01.ctl   /ORCL/redolog_1/ctrlfile1/control01.ctl_bkp cp /ORCL/redolog_2/ctrlfile2/control02.ctl   /ORCL/redolog_2/ctrlfile2/control02.ctl_bkp cp /ORCL/redolog_3/ctrlfile3/control03.ctl   /ORCL/redolog_3/ctrlfile3/control03.ctl_bkp 4. Copy the datafiles to the new location by using OS commands. Syntex: - cp -pr ‘Source_Location’ ‘Target_Location’ Copy Datafile...
Post a Comment
Read more