Dear,
I want to restore only one datafile restore one instance to other.
Like i have 2 Instance
DB 1
1. System.dbf
2 . User.dbf
3 HR.dbf
4. finance.dbf
DB 2
1. system.dbf
2.user.dbf
Now i want to restore hr.dbf into DB2 database
Is it possible. bcose i tried and give error
ORA-1203,ora,-01110,ora-01122
ORA-01203 wrong incarnation of this file - wrong creation SCN
How it is possible.
With warm regards,
Jayesh shah
26868272
"Premnath " <oracledba-ezmlmshield-x15303328.[Email address protected]
12/30/05 02:51 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
Re: Tablespace Recover
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
>
>
--------
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