oracle 只有control 与redo文件，如果利用这些恢复数据文件
如题：没有进行备份，暂不考虑能恢复多少数据。或者是这样，我很久之前备份（RMAN）过，但现在不能使用这个备份文件进行恢复。信息如下
1.备份信息
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 601.30M DISK 00:00:47 02-JUL-13
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20130702T150828
Piece Name: /opt/ora10g/flash_recovery_area/ORCL/backupset/2013_07_02/o1_mf_nnndf_TAG20130702T150828_8x4z3dch_.bkp
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 818360 02-JUL-13 /oradata1/system01.dbf
2 Full 818360 02-JUL-13 /oradata1/undotbs01.dbf
3 Full 818360 02-JUL-13 /oradata1/sysaux01.dbf
4 Full 818360 02-JUL-13 /oradata1/users01.dbf
5 Full 818360 02-JUL-13 /oradata1/example01.dbf
6 Full 818360 02-JUL-13 /oradata1/ts_drs.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 6.80M DISK 00:00:02 02-JUL-13
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20130702T150828
Piece Name: /opt/ora10g/flash_recovery_area/ORCL/backupset/2013_07_02/o1_mf_ncsnf_TAG20130702T150828_8x4z55cv_.bkp
Control File Included: Ckp SCN: 818360 Ckp time: 02-JUL-13
SPFILE Included: Modification time: 02-JUL-13
2.恢复语句
RMAN> recover database from Tag= TAG20130702T150828
2> ;
Starting recover at 02-JAN-14
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/02/2014 11:23:57
RMAN-06094: datafile 1 must be restored
restore datafile 1 from Tag=TAG20130702T150828
2> ;
Starting restore at 02-JAN-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata1/system01.dbf
channel ORA_DISK_1: reading from backup piece /opt/ora10g/flash_recovery_area/ORCL/backupset/2013_07_02/o1_mf_nnndf_TAG20130702T150828_8x4z3dch_.bkp
ORA-19870: error reading backup piece /opt/ora10g/flash_recovery_area/ORCL/backupset/2013_07_02/o1_mf_nnndf_TAG20130702T150828_8x4z3dch_.bkp
ORA-19504: failed to create file "/oradata1/system01.dbf"
ORA-27040: file create error, unable to create file
Linux Error: 13: Permission denied
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/02/2014 11:36:01
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 1 found to restore
RMAN> restore datafile1 from Tag=TAG20130702T150828;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, channel, check, controlfile, clone, database, datafile, device, from, force, high, (, preview, spfile, standby, tablespace, until, validate"
RMAN-01008: the bad identifier was: datafile1
RMAN-01007: at line 1 column 9 file: standard input
页:
[1]