Re: Oracle datafile recovery after hotback

Not sure how you backed it up, but it sounds like it is plain ole' hosed up to me. See below for my duplication of your efforts...

C:\oracle92\oradata\test1>sqlplus "sys/****** as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Thu Jul 21 10:52:08 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production

SQL> alter tablespace users begin backup;

Tablespace altered.

SQL> host cp USERS01.DBF USERS01.DBF.BAK

SQL> alter tablespace users end backup;

Tablespace altered.

SQL>
SQL> create table t0721(c number) tablespace users;

Table created.

SQL> insert into t0721 values(10);

1 row created.

SQL> insert into t0721 values(20);

1 row created.

SQL> insert into t0721 values(30);

1 row created.

SQL> commit;

Commit complete.

SQL> alter tablespace users offline;

Tablespace altered.

SQL> host cp USERS01.DBF.BAK USERS01.DBF

SQL> alter tablespace users online;
alter tablespace users online
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: 'C:\ORACLE92\ORADATA\TEST1\USERS01.DBF'

SQL> recover tablespace users;
Media recovery complete.
SQL> alter tablespace users online;

Tablespace altered.

SQL> select * from t0721;

         C

        10
        20
        30

SQL> The "filesize doesn't match" message sounds like you zipped it or something, or it got corrupted during the copy?

Regards,

Steve Received on Thu Jul 21 2005 - 09:57:51 CDT