Using RMAN Incremental Backups to Roll Forward a Physical Standby Database

We can use rman incremental backup to roll forward physical standby database. Nevertheless, there is one particular step which we might pay attention to. In general, physical standby database would have different datafile paths. Things could be even more complex when you are using OMF. The doc only states that we can manually edit the file… Continue reading Using RMAN Incremental Backups to Roll Forward a Physical Standby Database

Activating physical standby (cont)

There are two ways to activate a physical standby database: failover (activate it to become a primary) and snapshot standby. We’ll see later that snapshot standby also leverages guaranteed restore point therefore essentially the two methods are the same. In addition, switchover will not change the current database incarnation while failover and snapshot standby do.… Continue reading Activating physical standby (cont)

Activate physical standby database and flashback

— standby SQL> alter database recover managed standby database cancel; SQL> create restore point standby_flashback_testing guarantee flashback database; SQL> alter session set nls_date_format=’yyyy-mm-dd hh24:mi:ss’; SQL> col name for a30 SQL> select name, scn, time from v$restore_point; NAME SCN TIME —————————— ———- ————————————————————————— STANDBY_FLASHBACK_TESTING 241386 04-MAY-16 09.40.06.000000000 PM — primary SQL> alter system archive log current;… Continue reading Activate physical standby database and flashback

Configuring Data Guard in 11g using Duplicate

Oracle 11.2.0.4.8 Solaris SPARC 10u11 Primary: 200.31.108.103 ORACLE_SID: LCM2DBS1 RAC, ASM Standby: 200.31.108.21 ORACLE_SID: LCM2DBS single instance, non-ASM Logging Check that the primary database is in archivelog mode. SELECT force_logging, log_mode FROM v$database; FOR LOG_MODE — ———— YES ARCHIVELOG If it is noarchivelog mode, switch to archivelog mode. SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG;… Continue reading Configuring Data Guard in 11g using Duplicate

Steps to recreate standby log files in Data Guard

If the real-time apply feature is enabled, log apply services can apply redo data as it is received, without waiting for the current standby redo log file to be archived. This results in faster switchover and failover times because the standby redo log files have been applied already to the standby database by the time… Continue reading Steps to recreate standby log files in Data Guard