To remove a node from a which is part of a RAC involves several steps Stop the database and ASM on particular instance Remove the database and ASM Remove the Oracle Database Software Remove the Clustware Update the oracle inventory Current Scenario [oracle@rac1 ~]$ olsnodes -s -t rac1 Active Unpinned rac2 Active Unpinned rac3 Active […]
Monthly Archives: August 2017
Adding a Database home to a 12c RAC Cluster
In previous article we added the grid home in third home (i.e rac3): Click Here Now we are going to extend the database home in 3rd home. From an existing node i.e rac1 – as the database software owner – run the following command to extend the Oracle database software to the new node “rac3” […]
Adding a Grid node to a 12c RAC Cluster
The generic steps to follow when adding the new node to the cluster are: Install Operating System Install required software Add/modify users and groups required for the installation Configure network Configure kernel parameters Configure services required such as NTP Configure storage (multipathing, zoning, storage discovery, ASMLib?) We assume that our OS,storage and network is already […]
Patching Oracle GoldenGate 12c
For the latest patchset you’ll need access to MOS. At the time of writing the latest patchset is 12.1.2.1.12 and can be downloaded from here: Oracle GoldenGate 12.1.2.1.12 Patch Set Availability (Doc ID 1645495.1). we need to make sure that no processes are running out of the home that will be patched: [oracle@host01 ~]$ /u01/app/oracle/product/12.1.0/gg_12121/ggsci […]
Oracle GoldenGate 12c: Silent Install
As we know installation of Oracle Goldengate is very easy with GUI mode. In this article we will look at Oracle GoldenGate 12c silent install. Preparing the Response File we can create our response file and save it with ggs.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2 INSTALL_OPTION=ORA12c SOFTWARE_LOCATION=/u01/app/oracle/ggs START_MANAGER=true MANAGER_PORT=7809 DATABASE_LOCATION=/u01/app/oracle/product/12.1.0/dbhome_1 INVENTORY_LOCATION=/u01/app/oraInventory UNIX_GROUP_NAME=oinstall Installing GoldenGate After creating the response the […]
Installing Oracle GoldenGate for Oracle 12c
Oracle GoldenGate features can be demonstrated using a single computer and a single database instance. In this case, Oracle GoldenGate replication occurs between two different database schemas running on the same database instance. To make this arrangement possible, the Oracle GoldenGate software must be installed twice on the same computer/VM, in different directories, one dedicated […]
ACCIDENTALLY data file is added without “+” sign
In RAC or ASM environment, we missed the ‘+’ sign while adding datafile in tablespace. we got error in ora-01110, ora-27037 in alert log. ORA-01157: cannot identify/lock data file 3129 – see DBWR trace file ORA-01110: data file 3129: ‘/home/oracle/product/10.2.0/db/dbs/DATA’ ORA-27037: unable to obtain file status ORA-01186: file 3129 failed verification tests ORA-01157: cannot identify/lock […]
RMAN BACKUP Scripts
~~~~~~~~~~~~~~~~~~~~~~~~ # RMAN backup history ~~~~~~~~~~~~~~~~~~~~~~~~ set lines 150 set pages 900 col start for a20 col end for a20 col status format a11 col input_bytes_display format a10 col output_bytes_display format a10 col status_weight format 99999 SELECT to_char(start_time,’YYYY.MM.DD HH24:MI:SS’) “Start” , to_char(end_time,’YYYY.MM.DD HH24:MI:SS’) “End”, status, status_weight, input_type, input_bytes_display, output_bytes_display FROM V$RMAN_BACKUP_JOB_DETAILS WHERE ( start_time between […]
COMPRESSED INCREMENTAL BACKUP
We need compressed full and incremental backup to apply in standby site and for make restoration faster INCREMENTAL LEVEL 0 BACKUP RUN { BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG; DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DISK; } INCREMENTAL LEVEL 1 BACKUP RUN { BACKUP AS COMPRESSED BACKUPSET INCREMENTAL […]
RECOVER ORACLE DATAFILES WITH NO DOWNTIME
What will happen if dbf file accidentally deleted when the database is still open and how to recover it? On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed. But the process can continue to use […]