DBFs, init.ora, control files [message #58304] |
Wed, 13 August 2003 09:39 |
Brent
Messages: 4 Registered: August 2003
|
Junior Member |
|
|
Hi!
I'm trying to create a replica of an oracle database on my machine and I copied the dbf, init.ora and control files from the machine that I'm replacing.I first created a database with the same name as the one i'm copying then I edited the init.ora and control files to the correct paths of the datafiles in the old database. When I shut down and try to start the database again I get a red excamation triangle being shown when "mounting the database". Can anyone help me??
Thanks
|
|
|
Re: DBFs, init.ora, control files [message #58307 is a reply to message #58304] |
Wed, 13 August 2003 10:19 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
you cannot just 'PLUG-IN' the datafiles into another database.
in source :
1. make sure there is no other user;
2. do a clean restart.
3. backup the control file to trace;
4. shutdown
5. DONT OPEN THIS DATABASE UNTIL you are done with step cloning the database in another machine.
6. copy all the initsid.ora,datafiles, controlfiles
logfiles,archived logs and evertyhing to the other machine
in target machine:
1. install oracle
2. DONT CREATE A DATABASE.
3. edit the traced control file script to reuse the existing datafiles and control files.
make sure all the path locators are correct.
4. use this script to create the database.
5. now, when You create the database, it will use the existing control files and datafiles.
6. if everything is ok, open the source db.
else
startover again.
this is pain...
easiest way would be,
create the same tablespaces in another database ( like the target db).
create the same users.
export source.
import into target.
[Updated on: Sun, 22 March 2009 11:05] Report message to a moderator
|
|
|
Re: DBFs, init.ora, control files [message #58312 is a reply to message #58304] |
Wed, 13 August 2003 12:47 |
Satish Shrikhande
Messages: 167 Registered: October 2001
|
Senior Member |
|
|
Mr.
-- Install Oracle without creating database
-- Copy all the files to there desired directory
-- created a service using oradim72 utility
-- start all the services and change those to automatic
-- Go to the commnand prmopt and execute
startup pfile='your init.ora file'
Good Luck!
|
|
|
|
Re: DBFs, init.ora, control files [message #58333 is a reply to message #58307] |
Thu, 14 August 2003 14:15 |
Brent
Messages: 4 Registered: August 2003
|
Junior Member |
|
|
ok a figured out how to do that an run the script, but I get the error logical block size mismatch error which says that my datafiles are not a multiple of the logical block size.
|
|
|