• Home
  • About
  • Contact

Database In Action

~ Integrated Approach to Data

Database In Action

Category Archives: Data Guard

Dataguard Delay / Apply and Transport Lag

November 22, 2013

i.e. SQL> set linesize 2000 select sysdate,sum(apply_finish) apply_finish, sum(apply_lag) apply_lag, sum(transport_lag) transport_lag, sum(startup_time) startup_time, min(TIME_COMPUTED) TIME_COMPUTED from ( select decode(name,’apply …

Continue reading →

Rate this:

MRP0: Detected orphaned datafiles!

September 27, 2013

Datafile 1 (ckpscn 139334570249) is orphaned on incarnation#=2 MRP0: Detected orphaned datafiles! Recovery will possibly be retried after flashback… Errors …

Continue reading →

Rate this:

File # added to control file as UNNAMED

September 24, 2013

Errors in file …/trace/RAPOR_pr00_2801804.trc: ORA-01119: error in creating database file ‘/data/datafile_1.dbf’ ORA-27054: NFS file system where the file is created …

Continue reading →

Rate this:

Physical Dataguard Configuration

January 21, 2013

Some fast and easy configuration scripts for Physical Dataguard installation… PRIMARY Site ALTER SYSTEM SET db_unique_name = DATABASE; ALTER SYSTEM …

Continue reading →

Rate this:

Oracle 9.2.0.8 – 9i Release2 Dataguard Configuration Basics

July 19, 2012

cold copy or begin backup & end backup ->> All .log .dbf Create standby control file ALTER DATABASE CREATE STANDBY …

Continue reading →

Rate this:

Dataguard Mind Map

June 11, 2012

Rate this:

Oracle Data Guard – Physical Standby Switchover

May 31, 2012

root@primary:/>ps -ef |grep pmon user 372972 1 0 May 20 – 3:01 ora_pmon_sid root@primary:/>su – user user@primary:/swift/user>sqlplus / as sysdba …

Continue reading →

Rate this:

Activate Physical Standby Database for Read/Write Testing and Flashback to Restore Point

May 8, 2012

@Standby ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=25G; ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’/dir/oracle/flashback’; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; CREATE RESTORE POINT db_standby_test …

Continue reading →

Rate this:

Database Mirroring and Log Shipping vs Oracle Dataguard

April 10, 2012

Check out the similarities and differences of DRC logic between the two DB vendors – MSFT & ORCL to understand …

Continue reading →

Rate this:

Real Time Query -11g Active Data Guard

March 16, 2012

SQL> select open_mode from v$database; OPEN_MODE MOUNTED SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. …

Continue reading →

Rate this:

Blog Stats

  • 86,147 hits

Enter your email address to follow this blog and receive notifications of new posts by email.

Blogroll

  • AIX Blog
  • Alejandro Vargas
  • Gavin Soorma
  • Mark Rittman
  • Richard Foote
  • Tom Kyte

Recent Posts

  • Weblogic ServerRuntime Monitoring with Shell Script March 9, 2017
  • Creating SQL Plan Baseline (SPB) / Migrating Execution Plan February 15, 2017
  • Handling an Assertion Failure Sybase IQ February 1, 2016
  • Generate / Recreate DDL for all public and private database links with passwords July 24, 2014
  • Insert a word file to BLOB Column – BLOB insert PLSQL June 30, 2014
  • Insert a word file to BLOB Column – BLOB insert PLSQL June 3, 2014
  • Optimizer Null-Aware Anti Join – ORA-07445: exception encountered: core dump [rwsstd()+40] May 22, 2014

Category Cloud

Apex ASM Database Mirroring and Log Shipping (SQL Server) vs Oracle Dataguard Database Vault Data Guard Datapump Digital Economy EXP/IMP Fusion Grid Control Hadoop Hardware IBM Tivoli TSM Index Internet Inventory Listener Long Datatype Mirroring Monitoring MSSQLServer Oracle Database Partitioning Performance PLSQL Real Application Testing & SQL Performance Analyzer Software Solaris Sql Storage Switchover || Failover Sybase IQ Unix Upgrade Weblogic

Archives

Create a free website or blog at WordPress.com.

Cancel

 
Loading Comments...
Comment
    ×
    Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
    To find out more, including how to control cookies, see here: Cookie Policy