Oracle9i Data Guard Concepts and Administration Release 1 (9.0.1) Part Number A88808-01 |
|
Several different SQL statements and SQL*Plus commands use a STANDBY
keyword to specify operations on a standby database. Other SQL statements do not include standby-specific syntax, but are useful for performing operations on a standby database. Table 9-1 describes relevant statements.
Statement | Description |
---|---|
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. See Section 5.4. |
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 the thread. The |
ALTER DATABASE ADD [STANDBY] LOGFILE MEMBER 'filename' [REUSE] TO logfile-descriptor |
Adds new members to existing redo log file groups. The |
ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'filename' |
Creates a standby control file. Issue this statement at the primary database. See Section 2.3.3. |
ALTER DATABASE DROP [STANDBY] LOGFILE logfile_descriptor |
Use the |
ALTER DATABASE DROP [STANDBY] LOGFILE
MEMBER ' |
Use the
Each ' |
ALTER DATABASE MOUNT STANDBY DATABASE |
Mounts a standby database. |
ALTER DATABASE OPEN READ ONLY |
Opens the standby database in read-only mode. See Section 4.7.2. |
ALTER DATABASE COMMIT TO SWITCHOVER TO [PHYSICAL] {PRIMARY | STANDBY} [[NO]WAIT] |
Prepares the current primary database for switchover to standby status or prepares the current standby database for switchover to primary status. |
ALTER DATABASE REGISTER [PHYSICAL]
LOGFILE |
Allows the registration of manually archived logs. |
ALTER DATABASE SET STANDBY DATABASE {PROTECTED | UNPROTECTED} |
Lets you specify whether your database environment is in no-data-loss mode. In this mode, the primary database is protected against data loss and divergence. See Section 3.6.3.5. |
ALTER DATABASE RECOVER [FROM '/dir'] STANDBY DATABASE |
Initiates manual recovery of the standby database. You can specify a nondefault directory for the archived redo logs. See Section B.2.1. |
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE |
Initiates managed recovery of the standby database. See Section 4.3.2. |
ALTER DATABASE RECOVER MANAGED STANDBY
DATABASE [TIMEOUT |
The
The See Section 4.4.9. |
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL [NOWAIT] |
Causes log apply services to wait for managed recovery to finish writing the current log before canceling recovery.
See Section 4.4.1. |
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL [IMMEDIATE] [NOWAIT] |
The
When See Section 4.4.1. |
ALTER DATABASE RECOVER MANAGED STANDBY
DATABASE DELAY |
The |
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE EXPIRE integer; |
The |
ALTER DATABASE RECOVER MANAGED STANDBY
DATABASE DISCONNECT [FROM SESSION]
[NODELAY] [PARALLEL |
The
The
The |
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH [NOWAIT] |
The
Specifying the
The |
ALTER DATABASE RECOVER MANAGED STANDBY
DATABASE NEXT |
The |
ALTER DATABASE RECOVER MANAGED STANDBY
DATABASE [NODELAY] [PARALLEL |
The
The |
STARTUP NOMOUNT pfile='initSID.ora' |
Starts the standby instance without mounting the control file. You must execute this statement before mounting the standby database. See Section 4.3.1 and Section 4.7.2. |
See Also:
Oracle9i SQL Reference and SQL*Plus User's Guide and Reference for detailed information on these SQL statements |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|