Getting data out of backup files ?

[Exie]

Hi Folks,

I've got a backup of an older Oracle 10g database, I've got all the PFILE's and control files, and data files all ready to go.

I've then got a new 10g R2 DB running.

Whats the easiest way to get the data out of the original data files ?

A) Create new tablespace and copy the data files over (block sizes and extent sizes could be different)
B) Configure a whole new listener to bring the original DB up
C) other...

What do you think ?

 

[SantaMufasa]

Exie,

Neither your "A" nor "B" option will work. So, that leaves you with option "C: Other...".

If your only reasource for your data is in the copy of your data files, then your only option is to get the "older" version of the Oracle 10g software, then re-start the data database using all of the backup files for the old database (i.e., all control files, all on-line redo log files, and all database data files (i.e., the data files that support each tablespace, including SYSTEM, TEMP, and your application tablespaces.)) It is also helpful (but not vital) to use the same "init<SID>.ora" parameter file.

All of the above files must be from the same backup session (unless your database is in ARCHIVELOG MODE, under which circumstance, you can "recover" the database using the archive redo log files...but that is another story that you probably don't need now since you said that you have all of your backup files for the old database.)

Once you get the "old" Oracle 10g database running, you then (as you should have done in the first place) EXPORT ("exp") the Oracle user/schemas from the old database, then IMPORT ("imp") into the new Oracle 10g R2 instance the dump files exported from the older database "exp" exercise.

Let us know how this works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]