QUERY DATAGUARD AND STANDBY STATUS


Standby database process status: You can run following query on standby database to see what MRP and RFS processes are doing, which block of which archivelog sequences are being shipped or being applied.

SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby ;

PROCESS   STATUS          THREAD#  SEQUENCE#     BLOCK#     BLOCKS

——— ———— ———- ———- ———- ———-

ARCH      CLOSING               1      69479     932864        261

ARCH      CLOSING               1      69480     928768        670

ARCH      CLOSING               2      75336     933888        654

ARCH      CLOSING               2      78079     930816        842

ARCH      CLOSING               1      69475     943104         79

RFS       IDLE                  0          0          0          0

Continue reading

Advertisements

How to restore the RMAN standby backup to a new server


Assuming that you have already use RMAN to backup your standby database into flashback recovery area (db_recovery_file_dest).

So, if your db_recovery_file_dest=’/recovery_area’, then your backup will be at the following location by default. On the new server create the recovery area and restore the backup.

Default:
/recovery_area/<SID>/backupset
/recovery_area/<SID>/autobackup

On the empty server, we assume you have already cloned the Oracle binaries and set your global variables such as ORACLE_HOME, ORACLE_SID, etc.

Run the RMAN tool and login as sys. Then set your DBID to restore spfile and controlfiles. If you don’t know where your controlfiles are located first restore spfile then create pfile and check the location and then build it if they are not exist.

# rman target /
RMAN> SET DBID xxxxxxxxxxxx;
RMAN> STARTUP FORCE NOMOUNT;
RMAN> show all; — to display default rman configurations.

Continue reading

ORACLE DATAGUARD 10g WITH ASM CONFIGURATION


Oracle Dataguard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Data Guard maintains these standby databases as transactionally consistent copies of the production database. Then, if the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage. Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.

this is step by step to configure ODG on ASM configuration (copy this artikel to notepad or editor to easy read ):

Prereq :

– 2 virtual machine(DBSERVER and DBSERVERDRC) with OEL 5.5 and Oracle database 10gR2 (ASM Storage : +DATA and +FRA).

+DATA for database file and +FRA for recovery area.

– Database with SID : “blackowl” are configured on DBSERVER and at DBSERVERDRC just software oracle only

Continue reading

DataGuard 11g: Step-by-Step Instructions for Creating a Physical Standby Database (indonesia vers.)


Oracle Data Guard : Pengertian (1)

Salah satu solusi untuk disaster recovery pada database oracle adalah Oracle Data Guard,
selain tentunya Oracle RAC dan Oracle Stream.
Oracle Data Guard bekerja dengan cara :
a. ada 2 server primary (A) & standby (B)
b. jika server primary (A) error, standby (B) menjadi primary
membutuhkan waktu beberapa saat / detik untuk mengaktifkan
standby menjadi primary
c. setelah diperbaiki (A) dapat menjadi primary lagi

Continue reading

DataGuard 10g: Step-by-Step Instructions for Creating a Physical Standby Database


Step-by-Step Instructions for Creating a Physical Standby Database using SQL commands
1. General Overview :
The purpose of this document is to create a step by step guideline for using the Oracle Dataguard a High available mechanism. I spent about 7 days investigating about a problem faced from my first dataguard experience. Both primary and standby servers are on linux redhat : same version of OS.

– Primary DB : 10.2.0.1
– Standby DB : 10.2.0.3

– Host Name of Primary DB : arcdb01.es.egwn.lan
– Host Name of Standby DB : x06.d15.lan

I m trying to setup oracle dataguard for 10G ; both primary and standby databases are in 10GR2.
Configuring Oracle DataGuard using SQL commands – Creating a physical standby database ; I can’t get the log files or Archive logs on my StandBy db.
Checking v$archive_dest_status view on PRIMARY DB, I found the error below :

Continue reading