Enhancing Your Oracle Capability

ORACLE_DATAGUARD_Recover standby database manually Check the standby status: SQL>select open_mode from v$database; SQL>select sequence#,applied from v$archived_log order by sequence#; SQL>SELECT T

ORACLE_DATAGUARD_Recovering the Primary's Datafile On the standby database: 1、Backup the standby’s datafile $ rman target / RMAN> backupas copy datafile 5 format '/dg10g/backup/df05.cpy'; 2、Copy

ORACLE_DATAGUARD_Data Guard Protection Modes TRANSPORT: Data Guard Protection Modes MAXIMUM PROTECTION  Thisprotection mode guarantees that no data loss will occur if theprimary database fails. To

01、 ORACLE_DATAGUARD_Case_11gconfiguration Just acase: First of all, please finish the  full backup of the primary database. -- 1. Filename: Config the  oracle11g primary database 1). On

ORACLE_DATAGUARD_Step byStep Guide on Creating Physical Standby Using RMAN DUPLICATE(Just rebuild the standby database.) --- Filename: Rebuild the standby database using rman duplicate Rebui

ORACLE_DATAGUARD_Recovering the Standby's Datafile Recovering the Standby's Datafile If recovering the standby, reverse the steps. Tha tis: 1) copy the primary database's datafile 2) ftp the file

ORACLE_DATAGUARD_Rebuild standby database using dd command Rebuildstandby database using ddcommand: -- Create the standby database: -- 1. rcp the orapw to the standby $ rcp $ORACLE_HOME/db

ORACLE_DATAGUARD_UNNAMEDnnnnnfile in standby site UNNAMEDnnnnn file in standby siteafter new file added to primary database [ID 1329399.1] Applies to: OracleServer - Enterprise Edition - Version: