set oracle_sid = default database

sqlplus

/as sysdba

startup mount

alter datafile 'HR.DBF offline; -- please check the syntnx

alter database open;

recover datafile 'HR.DBF ;

alter datafine 'HR.DBF online;

Then take a backup of the database. Other Guru's please correct me if i am
wrong

----- Original Message -----
From: "jayeshrshah"
<oracledba-ezmlmshield-x10419480.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, December 30, 2005 2:10 PM
Subject: Tablespace Recover


> Dear All DBAs
>
> I need your help .
> I have 2 instance.
> One Is default & Other is created by us.
>
> In Other instance, i have 2 table space , HR & Other is Procurement. I
> want to restore only HR Tablespace its datafile is 'HR.DBF ' in Default
> instance. How is it possible.?
>
> Urgent require help.
>
>
>
>
> With warm regards,
>
> Jayesh shah
> 26868272
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>


Oracle LazyDBA home page