How do I MOVE a database?

From: <dperez_at_juno_nospam.com>
Date: Mon, 11 Jan 1999 02:59:34 GMT
Message-ID: <3699646b.4597370@news.cwix.com>

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 Sun Jan 10 1999 - 20:59:34 CST