|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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
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.