안녕? 나야 :)

SQL> CREATE TABLESPACE data01 DATAFILE '/u01/app/oracle/oradata/ora11g/data01.dbf' SIZE 5m; SQL> select a.file#, a.name file_name, b.name file_name, b.name tbs_name, a.status, a.checkpoint_change# from v$datafile a, v$tablespace b where a.ts# = b.ts#; SQL> select a.file#, a.name file_name, a.checkpoint_change#, b.status, b.change#, to_char(b.time, 'yyyy-mm-dd hh24:mi:ss') from v$datafile a, v$ba..

1. archive log file 생성되는 디렉터리 생성 [oracle1@oracle ~]$ pwd /home/oracle1 [oracle1@oracle ~]$ mkdir arch1 [oracle1@oracle ~]$ mkdir arch2 [oracle1@oracle ~]$ ls arch1 database Downloads p13390677_112040_LINUX_1of7.zip Public Videos arch2 Desktop Music p13390677_112040_LINUX_2of7.zip Templates backup Documents ora_data Pictures userdata 2. oracle 접속 (=> sql developer로 확인) [oracle1@oracle ~]$ sqlplus..

#) data file 상태 확인 select name, status from v$datafile; # DB 정상적인 종료 SQL> shutdown immediate # 장애 유발 # SQL> ! rm /u01/app/oracle/oradata/ora11g/users01.dbf SQL> ! rm /u01/app/oracle/oradata/ora11g/example01.dbf SQL> ! ls /u01/app/oracle/oradata/ora11g/ SQL> ! ls /u01/app/oracle/oradata/ora11g/ # DB 올리기 SQL> startup ORA-01157: cannot identify/lock data file 4 - see DBWR trace file ORA-01110: data..

# 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..