Hi all,
I want to make a recovery practice before we move to another building,but i met a problem which i canot resolve:
a.production machine
b.test machine
c.catalog machine


1. I did a hot backup via Veritas, and it was finished at 22-APR 12:45
2. I have a test machine which i have configure all the enviroment already(including spfile,tnsnames.ora .etc..)
3. Catalog is on the third machine.
4. i run rman on the test machine(rman target / catalog rman/rman@aaa)
5. RMAN>startup nomount
6. run {
allocate channel c1 type sbt;
send 'NB_ORA_CLIENT=db';
restore controlfile;
}
7. RMAN>alter database mount;
8. list backup of controlfile;

List of Backup Sets
===================
............
............
............
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
74053 Incr 0 5.75M SBT_TAPE 00:01:38 22-APR-09
BP Key: 74063 Status: AVAILABLE Compressed: NO Tag: TAG20090422T182046
Handle: full_FIMASYS_4400_1_684873116.bak Media: 0050L2
Control File Included: Ckp SCN: 153914435 Ckp time: 22-APR-09

9. host;sqlplus ...
10. SQL> select controlfile_change# from v$database;

CONTROLFILE_CHANGE#
-------------------
153914435

11.exit to RMAN
12.RMAN> run {
2> set until time "to_date('2009/04/22 13:00','yyyy/mm/dd hh24:mi:ss')";
3> allocate channel c1 type sbt;
4> send 'NB_ORA_CLIENT=db';
5> restore database;
6> recover database;
7> }

Finished restore at 22-APR-09

Starting recover at 22-APR-09

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: '/oradata/FIMASYS10G/undotbs1.dbf'

released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/22/2009 20:02:50
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 4346 lowscn 150296436 found to restore

13. Go to Sqlplus to check the latest v$log
SQL> select thread#,sequence# from v$log;

THREAD# SEQUENCE#
---------- ----------
1 4474
1 4472
1 4473

SQL> select controlfile_change# from v$database;

CONTROLFILE_CHANGE#
-------------------
153914435

SQL> select archivelog_change# from v$database;

ARCHIVELOG_CHANGE#
------------------
153912062
SQL> select checkpoint_change# from v$datafile;

CHECKPOINT_CHANGE#
------------------
153913134
153913863
153913659
153913659
153913863
153913134
153913659
153913133
153913133
153913133
153913863

CHECKPOINT_CHANGE#
------------------
153913134
153913659
153913133
153913863
153913134
153913659
153913133

18 rows selected.
SQL> select * from v$backup
2 ;

FILE# STATUS CHANGE# TIME
---------- ------------------------------------ ---------- ------------
1 NOT ACTIVE 0
2 NOT ACTIVE 0
3 NOT ACTIVE 0
4 NOT ACTIVE 0
5 NOT ACTIVE 0
6 NOT ACTIVE 0
7 NOT ACTIVE 0
8 NOT ACTIVE 0
9 NOT ACTIVE 0
10 NOT ACTIVE 0
11 NOT ACTIVE 0

FILE# STATUS CHANGE# TIME
---------- ------------------------------------ ---------- ------------
12 NOT ACTIVE 0
13 NOT ACTIVE 0
14 NOT ACTIVE 0
15 NOT ACTIVE 0
16 NOT ACTIVE 0
17 NOT ACTIVE 0
18 NOT ACTIVE 0

18 rows selected.


I firstly thought that i may delete the archlog accidently, so i go to rman and run
"crosscheck archivelog all",then made a hot full backup again, then make a restore exercise, but failed again.

So, could anyone give me some suggestions ??
Thanks a lot ~~~~