|
|
| Re: how to create a standby database [message #73628 is a reply to message #73627] |
Tue, 08 June 2004 04:19  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
