alter database activate standby database - Accounting - Data BasyX

Oracle DBA Lite: an introduction to Oracle administration, part 6

after rsync on the other machine. Now what when the standby database has to take the place of the failed main database? The operations aren't ...

ORA-01153: an incompatible media recovery is active (recovering ...

Whether or not you perform recovery, RMAN does not activate the standby database after creating it. The only way to activate a standby database is to issue the ALTER DATABASE ACTIVATE STANDBY DATABASE statement.

alter database activate standby database - Bookshelf


Oracle Dataguard, Standby Database Failover Handbook
230 pages
Oracle Dataguard, Standby Database Failover Handbook

This is kind of intentional data loss failover and can be achieved using the following statement: ALTER DATABASE ACTIVATE STANDBY DATABASE; If a standby log ...

Oracle9i RMAN backup & recovery
572 pages
Oracle9i RMAN backup & recovery


Portable DBA, Oracle
598 pages
Portable DBA, Oracle

Functions of the alter database Command The alter database command supports the ... which includes activating standby databases, managing the database ...

Oracle database 10g high availability with RAC, Flashback & Data Guard
421 pages
Oracle database 10g high availability with RAC, Flashback & Data Guard

Activate the logical standby, making it the new primary. alter database stop logical standby apply; alter database activate logical standby database; ...

Oracle 8i backup & recovery handbook
695 pages
Oracle 8i backup & recovery handbook

Activation Notes Activating the standby database clears the online redo logs ... logs just before activation using the alter database clear logfile command. ...