Joan wrote:
> AnaCDent <anacedent_at_hotmail.com> wrote in message news:<NHxic.91851$U83.33754_at_fed1read03>...
>
>>Joan wrote:
>>
>>>Hi all Oracle DBA experts,
>>>
>>>At work we have an Oracle 8i on Unix with a small amount of user data
>>>(less than 10 tables and the largest table has about 4000 records). I
>>>need to move this database to a new machine. The database has no
>>>active transactions so I can shut it down whenever I need to.
>>>
>>>I have textbook knowledge on how to do this but the only hands-on
>>>experience I have is installing Oracle8i on a PC. So I really need
>>>your help.
>>>
>>>My plan is to make a closed database backup, install Oracle8i on the
>>>new machine, then restore the database file. I've read some
>>>documentation, but I want to be sure that I understand the proper way
>>>to do this before I begin? Here are a couple alternatives I see:
>>>
>>>Plan One.
>>>a. SQL>shutdown normal;
>>>b. back up (cp all data files, control files, redo log files, password
>>>file, parameter file).
>>>c. install oracle8i on the new machine
>>>d. restore (cp all backup files to the new machine) when the oracle is
>>>shut down
>>>e. SQL>startup pfile=init.ora;
>>>
>>>
>>>Plan Two:
>>>a. SQL>shutdown normal;
>>>b. back up (cp all data files, control files, redo log files, password
>>>file, parameter file).
>>>c. install oracle8i on the new machine
>>>d. restore (cp all backup files to the new machine) when the oracle is
>>>shut down
>>>e. SQL>startup mount pfile=init.ora;
>>>f. SQL>recover database;
>>>g. SQL>alter database open;
>>>
>>>Plan Three:
>>>Is it easier to do this using Export/Import utility?
>>>
>>>
>>>The database currently is set in Archivelog mode. But there will be no
>>>loss of data when I start doing back up so it is not necessary to
>>>recover the data from archived logs.
>>>
>>>1. My confusion is: for this situation, is the command "recover
>>>database" necessary?
>>
>>Not necessary
>>
>> >Or once the database files are restored, my job
>>
>>>is done?
>>
>>Your job is done
>>
>>>2. Do I need to change archive log mode before backup?
>>
>>NO
>>
>>
>>>3. Is there a command to close a database without dismounting it or
>>>shutting down the instance?
>>
>>HUH?
>>NO
>>
>>
>>>4. Are Export/Import utility, Recover Manger etc available on unix
>>>platform?
>>
>>Yes
>>
>>
>>>5. If what I listed above is not correct way to do this, please kindly
>>>advise how to do this migration.
>>>
>>>Because the new machine is not available yet, I haven't actually done
>>>this. But once it is ready, I have little time to do it. So your
>>>advice is highly appreciated.
>>>
>>>Thank you very much for your help.
>>>
>>>Joan
>>
>>If the new system & the old system have the same OS & OS version,
>>then all you need to do is move all the Oracle files from old to new.
>
>
>
> Thank you much for the tip. The new machine is going to run unix too
> but I am not sure what version. Just want to be sure, do I need to
> reinstall Oracle on new machine? Or I can just move all software files
> over as well along with database files? If the new system and the old
> one have different version of Linux, will Plan One work?
The proof is in the pudding.
It "should" work, but there is no guarentee;
unless the Linux versions are "close enough".
WRT - Installing the base Oracle s/w,
it is safer to do the re-install.
The DB will work even if you simply copy,
but OUI may not allow you to upgrade in the
future, because it "decides" that the new
system does not contain the needed underlying
"previous" version.
Try it on the new box.
If oracle starts & if OUI "sees" the now
current version, then you are home free.
If not, rm -rf & try again. All it cost you
is some time.
Received on Sat Apr 24 2004 - 21:55:59 CDT
