19c RAC Dataguard Build Document – Physical Standby Database Dataguard build from Active Database

Channel Avatar
2 Comments
X
Share
19c RAC Dataguard Build Document - Physical Standby Database Dataguard build from Active Database
19c RAC Dataguard Build Document – Physical Standby Database Dataguard build from Active Database
Hello Friends,

Here with one more topic on.

19c RAC Dataguard Build Document – Physical Standby Database Dataguard build from Active Database:

Contents
Check PRODDB database status 3
Check PRODDB database listener and tnsnames.ora 3
Check GI listener status on PROD servers 3
Check for ASM instance status on PROD Server 4
Check for All listener status on PROD servers 4
Check cluster resource and Listeners are registered with cluster on PROD server 5
Verify local listener and scan listener on all the DB instances 5
Verify TNSPING and the password from primary database on all nodes 5
Add the standby TNS details on PROD Servers 6
Create initPRODDB.ora in PROD DB servers 6
Copy local password file from ASM on PROD Servers 7
PRODDB prechks 8
Add Standby Redo’s on PRODDB Server 8
Verify the standby redologs after adding at PRODDB Server 9
Set dataguard parameter at PRODDB 9
DR database restore script 10
Create dump and audit directories at STANDDB servers 12
Create initSTANDDB.ora at Standby Servers 12
Verify STANDDB listener and tnsnames.ora file at STANDDB Server 12
Start STANDDB in nomount mode 13
Add STANDDB listener to cluster at STANDDB Server 14
Verify the tnsping and password connection at STANDDB Server 14
Verify the STANDDB listener are registered with cluster 15
Verify the RMAN connection with axillary instance 15
Start RMAN active database duplication 15
Check STANDDB restore status 15
After Restore complete verify the STANDDB 16
Create RAC initSTANDDB1.ora from from initPRODDB1.ora at STANDDB Server 16
Start STANDDB instance using initSTANDB1.ora 17
Create local pfile initSTANDB1.ora point to SPFILE inside diskgroup 18
Start STANDDB1 instance and verify the SPFILE 18
Convert STANDDB database to RAC and add RAC parameter 19
Verify the STANDDB instance started with SPFILE on all nodes 19
Enable Log Archive Destination on Primary STANDDB Server 19
Start MRP process on node1 at STANDDB Server 20

#Dataguard #19c #physicalStandby #oracle #exadata #Standby

Please do follow me and support me on,

Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter: https://twitter.com/mallik034
instagram: https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA

Regards,
Mallikarjun Ramadurg
Mobile: 966 543796525
WhatsApp: 91 9880616848
Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter:https://twitter.com/mallik034
Instagram:https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *

Responses (2)

  1. Thank you, I have recently been searching for
    information approximately this subject for a long time and yours
    is the best I have came upon till now. However, what in regards to the bottom line?
    Are you positive about the supply?

  2. Right away I am going to do my breakfast, later than having my breakfast coming over again to
    read further news. I saw similar here: najlepszy sklep and also here:
    najlepszy sklep