最新Oracle数据库文件及恢复方法.docx

Oracle数据库文件及恢复方法
参数文件
对于参数文件，启动根据如下顺序查找参数文件，先查找spfile<ORACLE_SID>.ora，然后查找init<ORALCE_SID>.ora，假设两者均查找不到，那 SIZE 1000M BLOCKSIZE 512,
GROUP 5 '+DG_ORA/ora11g/ora_redo05_5' SIZE 1000M BLOCKSIZE 512,
GROUP 6 '+DG_ORA/ora11g/ora_redo06_6' SIZE 1000M BLOCKSIZE 512
DATAFILE
'+DG_ORA/ora11g/ora_system',
'+DG_ORA/ora11g/ora_sysaux01',
'+DG_ORA/ora11g/ora_rbs01',
'+DG_ORA/ora11g/ora_user',
'+DG_DATA/drora11g/datafile/',
'+DG_DATA/drora11g/datafile/scudatatbs_add1',
'+DG_DATA/drora11g/datafile/scudatatbs_add2',
'+DG_DATA/drora11g/datafile/scudatatbs_add3',
'+DG_DATA/drora11g/datafile/scudatatbs_add4',
'+DG_DATA/drora11g/datafile/scudatatbs_add5',
'+DG_DATA/drora11g/datafile/scudatatbs_add6',
'+DG_DATA/drora11g/datafile/scudatatbs_add7',
'+DG_DATA/drora11g/datafile/scudatatbs_add8',
'+DG_DATA/drora11g/datafile/scudatatbs_add9'
CHARACTER SET AL32UTF8;
RECOVER DATABASE
ALTER SYSTEM ARCHIVE LOG ALL;
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP ADD TEMPFILE '+DG_ORA/ora11g/ora_temp01'
SIZE 10240M REUSE AUTOEXTEND OFF;
数据文件
数据文件恢复：
SQL> select * from v$recover_file;
7 OFFLINE OFFLINE 3147198902 3/7/2022 2:31:33 AM
8 OFFLINE OFFLINE 3147198902 3/7/2022 2:31:33 AM
rman target / nocatalog
RMAN> restore datafile 7;
RMAN> recover datafile 7;
RMAN> sql 'alter database d