on 10-27-2008 6:02 AM
Dear All
I want to configure DR Server from Scrach, my production server Working Excellently , with it i want to Stand DR Server ,
Plz tell me Step by step configutaion to built DR server
Best Regard
Imran Khan
There is nothing like a "step-by-step" setup for a cluster and/or DR configuration. Those configurations are different for each installation (e. g. shared/non-shared disks, cluster product used etc.).
you didn´t even specify what database you use.
I suggest: Get you hardware vendor together with a database specialist and set up an environment.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> in case of Disaster , will switch manually
Ok.
In that case you can make a system copy on the second machine, and write a small script that will take the archive logs and apply them to the database.
You can check for documentation e. g. at
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm
Markus
hi markus
i have Stand DR same as PRD,
i have started recover database as describe bellow
Archive started PRDARCHARC05846_0657865393.001
ended PRDARCHARC05871_0657865393.001
SQL> startup mount
ORACLE instance started.
Total System Global Area 1526726656 bytes
Fixed Size 2053752 bytes
Variable Size 771754376 bytes
Database Buffers 738197504 bytes
Redo Buffers 14721024 bytes
Database mounted.
SQL> recover database using backup controlfile;
ORA-00279: change 43466897 generated at 10/28/2008 13:13:57 needed for thread 1
ORA-00289: suggestion : F:\ORACLE\PRD\ORAARCH\PRDARCHARC05846_0657865393.001
ORA-00280: change 43466897 for thread 1 is in sequence #5846
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 43482134 generated at 10/28/2008 13:40:50 needed for thread 1
ORA-00289: suggestion : F:\ORACLE\PRD\ORAARCH\PRDARCHARC05847_0657865393.001
ORA-00280: change 43482134 for thread 1 is in sequence #5847
ORA-00278: log file 'F:\ORACLE\PRD\ORAARCH\PRDARCHARC05846_0657865393.001' no
longer needed for this recovery
..........
........
.........
ORA-00279: change 43655018 generated at 10/29/2008 09:21:20 needed for thread 1
ORA-00289: suggestion : F:\ORACLE\PRD\ORAARCH\PRDARCHARC05872_0657865393.001
ORA-00280: change 43655018 for thread 1 is in sequence #5872
ORA-00278: log file 'F:\ORACLE\PRD\ORAARCH\PRDARCHARC05871_0657865393.001' no
longer needed for this recovery
ORA-00308: cannot open archived log
'F:\ORACLE\PRD\ORAARCH\PRDARCHARC05872_0657865393.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
SQL>
plz tell me my DR server working Or something wrong with
Hi according to log details which you paste
oracle no needed recovery its saying that means, database can open and ready to use for the lastest level upto which you applied archive logs.
You are doing right only, for your conformation you please try to activate the standby db to primary. Onceagin u have restore for standby (DR)
Regards
MLN
Hi dear,
now i install a new DR server for PRD. its
configuration same as PRD
DR server
SERVER NAME: PRDSAP
DATA BASE : Oracle 10g
and also hardware same as PRD.
i want to copy Archive file manually from PRD to DR.
i will fellow this procedure
1 )Copy SAPDATA1 ,SAPDATA2, SAPDATA3, SAPDATA4 from PRD to DR
2)the control files of origlogA, origlogB, sapdata1 from PRD to DR .
3) copy archive files from PRD TO DR
4)SQL> Startup nomount
5)SQL> recover database using backup controlfile;
please tell me this procedure right or some thing wrong withit
Best Regard
Imran Khan
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.