Re: Need help with hot backup of tablespace (ORA-1128, ORA-1113)

I don't have any 7.1 documentation any more, but in later versions this might work:

1- startup mount database
2- alter database datafile 'filename' offline drop;
3- alter database open

Before you do this, you might check sys.dba_data_files for the file name and file id, then sys.dba_extents for that file id to see if anything is supposed to be there.

In article <369576E6.3D875881_at_cyberramp.net>,   Brian Deterling <briande_at_cyberramp.net> wrote:
> I have a tablespace that spans multiple datafiles. One of these
> datafiles is offline and when I try to bring it online, it says I need
> media recovery. I no longer have the backup that contains the logs I
> need. I can not do a hot backup of the tablespace because of this one
> datafile. I'm pretty sure it never was online so it probably doesn't
> contain any data. Can anyone tell me how to either bring the datafile
> online, get rid of it, or get past this problem in another way? I am
> running 7.1.3.2 on VMS.
>
> Thanks in advance,
> Brian Deterling
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 08 1999 - 10:21:01 CST