Re: Disk is broken can't start Oracle database

"Rexx" <nebacar_at_eunet.yu> wrote in message news:8n8v07$sce$1_at_SOLAIR2.EUnet.yu...
> I run small Oracle 7.3 database in NONARCHIVE log mode on NT with 4 disks
 .
> I have also full database export.
> Suddenly one of disks is broken. That disk is not Nt system disk or disk
> where Oracle server installed, but I can't startup Oracle database.
> Is there any way to :
> 1. 'say to Oracle' don't use files on broken disk and startup Oracle

Yes. Get yourself into the mount stage (asusming that it's not your Control File that's bitten the dust), and then issue the command 'alter database datafile 'path/filename' offline drop'; You'll lose all the data that was stored in the file, of course.

Repeat as often as necessary until all missing datafiles are thus removed.

Then: Alter database open, then 'alter tablespace X drop';

Finally, re-create the tablespace(s) on new disks. Use exactly the same tablespace names as before.

To re-populate the tablespace with the lost data, run import on your full export dump file, and select to import by Table. You'll need to know what tables were stored in the original tablespace (you DO have that information handy, I hope). Name all the tables, and Import should re-populate the freshly-created tablespace (import uses the tablespace name to house the new tables, not the data file paths and/or filenames).

> 2. read the name of lost files (or tablespaces) on broken disk from oracle
> server (maybe from dictionary ).

There are some V$ that tell you what files are stuffed. V$Recovery_files???? I can never remember the damned things off the top of my head. I suggest you 'select * from dictionary where table_name like 'Recover*' ' and see what you get. Sorry to be so vague.

> 3. repair tablespace (even empty) which resided on broken disk to the
 other
> good disk
>

See above.

Regards
HJR
> The name of tablespaces is similar name of files e.g. TS KD, file is
> c:\oradata\KD_DATA.ORA and if I can know name of TS I can remember name of
> files.
>
> --
>
>
> *****************************************
> Remove nospam from address
> My address: nebacar_at_eunet.yu
> ******************************************
>
>
>
Received on Tue Aug 15 2000 - 07:18:19 CDT