Managing a Standby Database – Commands

By | December 16th, 2013|Database, DBA Miscellaneous, Oracle DBA|

ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE [SKIP [STANDBY LOGFILE]]   Changes the state of a standby database to an active database and prepares it to become the primary database.  ALTER DATABASE ADD [STANDBY] LOGFILE [THREAD integer] [GROUP integer]filespec Adds one or more redo log file groups to the specified thread, making them available to the instance assigned [...]