# DB 정상적인 종료 SQL> shutdown immediate # 장애유발 # SQL> ! rm /u01/app/oracle/oradata/ora11g/users01.dbf SQL> ! ls /u01/app/oracle/oradata/ora11g/users01.dbf # DB 올리기 SQL> startup ORA-01157: cannot identify/lock data file 4 - see DBWR trace file ORA-01110: data file 4: '/u01/app/oracle/oradata/ora11g/users01.dbf' # 복구 방법 # 1. online 모드로 확인 select * from v$recover_file; 2. offline 모드 변경 SQL> alter data..