Home » RDBMS Server » Server Administration » Newbie! Cloning of DB
Newbie! Cloning of DB [message #60325] Mon, 02 February 2004 06:45 Go to next message
Cloris Ng
Messages: 2
Registered: February 2004
Junior Member
Hi,

   I'm a newbie in db administration and have a problem here.

   I'm told to clone an oracle db from existing hard disk to a bigger hard disk.  Server used is hp-ux, db used is oracle 7.something.

   Do i have to do imp/exp since os is the same?  Any advice on the simplest way to do it since i'm new to oracle and the db itself.

   Thanks in advance!
Re: Newbie! Cloning of DB [message #60329 is a reply to message #60325] Mon, 02 February 2004 08:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
please have a look here

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Re: Newbie! Cloning of DB [message #60331 is a reply to message #60329] Mon, 02 February 2004 08:23 Go to previous messageGo to next message
Cloris Ng
Messages: 2
Registered: February 2004
Junior Member
Hi,
thanks for your reply and help.
if my machine (hp-ux) has 1 os disk and 1 data disk and i'm only changing the data disk, do i have to deinstall the database? the purpose of changing hard disk is to have more disk space.

thanks in advance!
Re: Newbie! Cloning of DB [message #60332 is a reply to message #60331] Mon, 02 February 2004 09:03 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
depends.
If you are 'moving' the database, shutdown the database, take a clean cold backup of all files,
copy to the new location
recreate the control file.
or
if the disks are volume managed can't u just 'enlarge them'? I am not sure..i may be wrong.talk to ur unix admin.

Whatever you do, TAKE BACKUP BY ALL POSSIBLE MEANS.
coldbackup, exported dumps etc etc.
Previous Topic: Very urgent Deleting link in oralcle 9i
Next Topic: How to consolidate space in tablespace?
Goto Forum:
  


Current Time: Fri Sep 20 10:30:24 CDT 2024