不完全恢复中得问题报错

那位，.大大帮忙看下啊~！

SQL> alter tablespace system begin backup;

Tablespace altered
SQL> select file_name,tablespace_name from dba_data_files;

FILE_NAME                                           TABLESPACE_NAME
-------------------------------------------------- ------------------------------
/u01/app/oracle/oradata/ora10/example.dbf           EXAMPLE
/u01/app/oracle/oradata/ora10/users01.dbf           USERS
/u01/app/oracle/oradata/ora10/sysaux01.dbf           SYSAUX
/u01/app/oracle/oradata/ora10/undotbs01.dbf           UNDOTBS1
/u01/app/oracle/oradata/ora10/system01.dbf           SYSTEM

SQL> !
[oracle@oracle ~]$ cd /u01/
[oracle@oracle u01]$ ls
app
[oracle@oracle u01]$ cp /u01/app/oracle/oradata/ora10/*.dbf /u01/
[oracle@oracle u01]$ exit
exit

SQL> alter tablespace system end backup;

Tablespace altered.

SQL> create table test4 (a int) tablespace users;

Table created.

SQL> insert into test4 values(1);

1 row created.

SQL> insert into test4 values(2);

1 row created.

SQL> insert into test4 values(3);

1 row created.

SQL> commit
  2  ;

Commit complete.
SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'YY
-------------------
2011-09-04 02:48:00

SQL> drop table test4;

Table dropped.

SQL> shutdown immediate;

Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> SQL>
SQL> !
[oracle@oracle ~]$ cp /u01/
app/           example.dbf    sysaux01.dbf   system01.dbf   temp01.dbf     temp.dbf       undotbs01.dbf  users01.dbf   
[oracle@oracle ~]$ cp /u01/*.dbf /u01/app/oracle/oradata/ora10/
[oracle@oracle ~]$ exit
exit

SQL> startup mount;
SQL> alter system switch logfile;

SQL> recover database until time '2011-09-04 02:48:00';

SQL> recover database until time '2011-09-04 02:48:00';
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 2 needs more recovery to be consistent
ORA-01110: data file 2: '/u01/app/oracle/oradata/ora10/undotbs01.dbf'

这报错是什么原因啊~ 我做了三次都是说日志文件重设后，会有文件不一致

[ 本帖最后由 l-vley 于 2011-9-7 13:08 编辑 ]

指定redo恢复

backup 之后有alter database end bakcup?

1.没看见你begin backup啊，而且你似乎end的只是一个tablespace
2.你为什么switch logfile呢？
3.备份应该用RMAN~

[ 本帖最后由 iori809 于 2011-9-7 13:03 编辑 ]

这条有~！  忘了弄上去了

这个怎么 指定啊，咱好想没学到这~