Posted inOracle

Multi-tenant Architecture

Oracle Database 12c introduced a new feature called “Multitenant.” The multitenant feature provides the ability for a single instance to manage multiple databases. The multitenant architecture enables an Oracle database…
No Comments
Posted inOracle

Azure : Create Gateway Subnet

STEP-1- Create Gateway Subnet Resource Group > VNET>SUBNETS> GATEWAY SUBNETS>ADD – 10.0.1.0/24 (Available Free Subnet). STEP-2 Create Gateway Create. SEARCH > VIRTUAL NETWORK GATEWAY> SELECT VIRTUAL NETWORK GATEWAY >VPN> >ROUTE…
No Comments
Posted inOracle

Create Duplicate Database Using RMAN

Source Database Name is PRODDB Target (duplicate) Database name is MYDB  Source  Host Name     : server1.localdomain Target Host Name       : server2.localdomain Put Database in archivelog mode. SQL> archive log list; Database…
No Comments
Posted inASM Oracle

Migrate Non-ASM to ASM instance in 12c

Check the status of ASM instance . SQL> SELECT INSTANCE_NAME,VERSION,STATUS FROM V$INSTANCE; INSTANCE_NAME VERSION STATUS ------------- -------- ---------------- +ASM 12.1.0.2.0 STARTED Check the database version and its status. SQL> SELECT NAME,OPEN_MODE…
No Comments
Posted inDataGuard Oracle

Monitor Standby Database with Lag Time Report

vi /home/oracle/scripts/lag_time_report_and_diskgroup_space.ksh #!/bin/ksh export ORACLE_SID=<Target_ORACLE_SID> export ORACLE_HOME=/u01/oracle/product/11.2.0.4/db /u01/oracle/product/11.2.0.4/db/bin/sqlplus -s / as sysdba << NACHO > /tmp/standbylag.log set feedback off select 'Standby thread '|| thread# || ' is '|| round((sysdate -…
No Comments