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
KZitem: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
KZitem: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
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.co...
6) Creating a Logical Standby Database
docs.oracle.co...
Негізгі бет Webinar-08- Live DataGuard Implementation - DR Setup - Standby Database Setup Easy Steps
No video
Пікірлер: 35