Standby: Protection Modes.

Posted by FatDBA on October 30, 2012

The protection modes run in the order from highest (most data protection) to the lowest (least data protection):

Minimum Requirements for Data Protection Modes
	Maximum Protection	Maximum Availability	Maximum Performance
Redo Archival Process	LGWR	LGWR	LGWR or ARCH
Network Transmission Mode	SYNC	SYNC	ASYNC when using LGWR process. Not applicable when using ARCH process.
Disk Write Option	AFFIRM	AFFIRM	NOAFFIRM
Standby Redo Logs Required?	Yes	Required for physical standby databases only. Standby redo logs are not supported for logical standby databases.	Required for physical standby databases using the LGWR process.
Database Type	Physical only	Physical and Logical	Physical and Logical

This entry was posted on October 30, 2012 at 10:07 AM and is filed under Advanced. Tagged: DataGuard, standby. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

« Re-Creating the Control File: RMAN Effects during the activity.

Oracle Secure Backup ? »

Tales From A Lazy Fat DBA

Its all about Databases & their performance, troubleshooting & much more …. ¯\_(ツ)_/¯

Likes