Overview Data Guard Configuration - A primary and 2 Standby Databases





I showed with this video, how to create oracle standby database on same host primary database and remote host. I created two physical standby database and created oracle data guard configuration with primary and this two standby databases.

I think this video very helpful creator standby database and for newly of Oracle Data Guard creator.

Watch on youtube : http://www.youtube.com/watch?feature=player_embedded&v=5keahpkzLtM

Location: Baku, Azerbaijan

Comments

  1. Daud AkmalMarch 26, 2013 at 8:39 PM

    Great work Mahir, I ready enjoyed your tutorial. Although doing the same in Linux got me into error:

    Starting backup at 21-MAR-13
    using channel ORA_DISK_1
    channel ORA_DISK_1: starting datafile copy
    input datafile file number=00002 name=/home/oracle/app/oracle/oradata/orcl/sysaux01.dbf
    RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/21/2013 09:20:53
    ORA-17627: ORA-12577: Message 12577 not found; product=RDBMS; facility=ORA

    any help is welcome: akmald@gmail.com

    ReplyDelete
  2. JayApril 3, 2013 at 4:26 PM

    Gre8 work...Mahir...

    could you please let us know, after completion of Data Guard...if we add tablespace and users in PRMDB.....will it transfer to STRDB?

    ReplyDelete
    Replies
    1. Mahir M. QuluzadeApril 3, 2013 at 4:29 PM

      You are welcome Jay!

      Yes, when you create tablespace and user, this shall create at physical standby database same time.
      If your STANDBY_FILE_MANAGEMENT parameter AUTO on standby database, then datafile created same name, too.

      Thanks for visit my blog.
      Mahir M. Quluzade

      Delete
  3. sandeep saxenaMay 8, 2019 at 2:21 PM

    Thanks a lot for a good blog. In this blog, I gain more knowledge about technology.
    Struts Training in Chennai
    Struts Training institutes in Chennai
    struts Training in T Nagar
    struts Training in OMR
    Wordpress Training in Chennai
    Wordpress Training
    Spring Training in Chennai
    Hibernate Training in Chennai

    ReplyDelete
  4. UnknownAugust 23, 2019 at 8:34 AM

    can you please provide configuration documents.

    ReplyDelete
  5. Manisha SudhaAugust 24, 2019 at 1:19 PM

    Great blog....waiting for next update...thanks fro sharing...
    Struts Training in Chennai
    struts classes
    Struts Training institutes in Chennai
    struts training in Thiruvanmiyur
    struts Training in T Nagar
    Wordpress Training in Chennai
    SAS Training in Chennai
    Spring Training in Chennai
    Photoshop Classes in Chennai
    DOT NET Training in Chennai

    ReplyDelete
  6. PrakashAugust 27, 2019 at 1:05 PM

    More impressive blog!!! Thanks for shared with us.... waiting for you upcoming data.
    Software Testing Training in Chennai
    software testing course in chennai
    testing courses in chennai
    best software testing training institute in chennai with placement
    Software testing training in Annanagar
    Software testing training in vadapalani
    Android training in Chennai
    Python Training in Chennai
    Big data training in chennai
    JAVA Training in Chennai

    ReplyDelete
  7. chintuAugust 27, 2019 at 3:56 PM

    valuable blog,Informative content...thanks for sharing, Waiting for the next update...
    C C++ Training in Chennai
    C Language Training in Chennai
    c c++ course fees in chennai
    C C++ training in guindy
    C C++ training in thiruvanmiyur
    javascript training in chennai
    core java training in chennai
    Html5 Training in Chennai
    DOT NET Training in Chennai
    QTP Training in Chennai

    ReplyDelete
  8. The IndiaSeptember 30, 2019 at 9:44 AM

    khadi sarees online
    khadi kurta online
    khadi kurta for ladies
    kurtas for salee
    khadi clothes for yoga
    khadi silk saree
    khadi silk sarees
    handloom khadi sarees

    ReplyDelete

Post a Comment

Popular posts from this blog

Which device is mapped Oracle ASM disk?

Hi,

Yesterday Yuva Kishore is commented on my Oracleasm - Instantiating disk : failed post and asked a question: We can list the asm disks (listdisks) but where can we find the mapping that ASMDISK1 is mapped to /dev/sda1 and so on? 

I want answer this question with this post.

If you  are using ASMLib for configure ASM Disks, then you can use following steps for define which device mapped which ASM Disk.

As you  know, oracleasm listdisks is return only ASM disk names

[grid@oel62-rac1 ~]$ oracleasm listdisks ASMDISK01 ASMDISK02 ASMDISK03 ASMDISK04 ASMDISK05 [grid@oel62-rac1 ~]$
If you want find which ASM disk is mapped which device, then you must use oracleasm querydisk with ASM disk name.

[grid@oel62-rac1 ~]$ oracleasm querydisk -d ASMDISK01 Disk "ASMDISK01"  Is a valid ASM disk On device[8,17]
As see you, ASMDISK01 is valid ASM disk on device [8,17].

What is means?

It means ASMDISK01 is mapped to device [8,17].

How to find [8,17] device?

 We must use Linux ls –l  c…
Read more

Oracle Data Guard 11g - How to safely remove a Data Guard Broker configuration?

Image
When you need safely remove broker-managed Data Guard Configuration then, oracle recommend following steps…

You know dg_broker_start parameter is TRUE and data guard configuration information contains in broker configuration files dg_broker_config_file1, dg_broker_config_file2 with broker-managed Data Guard Configuration.

Following steps I use on my test machines witch is running on Oracle Virtual Box. I captures video on this machines, too. Primary and Standby Database running on Oracle Linux Server 6.2 and installed Oracle Database 11g Release 2 (11.2.0.3).

DG – is my breoker-managed Data Guard configuration. admdb is primary database, stldb – is standby database.

DGMGRL> show configuration Configuration - dg Protection Mode: MaxPerformance Databases: admdb - Primary database stldb - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS
Archive log destinations like as

SQL> show parameter log_archive_dest_ NAME …
Read more

Oracle Database 12c Release 2 - Long Identifiers

Image
Prior to Oracle Database 12c Release 2 have a problem with long identifier name, for example, in 11.2 version you cannot create long name (max 30 Bytes) tables.  As you see, from screenshots length of table name column is maximum 30.



In Oracle Database 12c Release 2 changed the length of identifier names, and this change depends on the COMPATIBLE initialization parameter. Documentation says:

If COMPATIBLE is set to a value of 12.2 or higher, then names must be from 1 to 128 bytes long with these exceptions: Names of databases are limited to 8 bytes. Names of disk groups, pluggable databases (PDBs), rollback segments, tablespaces, and tablespace sets are limited to 30 bytes. If an identifier includes multiple parts separated by periods, then each attribute can be up to 128 bytes long. Each period separator, as well as any surrounding double quotation marks, counts as one byte. For example, suppose you identify a column like this: "schema"."table"."column" …
Read more