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
"Rexx" <nebacar_at_eunet.yu> wrote in message
news:8ne66g$etu$1_at_SOLAIR2.EUnet.yu...
>
>
> > 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 .....
>
Absolutely. Once you are in mount stage, you have read the Control File, and hence all V$ views relating to physical disk structures can be read (since the Control File has pointers to all the files in the database). For example, v$datafile, v$logfile, v$log, v$controlfile.
Regards
HJR
>
> *****************************************
> > > Remove nospam from address
> > > My address: nebacar_at_eunet.yu
> > > ******************************************
> > >
> > >
> > >
> >
> >
>
>
Received on Thu Aug 17 2000 - 16:31:24 CDT