Newbie! Cloning of DB [message #60325] |
Mon, 02 February 2004 06:45 |
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 #60331 is a reply to message #60329] |
Mon, 02 February 2004 08:23 |
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 |
|
Mahesh Rajendran
Messages: 10708 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.
|
|
|