Category: rman-dataguard

http://www.dbazine.com/oracle/or-articles/liu4

http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_FastStartFailoverBestPractices.pdf

LGWR SYNC AFFIRM in Oracle Data Guard is used for zero data loss. How does one ensure zero data loss? Well, the redo block generated at the primary has to reach the standby across the network (that’s where the SYNC part comes in – i.e. it is a synchronous network call), and then the block…

Read More “Difference between SYNC and AFFIRM” »

http://www.oracle.com/technology/obe/11gr2_db_prod/ha/dataguard/dg_broker/dg_broker.htm http://www.oracle.com/technology/obe/11gr2_db_prod/ha/dataguard/activedg/activedg.htm http://www.oracle.com/technology/obe/11gr2_db_prod/ha/dataguard/physstby/physstdby.htm

ALTER DATABASE commit TO switchover TO physical PRIMARY WITH session shutdown nowait;

In order to perform a switchover all sessions to the database need to be disconnected. In version 901 this was a manual process. In version 9.2.0 this process has been automated with the “with session shutdown” clause that has been added to the alter database commit to switchover command. If SWITCHOVER_STATUS returns SESSIONS ACTIVE then…

Read More “Physical Standby switchover with session active” »

Subject: RMAN : Consistent Backup, Restore and Recovery using RMAN Doc ID: 162855.1 Oracle9i Lab 1 Consistent Backup, Restore and Recovery using RMAN In Oracle9i, Recovery Manager still works the same as in 8 and 8i with enhancements for ease of use and manageability. Using the updateable persistent configuration options, backing up the database is…

Read More “RMAN : Consistent Backup, Restore and Recovery using RMAN” »

Backup and Recovery Scenarios Doc ID: 94114.1 In this Document Purpose Last Review Date Instructions for the Reader Troubleshooting Details BACKUP SCENARIOS a) Consistent backups b) Inconsistent backups c) Database Archive mode d) Backup Methods e) Incremental backups f) Support scenarios RECOVERY SCENARIOS 1. Online Block Recovery. 2. Thread Recovery. 3. Media Recovery. Media Failure…

Read More “Backup and Recovery Scenarios” »

Subject: Benefits and Usage of RMAN with Standby Databases Doc ID: 602299.1 Applies to: Oracle Server – Enterprise Edition – Version: 9.0.1.4 to 11.1.0.6 Information in this document applies to any platform. Goal Benefits and Usage of RMAN with Standby Databases . Solution RMAN can back up the standby database and its associated archived redo…

Read More “Benefits and Usage of RMAN with Standby Databases” »

col name format a50 col UNRECOVERABLE_CHANGE# format 999999999999999999999 col dt1 format a30 set lines 120 pages 200 SELECT NAME, UNRECOVERABLE_CHANGE#, TO_CHAR (UNRECOVERABLE_TIME,’DD-MON-YYYY HH:MI:SS’) dt1 FROM V$DATAFILE WHERE UNRECOVERABLE_CHANGE# != 0;