hi everyone. I have a database control files, data files, redo log files. I take these files and want to cerate same database on the other machine. How I can create the same database on the other machine? Please show me steps. Thanks...
i assume that you have cold backup i.e consistent.
1) copy the files respective directory (same as prev machine or you have to rename it in mount stage0
2) init.ora file is to be prepared it should be placed in ora_home/database
(in windows) or ota_home/dbs( in unix) eg initabc.ora
(or you can place it where you req but give the entry ifile for direction)
where abc is sid you have it.
in same directory
3) oradim -new -sid abc -startmode auto
4) orapwd file=pwdabc.ora password=xyz
you have to login as sysdba (connect internal/xyz in svrmgrl command prompt in 8i) and startup the database.
Hi dear. I have you other question. I want to connect to my Oracle database using my Window password. Can you help me about this? On my local machine window xp and Oracle 9.0.1. Waiting for you mail. firstname.lastname@example.org
P.S. I found step by step explaination but it didn't work