Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • export import with parameter file. Oracle
  • Updated LCK.SQL file. Oracle
  • Flowers Resize datafiles Oracle
  • move_arch_files.ksh Linux/Unix
  • sqlnet.ora paramters Oracle
  • AWR settings- MMON is not taking snapshot. Oracle
  • Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1 Oracle
  • chk_space_SID.ksh Linux/Unix
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • sesswait.sql Oracle
  • Oracle Standby Database Library Index from Metalink Oracle
  • Oracle Identifiers Oracle
  • How to analyze statspack or AWR report. Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • block_ident.sql Oracle

Category: rman-dataguard

Very clear article about oracle dataguard

Posted on 29-Jan-2010 By Admin No Comments on Very clear article about oracle dataguard

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

Oracle, rman-dataguard

oracle fast start failover best practice

Posted on 27-Jan-2010 By Admin No Comments on oracle fast start failover best practice

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

Oracle, rman-dataguard

Difference between SYNC and AFFIRM

Posted on 27-Jan-2010 By Admin No Comments on Difference between SYNC and AFFIRM

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” »

Oracle, rman-dataguard

useful dg links

Posted on 27-Jan-2010 By Admin No Comments on useful dg links

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

Oracle, rman-dataguard

switchover for primary database

Posted on 31-Dec-2009 By Admin No Comments on switchover for primary database

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

Oracle, rman-dataguard

Physical Standby switchover with session active

Posted on 30-Dec-2009 By Admin No Comments on Physical Standby switchover with session active

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” »

Oracle, rman-dataguard

RMAN : Consistent Backup, Restore and Recovery using RMAN

Posted on 09-Sep-2009 By Admin No Comments on RMAN : Consistent Backup, Restore and Recovery using RMAN

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” »

Oracle, rman-dataguard

Backup and Recovery Scenarios

Posted on 09-Sep-2009 By Admin No Comments on Backup and Recovery Scenarios

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” »

Oracle, rman-dataguard

Benefits and Usage of RMAN with Standby Databases

Posted on 09-Sep-2009 By Admin No Comments on Benefits and Usage of RMAN with Standby Databases

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” »

Oracle, rman-dataguard

Find Stale DR Physical Standby

Posted on 19-Jan-2009 By Admin No Comments on Find Stale DR Physical Standby

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;

Oracle, rman-dataguard

Posts pagination

1 2 3 Next

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • SAN Linux/Unix
  • How to sort list of files on basis of their sizes. Linux/Unix
  • note id 373303.1 Linux/Unix
  • TRUNCATE table and disabling referential constraints. Oracle
  • Formatter Explain plan Output 1 Oracle
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • runsql_once.ksh Linux/Unix
  • send attachment from unix-shell script Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme