René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Managing standby databases

Physical standby databases

Logical standby databases

A logical standby datatypes environment is managed through the dbms_logstdby.

Adding tablespaces or datafiles

If the init parameter standby_file_management is not set to auto then newly created tablespaces on the primary server must be created manually on the standby servers as well!

Adding a datafile

If the init parameter standby_file_management is not set to auto then a newly added datafile on the primary server must be copied manually to the standby servers as well!

Changing init.ora parameter

direct path loads/unrecoverable operations

Using open resetlogs

Misc

switchover_status in v$database can be used to determine if a physical standby database in a standby environment is a standby or primary database.
instance_role in v$instance can be used to determine if an instance is an active instance (=primary instance) or a secondary instance.