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

Опубликовано: 21 Март 2021
на канале: Vismo Technologies
12,823
207

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  
YouTube:    / mallik034  
Fakebook:   / mallik034  
Blog: https://mallik034.blogspot.com
twitter:   / mallik034  
Instagram:   / mallik034  
FBPage:   / mallik034oracledba  
Skype: malluramadurg


Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: [email protected]
LinkedIn:   / mallik034  
YouTube:    / mallik034  
Fakebook:   / mallik034  
Blog: https://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
https://docs.oracle.com/en/database/o...

6) Creating a Logical Standby Database
https://docs.oracle.com/en/database/o...


Смотрите видео Webinar-08- Live DataGuard Implementation - DR Setup - Standby Database Setup Easy Steps онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Vismo Technologies 21 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 12,823 раз и оно понравилось 207 людям.