| Creation of database [message #51921] |
Fri, 21 June 2002 06:34  |
Vinod Nauriyal
Messages: 5
Registered: June 2002
|
Junior Member |
|
|
Can anybody help me
1)In one oracle server it is posssible to have two database
but you can access one at a time .am i right ?
2)I have my taken a cold backup(datafiles,redologfiles,sontrolfiles,init.ora files) from database server
now useing that backup i want to create a database in another server how i will do that ?
if possible please send me the script?
Cheers
Vinod nauriyal
|
|
|
|
| Re: Creation of database [message #51926 is a reply to message #51921] |
Fri, 21 June 2002 11:53  |
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
|
Senior Member |
|
|
1.YOU CAN HAVE TWO DATABASE IN THE SAME MACHINE.
BUT YOUR DATABASE SID & ORACLE DATABASE NAME SHOULD BE UNIQUE FOR EACH DATABASE.
YOU CAN ACCESS THE TWO DATABASE AT THE SAME TIME BY CONFIGURING THE LISTENER AND TNSNAMES.ORA FILES.
2.INSTALL THE ORACLE IN THE NEW MACHINE WITH SAME SID AND SAME DATABASE NAME AND SAME PATH
(IF THE ORACLE PATH IN HTE FIRST MACHINE IS C:ORACLE THEN IN THE SECONE MACHINE ALSO THE SAME C:ORACLE)
STOP THE DATABASE.
THEN COPY AND PASTE ALL THE FILES((PARAMETER FILE(INIT.ORA),CONTROL FILE,REDO LOG FILE,DATAFILES)
IN THE CURRENT ORACLE PATH.(REPLACE ALL THE FILES)
FOR EXAMPLE (C:ORALEDATABASE DIRECTORY)
THEN START THE DATABASE.
K.SREENIVASAN
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
