Recently we refresh our Prodtest database from production using RMAN. now while starting the GG, i’m getting below error.
2016-05-27 19:31:12 ERROR OGG-01668 Oracle GoldenGate Manager for Oracle, mgr.prm: PROCESS ABENDING.
2016-05-27 19:49:26 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr.
2016-05-27 19:49:27 ERROR OGG-00664 Oracle GoldenGate Manager for Oracle, mgr.prm: OCI Error during OCIServerAttach (status = 12154-ORA-12154: TNS:could not resolve the connect identifier specified).
2016-05-27 19:49:27 ERROR OGG-01668 Oracle GoldenGate Manager for Oracle, mgr.prm: PROCESS ABENDING.
Basically one day at work, my colleague handed over an issue related to RMAN.
Starting backup at 14-FEB-2016 06:02:44
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1444 instance=CXXXEU22 device type=DISK channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/14/2016 06:02:46
ORA-00245: control file backup failed; target is likely on a local file system
A little bit busy this week … my boss ask me to validate the RMAN tape backup if we can really restore it.
Note : restore database validate is not an option 🙂
Source and target are both clustered database.
Source DB: CNCXXU
Source Server : ncxxdsmwu01/ncxxdsmwu02
Target DB: NCXX2PT
Target Server : ncxxdsgtu21/ncxxdsgtu22
1. Shutdown the target database and delete all files in ASM
2. Start the database in nomount and restore the spfile.
– spfile and controlfile backup is going to disk.
– no rman catalog
Mostly right now i’d been working on 2 node database cluster. so when doing a patching i need to stop all the database in both nodes.
someone is doing a testing on the server and created a new database but when stopping it won’t allow me.. and resulted me to stop it using sqlplus.
so i decided to add it to CRS.
[oracle@kxxxxsgtu21 ~]$ srvctl status database -d POCTEST1
PRCD-1120 : The resource for database POCTEST1 could not be found.
PRCR-1001 : Resource ora.poctest1.db does not exist
recently i restore a database from tape to a different host and at the same time i need to rename the database.
the dbid of my new database same from my source database. since we are using tape to backup our database i need to change the DB of our new database.
Note : DB is 2 node cluster.
Disable the cluster parameter and restart the database.
one of our production server (part of RAC) restarted but crs worn’t start.
checking the logs.
2011-11-09 18:46:44.016: [ COMMCRS]clsc_connect: (0x35cb500) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_dbz30cnc_))
2011-11-09 18:46:44.017: [ CSSCLNT]clsssInitNative: failed to connect to (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_dbz30cnc_)), rc 9
2011-11-09 18:46:44.017: [ CRSRTI] CSS is not ready. Received status 3 from CSS. Waiting for good status ..
2011-11-09 18:46:45.197: [ COMMCRS]clsc_connect: (0x35cb500) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_dbz30cnc_))
2011-11-09 18:46:45.197: [ CSSCLNT]clsssInitNative: failed to connect to (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_dbz30cnc_)), rc 9
2011-11-09 18:46:45.197: [ CRSRTI] CSS is not ready. Received status 3 from CSS. Waiting for good status ..
2011-11-09 18:46:46.198: [ CRSD][PANIC] CRSD exiting: Could not init the CSS context
2011-11-09 18:46:46.198: [ CRSD] Done.
yyy01.xxx.com$ ./crsctl check crs
Failure 1 contacting Cluster Synchronization Services daemon
Cannot communicate with Cluster Ready Services
Cannot communicate with Event Manager
1. first corrective action we’ve done. is delete the lockfile in /tmp or /var/tmp
yyy01.xxx.com$ cd /var/tmp
yyy01.xxx.com$ ls -al
drwxrwxrwt 3 root root 4096 Oct 16 07:27 .
drwxr-xr-x 20 root root 4096 Oct 21 2009 ..
-rw-rw-r-- 1 root root 25806 Oct 22 20:53 badlogs.log
-rw-r--r-- 1 root root 10045 May 28 2010 opc_inst.log
drwxrwxrwt 2 root root 4096 Nov 9 18:07 .oracle
-rw------- 1 root root 0 Nov 9 18:07 osspi_boot.msg
after deleting the file we rebooted the server again. but did not work.
i tried to checked ip’s of both nodes and found that both can’t communicate using the PRIV ip.
ask UNIX to check and do whatever they need to do.
when UNIX team is done, they rebooted the server and the database and all of its services started.