Roll Forward Physical Standby Database using RMAN incremental backup

There would be scenarios where the standby database lags far behind from the primary database leading to Archive Gap. It could be due to one of the following reasons 1.  Might be due to the network outage between the primary and the standby database leading to the archive gaps. Data guard would be able to detect […]

Read More

Physical Backup

What is physical Backup? The operating system saves the database files onto tape or some other media. This is useful to restire the system to an earlier point whenever needed. In its simplest form, a physical backup is the movement of all data from one raw device to another; in the context of file system […]

Read More

Logical Backup

What is a logical backup? Logical backups are backups in which the export utility (for example Exp) uses SQL to read database data and then export it into a binary file at the operating system level. You can then import the data back into a database using the import utility (Imp).The Oracle Export Utility can […]

Read More

Backup

In the 24/7 working environment, any organization requires database available all time. In business world, there are three type of users (Top Management(C.E.O, Board of Directors etc), Technical user(DBA, Developers etc.)/Non -Technical user(Hr , C.A, Market department etc.), End Users(Customers) )who interact with database any  organization according to their roles and privileges. N number of activity done by them […]

Read More

Scenario 1 – Recover a Member of a Multiplexed Online Redo Log Group

Please follow the below steps. Steps : 1. Shutdown immediate; 2. Physically remove redo log member(no redo log group) by using OS level command. 3. Startup; 4. SELECT GROUP#, STATUS, MEMBER FROM v$LOGFILE WHERE STATUS=’INVALID’; 5. Check alert log file. Steps for Recovery : 1. Drop the damaged member ALTER DATABASE DROP LOGFILE MEMBER ‘D:\app\admin\oradata\orcl\REDO01.LOG’; […]

Read More

Catalog Database Configure

Description:    RDB1 as TARGET SERVER                         RDB2 as CATALOG SERVER  create a database using DBCA on catalog server as catalog database i.e. RDB create a service in target server for the catalog server connection. check service alias using TNSPING servicename(EX:TNSPING RDB2) in terminal […]

Read More