Re: How do I MOVE a database?

How to move a database :

1. Shutdown normal
2. Move your database files and/or redo log files and/or control files using whatever O/S commands you like.
3. If you moved the control files, then edit your configuration file to reflect the new locations.
4. In Server Manager, mount, but don't open your database : ie. startup mount
5. In Server Manager, rename each file that you moved with the alter database command : ie Alter database rename file 'oldname' to 'newname'; (the ENTIRE path must be used) 6.In Server Manager, open your database : ie. Alter database open;

thats all there is to it.

Rob Medley
medleyrk_at_iafrica.com

dperez_at_juno_nospam.com wrote:

> Well, once again I TRIED to do something I THOUGHT was simple........
>
> I installed Designer/2000 2.1.1 in Personal Oracle 8.0.4 and had it install the
> seeded database. Which of course it put where I DIDN'T want it.
>
> SO, I want to move the database in its entirety to two other disks......
>
> With the database up and running I did a backup controlfile to trace. Worked
> fine. Got a text file with all the database files in it.
> I shutdown the database. I copied all the tablespaces, log files, init file,
> EVERYTHING but the control files to the two disks I wanted files on. Deleted
> the files from the disk where I DIDN'T want them.
>
> Then I stopped the service, and went into oradim80 and deleted the database.
>
> I changed the initd703.ora file so the control files would be on the disks where
> I was putting the database.
>
> I edited the text file from the trace earlier and pointed everything at the
> files on the new disks.
>
> Then I did the following to get a new instance
> oradim80.exe -new -sid D703 -intpwd internal -startmode auto -pfile
> k:\d703\initd703.ora
>
> Now, as NEAR AS I CAN TELL, everything was happy up to this point.......
>
> THEN I went into the server manager and started the database with a
> startup nomount pfile=k:\d703\initd703.ora ----- worked fine
> and executed the statement in the trace file to get a new controlfile where I
> wanted it.......... ALSO WORKED FINE AS NEAR AS I CAN TELL. At least, I got
> two control file, one on each of the disks where they belonged.
>
> Here's where things start to compost!!!!!!!!!!!!!!
>
> I shutdown and did a startup open pfile=k:\d703\initd703.ora and got the
> following error:
> ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
>
> so I did a shutdown then a startup mount pfile=K:\d703\initd703.ora - worked OK
> and an alter database open resetlogs - and got the following error
> ORA-01194: file 1 needs more recovery to be consistent
> ORA-01110: data file 1: 'K:\D703\SYS1D703.ORA'
>
> SO THEN I tried to do a recover datafile 'k:\d703\sys1d703.ora'
> ORA-00283: recovery session canceled due to errors
> ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
>
> SO THEN (and I'm desperately trying not to start screaming vulgarities at this
> thing) I did a recover database using backup controlfile -- and I get
> the following:
>
> ORA-00279: change 1515663 generated at 01/03/99 22:47:58 needed for thread 1
> ORA-00289: suggestion : P:\ORANT\RDBMS80\ARC1.1
> ORA-00280: change 1515663 for thread 1 is in sequence #1
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
>
> ORA-00308: cannot open archived log 'P:\ORANT\RDBMS80\ARC1.1'
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
> What the hell do I do with this POS NOW????????? I don't have any archives, at
> least not that I know of...... I just want everything to reset and be empty so
> I can do designer stuff.......... So, what do I do NOW?
Received on Thu Jan 14 1999 - 14:46:49 CST