Re: moving a database

From: Hakan Eren <heren_at_home.com>
Date: Mon, 14 Feb 2000 18:37:45 GMT
Message-ID: <38A84BBE.44DA382D@home.com>

Hi Hakan,

You can do it in two ways:

1. Move database files, online redo log files and control files.
2. Create a new database, make an export/import.

As I understand you prefer 1). The steps are as follows:

. Make a full backup or export. Be sure it works.

. run svrmgr23 (maybe svrmgr80 for 8i, please check oracle\bin directory.

                svrmgr23 for oracle 7.3.4)

svrmgr23
connect internal;
shutdown;
exit;

then copy your datafiles by explorer(I assume all files are in c):

copy c:\orant\database\*.ora e:\mynewdatabase\*.ora

svrmgr23
connect internal; --> (You need to start OracleService<SID> in order to connect

                       otherwise you cannot mount the database)

startup mount;

. do the following for each datafile

alter database rename file 'c:\orant\database\datafile1.ora' to 'e:\mynewdatabase\datafile1.ora';
....
alter database open;

. If you move your controlfiles please don't forget to change your init<SID>.ora file.
  For moving controlfiles you don't use 'alter database'. Just shutdown the database,
  move your controlfiles and edit your init file accordingly.

Good luck.

Hakan Eren

Note: If you need further help let me know.

Håkan Wahlberg wrote:
>
> Hm... sorry to bother again, but I'm not that familiar with Oracle.
>
> When I executed the "alter database backup controlfile to trace"-command
> there was a trace-file generated with information about my datafiles. OK, now
> I can change the location of these files
> in this trace-file and move the datafiles physically.
>
> Then what? How do I get my Oracle instance to use this new information from
> the tracefile?
> Do I need to shut down Oracle?
>
> By the way, it's an Oracle 8.1.5 on Windown NT 4.0.
>
> Thanks in advance for any help.
> /Håkan W
>
> Mulderonline wrote:
>
> > different choice:
> > 1) easy : make link on file to old location
> > 2) rename datafiles in controlfiles
> > You have to backup controlfile to trace
> > rename datafile in trace
> > move files
> > execute backup controlfile trace in svrmgrl
> > 3) rename individualy datafiles:
> > alter database rename datafile '/...' to '/...';
> > ...
> >
> > "Håkan Wahlberg" <hakan.wahlberg_at_boliden.se> a écrit dans le message news:
> > 38A42816.A7A90220_at_boliden.se...
> > > How do I move a database (instance) with all its files from one disk to
> > > another.
> > > /Håkan W
> > >
> > >
Received on Mon Feb 14 2000 - 12:37:45 CST