temp file, parameter file 복구하기 -- parameter file 백업 SYS @ orcl2 > create pfile from spfile;
-- parameter file, temp file 삭제 [orcl2:dbs]$ rm spfileorcl2.ora [orcl2:dbs]$ rm initorcl2.ora [orcl2:orcl2]$ rm temp04.dbf
-- DB 재기동 SYS @ orcl2 > shutdown abort ORACLE instance shut down. SYS @ orcl2 > startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl2.ora'
-- RMAN 으로 접속 [orcl2:~]$ rman target / nocatalog
RMAN> startup nomount
RMAN> set dbid=1130270061;
RMAN> restore spfile from \ '/u01/app/oracle/flash_recovery_area/ORCL2/autobackup/2023_10_16/o1_mf_s_1150383214_llsmz0hv_.bkp';
RMAN> startup force
-- 상태 확인 SYS @ orcl2 > @i
STATUS ------------ OPEN
temp tablespace 는 parameter file 복구 시 DB 가 재기동되는 과정에서 복구되었습니다. [orcl2:orcl2]$ ls -l temp04* -rw-r----- 1 oracle dba 209723392 10월 16 17:05 temp04.dbf
[DB 내리지 않고 복구하는 방법] alter tablespace temp add tempfile '/u01/app/oracle/oradata/orcl2/temp03.dbf' size 200m;
alter tablespace temp drop tempfile '/u01/app/oracle/oradata/orcl2/temp04.dbf'; |