oracle --使用rman 將受損的資料檔復原

把受損檔案復原
select * from v$recover_file

select * from V$datafile

sqlplus /nolog

conn / as sysdba

alter database datafile '資料檔名' offline

rman target sys/oracle@orcl catalog rman/rman@rman
run{
restore datafile '資料檔名';
recover datafile '資料檔名';
}

alter database datafile '資料檔名' online