database backup [message #63513] |
Tue, 12 October 2004 04:48 |
sachin sharma
Messages: 9 Registered: February 2004
|
Junior Member |
|
|
I have an Oracle 8i on win2k server. i want to reinstall oracle 8i on the same server how do i backup and restore the database
Is there a manual procedure to do it not through OEM
thanks in advance
|
|
|
|
Re: database backup [message #63527 is a reply to message #63513] |
Wed, 13 October 2004 05:39 |
dilip kumar
Messages: 111 Registered: December 2003
|
Senior Member |
|
|
Hi,
you can use export/import method, there is an another easy option is there
just copy all the datafiles/online redologfiles/archive logfiles/controlfiles along with parameter and passwordfile to some safest destination
(try to note down the locations of these files b.cos when u use this database in new ENVIRONMENT create the same locations on your system)
then after installing oracle simply copy all the files to the required destinations of each file in your new environment.
1)then delete the old password file only
2)create a new instance on your system with your earlier instance name with the help ORADIM server utility
3)create a new password file with a ORAPWD utility
4)then logon to sqlplus/svrmgrl as sysdba
5)simply say startup
this will work
Regards
D.Dilip
|
|
|