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.
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 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