Re: URGENT - NT Recovery - procedure needed for hot backup

Paul

Thanks for that. We are running 7.3.3 on NT and lost a drive with the OS, SYSTEM and TEMP tablespaces. The NT guys did a a NT rebuild and restored the files from a hot backup so all I needed to do was recover the database which worked. And yes Ive got the Velpuri book which is very good.

Iv just bought the Teach Yourself Oracle 8i Windows NT book so I can get to know Oracle on NT a bit more.

Do you recommedn any others for NT?

Thanks for your help.

John Barron

At 10:25 AM 7/8/00 -0800, you wrote:
>John,
>
>please send version info as to whether its Oracle 7.3.4, 8.0.5, 8.1.6
>...
>
>Do you have all of the following:
>
>- info as to when the first tablespace was placed into backup mode
>- archived redo logs from when the first tablespace was placed into
>backup mode
>- control files, init.ora file
>- all of the online redo logs
>- information as to where the datafiles,logfiles were located (e.g.
>backup controlfile to trace)
>
>Are you planning on trying to recover the transactions in the online
>redo logs, or is incomplete recovery of only the transactions that were
>archived sufficient?
>
>As a procedure, I'd do the following: (taken loosely from Velpuri Backup
>and Recovery handbook - page 278 - great book to have around) ISBN
>0-07-882389-7
>
>Determine the files that you have and which are garbage/lost - will you
>be performing Database Recovery or Tablepsace Recovery? Do you have the
>datafile(s) for the system tablespace?
>Backup the Oracle files that you do have on the server (in case you have
>to open them corrupt).
>
>Complete Recovery Implementation
>1. Restore all files from your backup location (disk or tape) to their
>proper location.
> this includes restoring all of the archived redo logs to the
>log_archive_dest location.
>2. set your environment variables (SET ORACLE_SID=<sid>)
> launch server manager - connect internal as sysdba. (SVRMGR23,
>SVRMGR30 or SVRMGRL)
> startup restrict mount (assuming you have a good controlfile).
>
> SVRMGR> STARTUP RESTRICT MOUNT; <enter>
>
>3. if you have to change the path of your datafiles, rename them now
>
> SVRMGR> ALTER DATABASE RENAME FILE 'oldfilename' TO 'newfilename';
><enter>
>
>4. Make sure that all of the files that you want to recover are online
>
> SVRMGR> select file#, status, name from v$datafile; <enter>
>
> files that are not online, bring online:
>
> SVRMGR> alter database datafile 'filename' online; <enter>
>
>5. Recover the database:
>
> SVRMGR> RECOVER DATABASE; <enter>
>
>
>
>6. Open the Database
>
> SVRMGR> ALTER DATABASE OPEN; <enter>
>
> if you don't have the online redo logs, type the following:
> ALTER DATABASE OPEN RESETLOGS;
>
>
>If you had to perform incomplete recovery:
>until cancel is used if you are performing incomplete recovery
>
>5. SVRMGR> RECOVER DATABASE UNTIL CANCEL; <enter>
>
>6. SVRMGR> ALTER DATABASE OPEN RESETLOGS; <enter>
>
>that was sloppy, but I figured that you'd rather have that quickly.
>
>Paul
>
>Paul Drake
>
>John Barron wrote:
>>
>> Hi
>>
>> Ive never done this before (loadsa times on unix so I know the oracle
>> stuff) and faced with an NT recovery from hot backups. Anyone out there can
>> give me some quick steps/ procedure on how to do this.
>>
>> Cheers
>>
>> John Barron (SF Bay Area about 8am)
>> --
>> Author: John Barron
>> INET: jbarron_at_windriver.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>
>--
>----------------------
>Paul Drake
>paled_at_home.com
>----------------------
>--
>Author: Paul Drake
> INET: paled_at_home.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
Received on Mon Jul 10 2000 - 09:56:41 CDT