| Standby database [message #56742] |
Tue, 22 April 2003 05:14  |
rajmukesh
Messages: 14
Registered: March 2003
|
Junior Member |
|
|
Hi
Give me details regarding standby database.
How to implement and in what ways it is helpful for a DBA.
What are the requirements for a standby database?
rgds
rajmukesh
|
|
|
|
| Re: Standby database [message #56779 is a reply to message #56742] |
Thu, 24 April 2003 01:41  |
sujit
Messages: 94
Registered: April 2002
|
Member |
|
|
While your production database is running, take an (image copy) backup and restore it on duplicate hardware. Note that an export will not work!!!
On your standby database, issue the following commands:
ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'file_name';
ALTER DATABASE MOUNT STANDBY DATABASE;
RECOVER STANDBY DATABASE;
On systems prior to Oracle 8i, write a job to copy archived redo log files from the primary database to the standby system, and apply the redo log files to the standby database (pipe it). Remember the database is recovering and will prompt you for the next log file to apply.
Oracle 8i onwards provide an "Automated Standby Database" feature which will send archived log files to the remote site via NET8, and apply then to the standby database.
When one needs to activate the standby database, stop the recovery process and activate it:
ALTER DATABASE ACTIVATE STANDBY DATABASE;
·
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
