Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter database create datafile as

694352Jun 29 2009 — edited Jun 30 2009
Hi

T1-)shutdown immediate;
T2-)Take full backup
T3-)startup;
T4-)move the objects in tablespace test1 to some other tablespace
T5-)drop tablespace test1;
T6-)create tablespace test1
datafile 'C:\oraclexe\oradata\XE\test1.dbf' reuse;
T7-)alter system switch logfile;
/
/
........................................................................................

In some other server;
startup nomount;
restore the backupset which was taken at T2.
restore controlfile at T7.


startup mount;
alter database create datafile 'C:\oraclexe\oradata\XE\test1.dbf' as 'C:\oraclexe\oradata\XE\test1.dbf';

ALTER DATABASE RECOVER automatic database until cancel using backup controlfile;


Recovery performed succefully.


What I wanna ask is;
Since First I issue:
"alter database create datafile as ...."
The contents of this datafile should be deleted with this statement.
Why oracle doesnt give error in recovery, during appliying the statement at T4 ?
I have already deleted the contents of the datafile, how come oracle move the objects?


I hope I am clear
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2009
Added on Jun 29 2009
2 comments
1,059 views