Standby : Dataguard

Standby Commands

Step By Step to Create Phyiscal Standby Dastabase 10g

9i Failover and switcover

recreate standby controlfile

Active Database Duplication in Oracle 11g with Example

Creating a Physical Standby Database with RMAN duplicate(without backup )

Duplicate database

Use standby for read/write and then revert back using flashback

Use standby for read/write and then revert back using flashback

Rollforward standby using rman Incremental backup

Switchover to Standby

Dataguard broker configuration

Data guard broker commands

Dataguard Map

Check Script to Collect Data Guard Primary Site Diagnostic  (@dg_prim_diag)

Check Script to Collect Data Guard Physical Standby Diagnostic (@DG_phy_stby_diag.sql)  

Restoring a Physical Standby Database

Fast-Start Failover

Snapshot Standby


Duplicate Details:



contents of Memory Script:
{
   set until scn  13169104914343;
   set newname for datafile  1 to "/oravl02/oradata/dbtest/system01.dbf";
   set newname for datafile  2 to "/oravl02/oradata/dbtest/sysaux01.dbf";
   set newname for datafile  3 to "/oravl02/oradata/dbtest/undotbs01.dbf";
   set newname for datafile  4 to "/oravl02/oradata/dbtest/users01.dbf";
   restore
   clone database -- Before clone , it does create C.F ,switch clone , recover and then clone database
   ;
}


...executing command: SET NEWNAME

...restoring datafile 00001 to /oravl02/oradata/dbtest/system01.dbf


CREATE CONTROLFILE REUSE SET DATABASE "DBTEST" RESETLOGS ARCHIVELOG
DATAFILE
  '/oravl02/oradata/dbtest/system01.dbf'


contents of Memory Script:
{
   switch clone datafile all;
}


contents of Memory Script:
{
   set until time  "to_date('2015-01-06 00:00:00','yyyy-mm-dd hh24:mi:ss')";
   recover
   clone database
    delete archivelog
   ;
}





RMAN> RUN
2> {
3>    shutdown clone immediate;
4>    startup clone nomount ;
5> }


CREATE CONTROLFILE REUSE SET DATABASE "DBTEST" RESETLOGS ARCHIVELOG
DATAFILE
  '/oravl02/oradata/dbtest/system01.dbf'



run
2> {
3>    set newname for tempfile  1 to "/oravl02/oradata/dbtest/temp01.dbf";
4>    switch clone tempfile all;
5>    set newname for datafile 1 to "/oravl02/oradata/dbtest/system01.dbf";
6>    set newname for datafile 2 to "/oravl02/oradata/dbtest/sysaux01.dbf";
11>    catalog clone datafilecopy "/oravl02/oradata/dbtest/sysaux01.dbf";
16>    switch clone datafile all;
17> }



RMAN> run
2> {
3>    Alter clone database open resetlogs;
4> }