Re: Database Recovery Question

On Aug 5, 2:56 am, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> System Details: Windows XP Professional, 2 GB RAM, Oracle 10.2.0.1
>
> 1. Had to do a Recovery of my laptop. It moved the entire contents of my
> disk to a backup directory but when it restored Windows XP it DIDN'T
> restore applications I had installed.
>
> So, even though my backup directory has all the Oracle executables as well
> as all my Oracle database data, control, redo and sp files my actual "live"
> laptop didn't have Oracle until I reinstalled it.
>
> Need to get the new Oracle instance (DES) to be able to access the old
> Oracle instance's (DES) database files.
>
> 2. Under the "c:\My Backup -- 03-08-07 0541" directory in the following
> subdirectories I have:
>
> c:\oracle\product\10.2.0\admin\des\pfile\init.ora.562007203121
>
> c:\oracle\product\10.2.0\db_1\dbs\spfiledes
>
> control files in:
> c:\oradata\admin\control\des\ctl01\control01.ctl
> c:\oradata\admin\control\des\ctl02\control02.ctl
> c:\oradata\admin\control\des\ctl03\control03.ctl
>
> redo log files in:
> c:\oradata\admin\redo\des\redo01\redo01_01.log
> \redo02_01.log
> \redo03_01.log
> c:\oradata\admin\redo\des\redo02\redo01_02.log
> \redo02_02.log
> \redo02_03.log
> c:\oradata\admin\redo\des\redo03\redo01_03.log
> \redo02_03.log
> \redo03_03.log
>
> system database files in:
> c:\oradata\db\des
>
> application database files in:
> c:\oradata\db\des\data
> c:\oradata\db\des\index
>
> 3. On my C: drive in the "recovered" laptop I created another database with
> the DES name with the following directories:
>
> c:\oracle\product\10.2.0\admin\des\pfile\init.ora.74200716939
>
> c:\oracle\product\10.2.0\db_1\dbs\spfiledes
>
> control files in:
> c:\oradata\admin\control\des\ctl01\control01.ctl
> c:\oradata\admin\control\des\ctl02\control02.ctl
> c:\oradata\admin\control\des\ctl03\control03.ctl
>
> redo log files in:
> c:\oradata\admin\redo\des\redo01\redo01_01.log
> \redo02_01.log
> \redo03_01.log
> c:\oradata\admin\redo\des\redo02\redo01_02.log
> \redo02_02.log
> \redo02_03.log
> c:\oradata\admin\redo\des\redo03\redo01_03.log
> \redo02_03.log
> \redo03_03.log
>
> system database files in:
> c:\oradata\db\des
>
> application database files in:
> c:\oradata\db\des\data
> c:\oradata\db\des\index
>
> 4. Will it be possible for me to shutdown the current DES instance, copy the
> database files, control and redo log files along with the init.ora and
> spfile and then restart the new DES instance and have it recognize the
> "new" datafiles? Will just copying the ora.init file suffice or would I
> have to rename my old one to the new one's name?
>
> I've been using this to practice with Oracle and have no real desire to
> start from scratch if I don't have to. If this IS possible it would also be
> a good exercise for me. But before I start something that can't be done I
> just thought I'd post here to see if it can be done and if there is anything
> I'm missing.
>
> Thanks.

If the backup was taken with the original instance being down (doesn't matter much if it was shutdown normally or crashed,) it's pretty straightforward to mount and open that database copy in the new instance provided that file names and locations are preserved (if they are not, you'll need to rename the files using ALTER DATABASE RENAME FILE commands before the database can be opened.) Since you're using spfile, you don't need init.ora file at all, so don't worry about it.

Hth,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Sun Aug 05 2007 - 08:58:15 CDT