Oracle Database Discussions

I performed the backup with rman.
RMAN> backup database.

The backup set consists of
82jn9d2t_1_1
83jn9d2t_1_1
c-2861921181-20080805-00

I took the files and scp'd them to another server. I set up all my directories, sid, etc. Made a duplicate environment so the restore wouldn't fail with missing directories.


I set the dbid, restored the spfile, restored the controlfile and put the database:
RMAN> alter database mount;

if I list backup I have:
RMAN> list backup
2> ;


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
255 Full 366.53M DISK 00:03:15 05-AUG-08
BP Key: 258 Status: AVAILABLE Compressed: YES Tag: TAG20080805T134253
Piece Name: /data/backup/RMSD1/83jn9d2t_1_1
List of Datafiles in backup set 255
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 221508395 05-AUG-08 /data/oradata/RMSD1/datafile/undo_ts01.dbf
3 Full 221508395 05-AUG-08 /data/oradata/RMSD1/datafile/sysaux01.dbf
6 Full 221508395 05-AUG-08 /data/oradata/RMSD1/datafile/lob_data01.dbf
8 Full 221508395 05-AUG-08 /data/oradata/RMSD1/datafile/retek_index03.dbf
10 Full 221508395 05-AUG-08 /data/oradata/RMSD1/datafile/retek_index05.dbf
11 Full 221508395 05-AUG-08 /data/oradata/RMSD1/datafile/retek_index06.dbf
14 Full 221508395 05-AUG-08 /data/oradata/RMSD1/datafile/retek_data04.dbf
17 Full 221508395 05-AUG-08 /data/oradata/RMSD1/datafile/anf_indx01.dbf
19 Full 221508395 05-AUG-08 /data/oradata/RMSD1/datafile/aq_data01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
256 Full 655.48M DISK 00:05:26 05-AUG-08
BP Key: 257 Status: AVAILABLE Compressed: YES Tag: TAG20080805T134253
Piece Name: /data/backup/RMSD1/82jn9d2t_1_1
List of Datafiles in backup set 256
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 221508394 05-AUG-08 /data/oradata/RMSD1/datafile/system01.dbf
4 Full 221508394 05-AUG-08 /data/oradata/RMSD1/datafile/retek_index01.dbf
5 Full 221508394 05-AUG-08 /data/oradata/RMSD1/datafile/retek_data01.dbf
7 Full 221508394 05-AUG-08 /data/oradata/RMSD1/datafile/retek_index02.dbf
9 Full 221508394 05-AUG-08 /data/oradata/RMSD1/datafile/retek_index04.dbf
12 Full 221508394 05-AUG-08 /data/oradata/RMSD1/datafile/retek_data02.dbf
13 Full 221508394 05-AUG-08 /data/oradata/RMSD1/datafile/retek_data03.dbf
15 Full 221508394 05-AUG-08 /data/oradata/RMSD1/datafile/users01.dbf
16 Full 221508394 05-AUG-08 /data/oradata/RMSD1/datafile/aqjms01.dbf
18 Full 221508394 05-AUG-08 /data/oradata/RMSD1/datafile/anf_data01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
257 Full 10.17M DISK 00:00:00 05-AUG-08
BP Key: 259 Status: AVAILABLE Compressed: NO Tag: TAG20080805T134824
Piece Name: /data/backup/RMSD1/c-2861921181-20080805-00
Control File Included: Ckp SCN: 221508647 Ckp time: 05-AUG-08
SPFILE Included: Modification time: 05-AUG-08




I catalog the backupset and I run
RMAN> restore database;

Starting restore at 05-AUG-08
using channel ORA_DISK_1
using channel ORA_DISK_2

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/05/2008 14:12:39
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 19 found to restore
RMAN-06023: no backup or copy of datafile 18 found to restore
RMAN-06023: no backup or copy of datafile 17 found to restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 14 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore


any help