Archive

Archive for the ‘Oracle Rac’ Category

restoring OMF and NON OMF datafiles via RMAN

March 30, 2016 Leave a comment

Problem
if when restoring a database which has a mixture of OMF and NON OMF datafiles
you come across this error

channel c1: ORA-19870: error while restoring backup piece bk_6559_1_906629460
ORA-19504: failed to create file "+ASM_DATA/HFMP/DATAFILE/oddevcontent.dbf"
ORA-17502: ksfdcre:3 Failed to create file +ASM_DATA/HFMP/DATAFILE/oddevcontent.dbf
ORA-15001: diskgroup "ASM_DATA" does not exist or is not mounted
ORA-15001: diskgroup "ASM_DATA" does not exist or is not mounted

failover to previous backup

Recovery catalog is down or not connected to catalog, trying to reconnect.
Reconnection with the recovery catalog is successful.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03012: fatal error during compilation of command
RMAN-03028: fatal error code for command restore : 600
RMAN-00600: internal error, arguments [7530] [] [] [] []
[orahfm@rac1 (LMT:hfmp1) HFMP_20160329 ] $
[orahfm@rac1 (LMT:hfmp1) HFMP_20160329 ] $

Solution
The solution is to use “SET NEWNAME” when restoring non-OMF files. If using OMF files
then only the DB_CREATE_FILE_DEST needs to be set. But when it is a mixed env you must
use “SET NEWNAME” for all non-OMF datafiles that will be restored.

Eg
set newname for DATAFILE 7 to ‘+PRE_ASM_DATA/HFMP/DATAFILE/oddevcontent.dbf’;
switch DATAFILE 7 to datafilecopy ‘+PRE_ASM_DATA/HFMP/DATAFILE/oddevcontent.dbf’;

Advertisements
Categories: Oracle, Oracle Rac

ORA-00845: MEMORY_TARGET not supported on this system

June 12, 2014 Leave a comment

encountered the oracle error “ORA-00845: MEMORY_TARGET not supported on this system” on a 12c database recently and occurs when an instance tries to use AMM and tmpfs mount point is less than the value specified  in  parameter memory_max_target

to solve this issue we need to  unmount the tmpfs and mount with increased space for tmps and make sure that this change is made permanent by adding the enty in /etc/fstab


As root

# unmount  tmpfs

umount: /dev/shm: device is busy.
(In some cases useful info about processes that use
the device is found by lsof(8) or fuser(1))

# umount -l tmpfs

# mount -t tmpfs tmpfs -o size=10240m /dev/shm

# vi /etc/fstab

# cat /etc/fstab

tmps       /dev/shm        tmpfs    size=10240m    0    0

# exit

 

Categories: Oracle Rac

Change IP adresses of SCAN Name in Oracle 11gR2 RAC

November 14, 2013 Leave a comment
[root@rac1 ]# srvctl stop scan_listener
[root@rac1 ]# srvctl stop scan

Be sure that all the SCAN VIP services are down:

[root@rac1 ]# srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
SCAN VIP scan2 is enabled
SCAN VIP scan2 is not running
SCAN VIP scan3 is enabled
SCAN VIP scan3 is not running

reconfigure the virtual ip addresses

[root@rac1 ]# srvctl modify scan -n rac-scan.maverick.com
[root@rac1 ]# srvctl start scan
[root@rac1 ]# srvctl start scan_listener
[root@rac1 ]# srvctl config scan
Categories: Oracle Rac

Convery Single Instance to RAC Part 2

October 7, 2013 Leave a comment

Convery Single Instance to RAC Part 2

Step by step guide to covert Single Instance to RAC Part 2 by Satisbabu Gunukula

Categories: Oracle Rac

Covert single instance to RAC Part 1

October 7, 2013 Leave a comment

Covert single instance to RAC Part 1

Step by step guide to covert Single Instance to RAC Part 1 by Satisbabu Gunukula

Categories: Oracle Rac

restoring the OCR in 11gr2

February 21, 2013 Leave a comment

Restoring the OCR

If you back it up, there might come a time to restore it. Recovering the OCR from the physical backups is fairly straight forward, just follow these steps:

Locate the OCR backup using the ocrconfig command.

ocrconfig -showbackup

Stop Oracle Clusterware (on all nodes)

crsctl stop cluster -all

Stop CRS on all nodes

crsctl stop crs

Restore the OCR backup (physical) with the ocrconfig command.

ocrconfig -restore {path_to_backup/backup_file_to_restore}

Restart CRS

crsctl start crs

Check the integrity of the newly restored OCR:

cluvfy comp ocr -n all

You can also restore the OCR using a logical backup as seen here:

Locate your logical backup.

Stop Oracle Clusterware (on all nodes)

crsctl stop cluster -all

Stop CRS on all nodes

crsctl stop crs

Restore the OCR backup (physical) with the ocrconfig command.

ocrconfig -import /tmp/export_file.fil

Restart CRS

crsctl start crs

Check the integrity of the newly restored OCR:

cluvfy comp ocr -n all
Categories: Oracle Rac

SCAN Setup for Oracle 11g Release2(11gR2) RAC implementation

July 31, 2012 Leave a comment

Useful document about SCAN and how to modify scan name and port

SCAN Setup for Oracle 11g Release2(11gR2) RAC implementation.

 

Categories: Oracle Rac