Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Recovery Question

Re: Database Recovery Question

From: Alberto Frosi <alberto.frosi_at_gmail.com>
Date: Mon, 06 Aug 2007 08:05:02 -0000
Message-ID: <1186387502.615814.295490@r34g2000hsd.googlegroups.com>


On Aug 5, 12: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.

Hi,
i don't understand very well but maybe i've already done a similar restore:

1) Create new instance
2) Restore password file
3) Restore the  control file
4) Restore the SPFILE
5) Copy datafiles in the original position
6) Restart DB in mount
7) Use NOARCHIVELOG or ARCHIVELOG istance????
7) Open DB with Resetlogs option
8) Restore TEMPFILE

Alberto Frosi Received on Mon Aug 06 2007 - 03:05:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US