why cant i restore/recover...
Hello all, i am trying a recovery to do point in time...but i keep getting errors...y so any ideas ??? i do a backup of my database and its says cant find backup or copy of datafiles...here is what i am doing...am i doing anything wrong ?? and the database is in mount stage..before i used the RUN block...please advice....and also looks like i do have everything...all the files are good...need to reover untill that time...i even tried just recovery....
RMAN> run {
2> set until time "to_date('12/26/2008 18:00:00','mm/dd/yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> alter database open resetlogs;
6> }
executing command: SET until clause
Starting restore at 27-DEC-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/27/2008 15:59:39
RMAN-06026: some targets not found - aborting 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
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u99/backup/rman/control_n_spfile_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u99/backup/rman/%U' MAXPIECESIZE 100 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_rman.f'; # default
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
26 319.43M DISK 00:00:31 26-DEC-08
List of Archived Logs in backup set 26
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 25 459007 13-DEC-08 461330 13-DEC-08
1 26 461330 13-DEC-08 461332 13-DEC-08
1 27 461332 13-DEC-08 461335 13-DEC-08
1 28 461335 13-DEC-08 463761 13-DEC-08
1 29 463761 13-DEC-08 522401 15-DEC-08
1 30 522401 15-DEC-08 592266 16-DEC-08
1 31 592266 16-DEC-08 634021 17-DEC-08
1 32 634021 17-DEC-08 696997 19-DEC-08
1 33 696997 19-DEC-08 747307 20-DEC-08
1 34 747307 20-DEC-08 818489 22-DEC-08
1 35 818489 22-DEC-08 876594 26-DEC-08
1 36 876594 26-DEC-08 876882 26-DEC-08
Backup Set Copy #1 of backup set 26
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:00:31 26-DEC-08 NO TAG20081226T213446
List of Backup Pieces for backup set 26 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
49 1 AVAILABLE /u99/backup/rman/0qk38j3m_1_1
50 2 AVAILABLE /u99/backup/rman/0qk38j3m_2_1
51 3 AVAILABLE /u99/backup/rman/0qk38j3m_3_1
52 4 AVAILABLE /u99/backup/rman/0qk38j3m_4_1
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
27 Full 584.45M DISK 00:01:42 26-DEC-08
List of Datafiles in backup set 27
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 876896 26-DEC-08 /u14/oradata/rman/system01.dbf
2 Full 876896 26-DEC-08 /u14/oradata/rman/undotbs01.dbf
3 Full 876896 26-DEC-08 /u14/oradata/rman/sysaux01.dbf
4 Full 876896 26-DEC-08 /u14/oradata/rman/users01.dbf
5 Full 456248 13-DEC-08 /u14/oradata/rman/test01.dbf
6 Full 876896 26-DEC-08 /u14/oradata/tspir01.dbf
Backup Set Copy #1 of backup set 27
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ --------------- ---------- ---
DISK 00:01:42 26-DEC-08 NO TAG20081226T213518
List of Backup Pieces for backup set 27 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
53 1 AVAILABLE /u99/backup/rman/0rk38j4m_1_1
54 2 AVAILABLE /u99/backup/rman/0rk38j4m_2_1
55 3 AVAILABLE /u99/backup/rman/0rk38j4m_3_1
56 4 AVAILABLE /u99/backup/rman/0rk38j4m_4_1
57 5 AVAILABLE /u99/backup/rman/0rk38j4m_5_1
58 6 AVAILABLE /u99/backup/rman/0rk38j4m_6_1
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
28 3.50K DISK 00:00:01 26-DEC-08
BP Key: 59 Status: AVAILABLE Compressed: NO Tag: TAG20081226T213703
Piece Name: /u99/backup/rman/0sk38j7v_1_1
List of Archived Logs in backup set 28
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 37 876882 26-DEC-08 876934 26-DEC-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29 Full 7.08M DISK 00:00:01 26-DEC-08
BP Key: 60 Status: AVAILABLE Compressed: NO Tag: TAG20081226T213705
Piece Name: /u99/backup/rman/control_n_spfile_c-1559788775-20081226-00
Control File Included: Ckp SCN: 876940 Ckp time: 26-DEC-08
SPFILE Included: Modification time: 26-DEC-08
RMAN>
NOW I TREID JUST RECOVERY ONLY...AS ALL DATAFILES EXISTS
RMAN> run
2> {
3> set until time "to_date('12/26/2008 18:00:00','mm/dd/yyyy hh24:mi:ss')";
4> recover database;
5> alter database open resetlogs;
6> }
executing command: SET until clause
Starting recover at 27-DEC-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/27/2008 16:04:36
RMAN-06555: datafile 1 must be restored from backup created before 26-DEC-08
RMAN>