Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-14 16:55:51 | 查看: 1387| 回复: 0
如题:没有进行备份,暂不考虑能恢复多少数据。


或者是这样,我很久之前备份(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
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 09:37 , Processed in 0.044629 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569