Home » Server Options » Data Guard » how to create a standby database
how to create a standby database [message #73627] Tue, 08 June 2004 02:00 Go to next message
Tarun Biswas
Messages: 23
Registered: May 2004
Junior Member
pls someone help me how will i create a standby database from a production database.

regards,

Tarun
Re: how to create a standby database [message #73628 is a reply to message #73627] Tue, 08 June 2004 04:19 Go to previous message
Jean Berthold
Messages: 1
Registered: June 2004
Junior Member
Hello,

Below are the steps to startup a new standby database:

1. make a full backup of your production database
2. recreate the same directory structure on the standby server
3. copy your full backup on the standby
(including your archivelogs)
4. make a standby controlfile on the production:
SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS
2 '/u01/oracle/admin/PWJA/adhoc/STANDBY_PWJA_control01.ctl' REUSE
5. copy this controlfile on your standby
6. On the standby:
- modify your init.ora file according the name given on the create controlfile command.
- recreate /var/opt/oracle/oratab
- password file : orapwd file=$ORACLE_HOME/dbs/orapw<$ORACLE_SID> password=***
- init file : ln -s /u01/oracle/admin/<$ORACLE_SID>/pfile/init<$ORACLE_SID>.ora
$ORACLE_HOME/dbs/init<$ORACLE_SID>.ora
- sqlplus /nolog
connect / as sysdba ;
startup nomount
alter database mount standby database ;
recover standby database ;
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
...
...

And that's all !

If your are under windows, you need recreate services.

Have a nice day

EOS Holding
Jean Berthold
Administrateur Unix & Oracle
Unité Gestion de l'infrastructure
Team Systèmes
Ch. de Mornex 10
Tél. +41(0)21 341 24 58
Fax +41(0)21 341 20 49
jean.berthold <mailto:jean.berthold@eosholding.ch>

UNIX is user friendly.
It's just selective about who its friends are.
Previous Topic: Standby database
Next Topic: error using data guard
Goto Forum:
  


Current Time: Thu Mar 28 05:54:02 CDT 2024