Home » RDBMS Server » Server Administration » DBFs, init.ora, control files
DBFs, init.ora, control files [message #58304] Wed, 13 August 2003 09:39 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #58330 is a reply to message #58307] Thu, 14 August 2003 12:30 Go to previous messageGo to next message
Brent
Messages: 4
Registered: August 2003
Junior Member
How can I use the edited control file trace to create a database?
Re: DBFs, init.ora, control files [message #58333 is a reply to message #58307] Thu, 14 August 2003 14:15 Go to previous message
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.
Previous Topic: what is the diff in all 3 stmts
Next Topic: Playing ping pong with ORA-01033
Goto Forum:
  


Current Time: Fri Sep 20 06:34:17 CDT 2024