Oracle Data Guard Client Connectivity TNS Entries

Sdílet
Vložit
  • čas přidán 24. 07. 2024
  • The Oracle Database Administrator (#DBA) faces the challenge of switching #clients to the newly activated #standby #database which is now running as the new primary database.
    The Data Guard is best management monitoring tool provided by #ORACLE to reduce the #failover time when Primary system goes down. Data Guard helps in transferring the redo data files to the Standby site. Data Guard maintains Standby databases as transactional consistent copies of production database. When the Primary system fails due to some error the Data Guard can switch to any Standby database.
    00:00 Client Connectivity
    03:59 Client Configuration
    06:32 Practical LAB
    06:46 Create a database services on primary
    19:07 Create a procedure for services
    23:50 Create Triggers
    26:46 Start the new service
    27:34 Edit clients tnsnames.ora
    29:44 Download/Install SQL client
    Website: www.dbagenesis.com/
    Facebook: / dbagenesis
    Instagram: / dbagenesis
    Twitter: / dbagenesis
  • Věda a technologie

Komentáře • 3

  • @rehantayyab82
    @rehantayyab82 Před 3 lety

    on production and standby what entries u did in tnsnames.ora ..... plz can u show that ?

  • @SonNguyen-eg6mj
    @SonNguyen-eg6mj Před 2 lety

    How to start for service_name inside pdb?

  • @vidmayur
    @vidmayur Před 4 lety +2

    Oracle Doc ID 1429223.1 has answer to this .I think you have used the method from there only