Posts

Duplicate database using RMAN duplicate oracle 12c

Target database : primdb Duplicate database: dupdb   Step-1: Configure password file for duplicate database export ORACLE_SID=dupdb export ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1 cd $ORACLE_HOME/dbs orapwd file=orapwdupdb password = xxxxx Note: Make sure password should be same a primdb (target database) Step-2: Configure listener and TNS file for duplicate database PRIMDB =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle12c.localdomain)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = primdb)     )   ) DUPDB =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = oracle12c.localdomain)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME = dupdb)     )   ) Step-3: Create pfile for duplicate database [oracle@oracle12c dbs]$ cat initdupdb.ora d...
Post a Comment
Read more

Configure Dataguard Broker in oracle 12c

There are 5 steps to configure the DG broker: Configure Listener file on both Primary and Standby database, Add the below lines in the listener file. Reload the listener on both primary and standby Enable dg broker related parameters on both primary and standby database Configure DGMGRL Enable the configuration Step-1: Configure Listener file on both Primary and Standby database, Add the below lines in the listener file. SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (GLOBAL_DBNAME = primdb)       (ORACLE_HOME= /u01/app/oracle/product/12.2.0/dbhome_1)           (SID_NAME = primdb)     ) (SID_DESC =       (GLOBAL_DBNAME = stndb)       (ORACLE_HOME= /u01/app/oracle/product/12.2.0/dbhome_1)           (SID_NAME = stndb)     ) (SID_DESC =       (GLOBAL_DBNAME = primdb_DGMGRL)       (ORACLE_HOME=...
Post a Comment
Read more

PostgreSQL Backup and Recovery

Post a Comment
Read more

SQL Server database backup

Image
  Types of backups in the SQL Server   a.      Common types of backups: ·         Full ·         Differential ·         Transaction log ·         Tail log backup b.      Other types of backups: ·         Copy-only backup ·         File backup ·         Partial backup .      Backup Administration   Full Backups It backs up everything. It is a base backup of any database backup. This is also called a complete database backup which includes all of the objects like tables, indexes, views, procedures, functions etc. How to create full database backup: Using T-SQL: BACKUP DATABASE [AdventureWorks2012] TO DISK = 'D:\SQL_backup\full\adventu...
Post a Comment
Read more