Webinar-08- Live DataGuard Implementation - DR Setup - Standby Database Setup Easy Steps

1) Primary and Standby:
Primary Database
-- Production (Read & Write)
Standby Databases
-- Secondary (Mount, Open Read Only and Read Write)
2) The types of standby databases:
Physical standby database (Redo Apply - Open Read Only)
-- Allows use of the Oracle Active Data Guard option read-only and Open mode.
-- Switchover and/or failover operations are permitted
Logical standby database (SQL Apply - logical SQL statements - Open read Write)
-- Open for user access while applying changes
-- Logical standby tables can be open for SQL queries (read only),
and all other standby tables can be open for updates.
Snapshot Standby Database (No Redo Apply - Open Read Write)
-- Guaranteed restore point
-- Switchover and/or failover operations are not permitted
3) Oracle Data Guard Services:
Redo Transport Services
-- Production to archive destination (Standby)
-- Manage the process of resolving any gaps
-- Automatically detect missing or corrupted archived redo log files
on a standby system and automatically retrieve replacement
Apply Services
-- Redo Apply
-- SQL Apply
Role Transitions
-- Switch Over
-- Failover
4) Oracle Data Guard Protection Modes
Maximum Availability
#DR #DataGuard #Standby #PhysicalStandby #LogicalStandby #SnapshotStandby #Database #Exadata #RAC #ASM #Oracle
Please do follow me and support me on,
LinkedIn: / mallik034
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]
Email: [e-mail]
LinkedIn: / mallik034
TH-cam: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
-- zero data loss
-- redo transport synchronous (applying the transactions at the same time on the primary and secondary database servers)
-- It will allow the primary to continue and the standby to fall slightly behind
Maximum Performance
-- Minimal data loss
-- redo transport is done asynchronously
Maximum Protection
-- zero data loss
-- redo transport is synchronous (applying the transactions at the same time on the primary and secondary database servers)
-- Primary will waits for a response from standby
-- Primary will halt in case no acknoldgement from standby
5) Creating a Physical Standby Database
docs.oracle.com/en/database/o...
6) Creating a Logical Standby Database
docs.oracle.com/en/database/o...

[@manohar5393]

Thank you so much Mallik sir🙏...your commitment to explore your knowledge to all the viewers is well appreciated...please don't stop uploading videos at any point of time becoz it is very usefull for not only beginners but also working professionals🤗

[@Mallik034]

Sure I will

[@sahaniarunitm]

Much appreciate, many thanks for imparting your experience.

[@Mallik034]

My pleasure!

[@madhusudanaraonallamothu2792]

🙏🙏🙏. Thank you very much .

[@Mallik034]

Welcome!

[@sadanb4876]

Attended live webinar... One of the best 👍💯.. Looking forward to see more..

[@Mallik034]

More to come!

[@BHARARHROYAL]

Every session is good explanation
Thanks bro.
God bless you.

[@Mallik034]

Keep watching

[@eriqueemk7885]

Thank you Sir...Good job!

[@Mallik034]

You are welcome

[@ashoksagarbazar1013]

Thanks for sharing data guard topics..

[@Mallik034]

It's my pleasure

[@meghakaradi]

Appreciate❤

[@Mallik034]

Thanks

[@arunhappy8187]

should SID of production and standby be the same or different (in bash_profile)

[@IndiraVlog--]

Nice explained 👍👍 can you please provide document

[@vigneshs1779]

any differnet between 12c and 19c dataguard setup?

[@svpoornima9945]

need to create db on stby server also no right

[@kalpaktrivedi]

I can use the oracle product as personal use and do the dg set up without licence? As i understood, is that correct ?

[@Mallik034]

Yes thats correct

[@babafakruddink6801]

If v use "duplicate target database for standby from active database" will that have any impact on primary w.r.t performance?

[@BHARARHROYAL]

Yes impact but it's depends on load .

[@subbammanatla6913]

why are u setting ORACLE_SID=ORCL on standby box (is that suppose to be ORCLSB) before U connect rman ?

[@Mallik034]

first you need to connect ORCL source database via RMAN so I set env to ORCL and connect to RAMN.
after connecting to RMAN I will connect to ORCLSB.
SO that I can directly close ORCL DB from source target database without backup.

[@mubeenbutt1020]

i am getting an error while duplication
RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available
is there anyone can help me please i tired more than 100 times with many different ways

[@Mallik034]

Its listeners issue

[@harikrishnagajula6485]

What is the purpose of standby control file?

[@krishnaarekar1278]

Yes Malik sir, please explain this topic. Also request you to please explain about standby redo logs.

[@Mallik034]

Controlfile - normal production control file needed for database operation
Standby controlfile - need for building your DR database
Snapshot controlfile- consistent copy of your production control file

[@Mallik034]

Standby redo logs are needed for switch over activity or DR drill activity

[@krishnaarekar1278]

Thank you so much Malik sir

[@krishnaarekar1278]

Malik sir, Can you please explain more about standby controlfile and snapshot controlfile?