Databases May Be Opened in Read Only and Restricted Modes

Oracle Fail Safe Release 4.2.1 introduces the ability to open an Oracle database cluster resource using the Read Only open mode or with logins restricted to users with the Restricted Session privilege. The selected mode is used if the database fails over to another cluster node, or if the database resource is taken offline and then brought online using a utility other than Oracle Fail Safe Manager. For example, if a database goes offline and then comes online using the Windows cluster manager utility, it will retain the open mode and restricted settings from the last time it opened using Oracle Fail Safe Manager.

In this release, you can select the Read Only and Restricted Modes when the Oracle Database resource is online or offline:

• When an Oracle Database cluster resource is online, you can select the Read Only or Read Write options on the Select Open Mode page.

• When the Oracle Database cluster resource is offline, you can select the desired options on the Properties page for the resource. When the database is brought online the next time, the previously selected mode is used. The open mode may only be changed on the Properties page if the database is offline. The restricted setting can be changed at any time.

  If the database role is a physical standby, then the Properties page shows the following options which are relevant to a standby database:

  • Read Only

  • Enable real time apply

  • Restricted

  • Enable Is Alive polling

  You can set the database to the Read Only mode and select the real time apply checkbox.

You can also change the database open mode and restricted settings using the PowerShell cmdlets. The following commands will start the database in Read Only Restricted mode:

PS C:\Users\admin> $db = Get-OracleClusterResource "Test Database"
PS C:\Users\admin> $db.OpenMode = "ReadOnly"
PS C:\Users\admin> $db.IsRestricted = $true
PS C:\Users\admin> Start-ClusterResource $db.name