1) Install Oracle Home software on new server. Make the Oracle Home directory structure same as old server.
2) Create an Oracle Service same as on old server from OS prompt:
cd\bin
set ORACLE_SID=
oradim -new -sid %ORACLE_SID% -intpwd MYSECRETPASSWORD -startmode M
3) Configure listener on new server using netca utility from OS prompt.
4) Create/check same directory structure on new server for controlfiles, datafiles, redo logfiles, dump files, networking files like sqlnet.ora, tnsnames.ora, listener.ora. This information can be obtained as follows on old server:
conn / as sysdba
select member from v$logfile ;
select name from v$datafile ;
For rest of the files (e.g. controfiles, dump/trace,log files), see parameter file on old server.
2) Create an Oracle Service same as on old server from OS prompt:
cd
set ORACLE_SID=
oradim -new -sid %ORACLE_SID% -intpwd MYSECRETPASSWORD -startmode M
3) Configure listener on new server using netca utility from OS prompt.
4) Create/check same directory structure on new server for controlfiles, datafiles, redo logfiles, dump files, networking files like sqlnet.ora, tnsnames.ora, listener.ora. This information can be obtained as follows on old server:
conn / as sysdba
select member from v$logfile ;
select name from v$datafile ;
For rest of the files (e.g. controfiles, dump/trace,log files), see parameter file on old server.
5. copy the backup files to the same location which RMAN access it from.
5.1 Startup nomount using pfile (taken backup)
6. Restore controlfile from backup
7. restore database
8. open database
Reagrds,
Navaneeth
No comments:
Post a Comment