| | How to enable Data Guard for Oracle standby database
Assumptions:
- This is what was done to switch to data guard from manual log shipping on existing standby database
- This is a physical standby
- Maximum Performance mode
- Recovery lag 24 hours
- No role transition is used, just a failover from production to standby database
- Primary database is called PROD and ... | | 
More...
10/28/08 | | | | |
|
| | Create standby controlfile
Syntax how to create Oracle control file for a standby database:
$ sqlplus
SQL*Plus: Release 10.1.0.4.0 - Production on Mon Nov 6 10:16:11 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
With the Partitioning and Data Mining options
SQL> ... | |
More...
11/06/06 | | | | |
|
| | Adding new datafiles to standby database
If parameter STANDBY_FILE_MANAGEMENT is set to MANUAL in Oracle standby database you may get this error when rolling forward:
Media Recovery Log logfile.arc
File #416 added to control file as 'UNNAMED00416' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
Errors with log logfile.arc
Some recovered datafiles maybe left ... | | 
More...
06/22/06 | | | | |
|
|
| | Recover Oracle database and standby db examples
Just some handy quick syntax references for Oracle database recovery.
-- Recover Oracle standby database
select to_char(sysdate, 'dd/mm/yyyy hh24:mi:ss') AS start_time from dual;
ALTER DATABASE RECOVER automatic standby database until time '2006-02-24:09:00:00';
select to_char(sysdate, 'dd/mm/yyyy hh24:mi:ss') AS end_time from dual;
-- Recover database until certain time:
recover database until time '2006-02-24:09:00:00';
-- Recover database after RMAN restore ... | | More...
02/24/06 | | | | |
|
|
