作者:Patrick 来源:希赛网
然后修改controlfile文件内容,去掉不用的文件名。
不完全恢复数据库:
sqlplus / as sysdba
startup nomount;
重建控制文件:
CREATE CONTROLFILE REUSE DATABASE "XXX" RESETLOGS ARCHIVELOG
MAXLOGFILES 40
MAXLOGMEMBERS 3
MAXDATAFILES 400
MAXINSTANCES 2
MAXLOGHISTORY 454
LOGFILE
GROUP 1 (
'/oracle/oradata/xxx/rdb_redo01a'
) SIZE 10M,
GROUP 2 (
'/oracle/oradata/xxx/rdb_redo02a'
) SIZE 10M
DATAFILE
'/oracle/oradata/xxx/system01.dbf',
'/oracle/oradata/xxx/undo01.dbf',
'/oracle/oradata/xxx/sysaux01.dbf',
'/oracle/oradata/xxx/pay_ts01.dbf'
CHARACTER SET ZHS16GBK
;
recover database until cancel using backup controlfile;
...
alter database open resetlogs;
做数据恢复操作:
create table xxx as select xxx from xxx where xxx;
exp,ftp .dmp,imp
也可以如下所示,这样会更简单一些:
restore database;
recover database using backup controlfile until cancel;
alter database open resetlogs;
...
END!!!
文章来源于领测软件测试网 https://www.ltesting.net/