只有rman备份文件了。只有.bak了,没有控制文件和参数文件。
我先startup nomount;
然后重建控制文件:
CREATE CONTROLFILE REUSE set DATABASE "powerdes" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 454
DATAFILE
'/home/oradata/powerdes/system01.dbf',
'/home/oradata/powerdes/sysaux01.dbf',
'/home/oradata/powerdes/undotbs01.dbf',
'/home/oradata/powerdes/users01.dbf',
'/home/oradata/powerdes/powerdesk01.dbf',
'/home/oradata/powerdes/plas01.dbf',
'/home/oradata/powerdes/pl01.dbf',
'/home/oradata/powerdes/help01.dbf',
'/home/oradata/powerdes/adobelc01.dbf',
'/home/oradata/powerdes/sms01.dbf',
'/home/oradata/powerdes/plcrm01.dbf'
LOGFILE
GROUP 1 ('/home/oradata/powerdes/redo03.log') SIZE 10M,
GROUP 2 ('/home/oradata/powerdes/redo02.log') SIZE 10M,
GROUP 3 ('/home/oradata/powerdes/redo01.log') SIZE 10M,
GROUP 4 ('/home/oradata/powerdes/redo_dg_01.log') SIZE 10M,
GROUP 5 ('/home/oradata/powerdes/redo_dg_02.log') SIZE 10M,
GROUP 6 ('/home/oradata/powerdes/redo_dg_03.log') SIZE 10M
CHARACTER SET ZHS16GBK;
然后rman设置catalog start:
RMAN> catalog start with '/tmp/2015-03-30/';
然后进去恢复
RMAN> restore database;
不过报错如下:
RMAN> restore database;
Starting restore at 01-APR-15
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/01/2015 03:39:01
RMAN-06026: some targets not found - aborting 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 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
RMAN>
------解决思路----------------------
数据文件不一致,缺少归档
备份是怎么备的
------解决思路----------------------
先还原归档试试会不会报错
restore archivelog all
------解决思路----------------------
这种情况下,只能强制拉库了
http://www.xifenfei.com/oracle_recovery_check 检查下数据库,然后发我html文件我给你们分析下 qq :107644445