Friday , June 23 2017

Last Articles

Introduction to Oracle Database

Introduction to Oracle Database About Relational Databases Every organization has information that it must store and manage to meet its requirements. This information must be available to those who need it. Most companies today use a database to automate their information systems. A database is an organized collection of information …

Read More »

Data guard Related View

Data guard Related View V$DATABASE PROTECTION_LEVEL: current protection mode setting. FS _FAIL OVER_STATUS: synchronization status DBA _LOG STD BY_UNSUPPORTED: unsupported tables. DBA _LOGS TD BY_EVENTS: monitor transaction activity. V$LOG: Redo log changed. V$MANAGED_STANDBY : Recovery progress. View More: Data Guard Benefits Oracle 10G New Features Of Data Gaurd Brief Description …

Read More »

ORACLE Fail over – Standby Becomes Primary

ORACLE Fail over – Standby Becomes Primary # Failover – Standby Becomes Primary End all activities on the standby database. May need to resolve redo log gaps (not shown here). On the standby: SQL> alter database recover managed standby database finish; SQL> alter database commit to switch over to primary; …

Read More »

Add Standby Redo Log Groups to Primary Database

# Add Standby Redo Log Groups to Primary Database Create standby log file groups on the primary database for switch overs (start with next group number; create one more group than current number of groups): $ sql plus “/ as sys dba” SQL> select max(group#) max group from v$ log …

Read More »

Additional commands for Dataguard

Additional commands for Data guard # Add Standby Redo Log Groups to Standby Database Create standby redo log groups on standby database (start with next group number; create one more group than current number of groups) after switching out of managed recovery mode: SQL> sql plus “/ as sysdba” SQL> …

Read More »

Data Guard Benefits

Data Guard Benefits Disaster recovery and high availability Data Guard provides an efficient and comprehensive disaster recovery and high availability solution. Automatic fail over and easy-to-manage switch over capabilities allow quick role reversals between primary and standby databases, minimizing the downtime of the primary database for planned and unplanned outages. …

Read More »

Oracle 10G New Features Of Data Gaurd

What’s New in Oracle Data Guard 10g Release 2? Fast-Start Failover This capability allows Data Guard to automatically, and quickly fail over to a previously chosen, synchronized standby database in the event of loss of the primary database, without requiring any manual steps to invoke the failover, and without incurring …

Read More »

Brief Description of Oracle DATAGUARD

OVERVIEW DATAGUARD Oracle Data Guard is one of the most effective and comprehensive data availability, data protection and disaster recovery solutions available today for enterprise data.Oracle Data Guard is the management, monitoring, and automation software infrastructure that creates, maintains, and monitors one or more standby databases to protect enterprise data …

Read More »

Oracle FLASHBACK DATABASE

FLASHBACK DATABASE Database must be in archivelog mode and flashback should be enabled for performing this. When placed in flashback mode, we can observe flashback logs getting generated in flash_recovery_area — Create a dummy table. CONN scott/tiger CREATE TABLE flashback_database_test (id  NUMBER(10) ); — Flashback 5 minutes. CONN sys/password AS SYSDBA …

Read More »

FLASHBACK TRANSACTION QUERY

FLASHBACK TRANSACTION QUERY—————————————————- SELECT xid, operation, start_scn,commit_scn, logon_user, undo_sql FROM   flashback_transaction_query WHERE  xid = HEXTORAW(‘0600030021000000’); update “SCOTT”.”FLASHBACK_VERSION_QUERY_TEST” set “DESCRIPTION” = ‘ONE’ where ROWID = ‘AAAMP9AAEAAAA AYAAA’; FLASHBACK TABLE—————————– Flashback table requires following privileges1) FLASHBACK ANY TABLE or FLASHBACK object2) SELECT,INSERT,DELETE and ALTER privs on table3) Row movement must be enabled CREATE TABLE …

Read More »