Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Disk is broken can't start Oracle database
> 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.
My problem is how read the name of lost files (or tablespaces) on broken
disk from oracle server, when I am in mount stage. Can I in that moment
use V$ tables to get some useful data?
I know that I can use V$ to get data when Oracle DB is live, but in Mount
stage .....