※ 필수 파일 1. 닫힌 백업한 데이터 파일 전체 2. redo 로그 파일 3. control 파일 4. 열린 백업 파일 사용 불가 ======================================================================================= SQL> select file_name, file_id, tablespace_name, online_status from dba_data_files; FILE_NAME FILE_ID TABLESPACE_NAME ONLINE_ --------------------------------------------- ---------- -------------------- ------- /oracle/oradata/ora10g/users01.dbf 4 USERS ONLINE /oracle/oradata/ora10g/sysaux01.dbf 3 SYSAUX ONLINE /oracle/oradata/ora10g/undotbs01.dbf 2 UNDOTBS1 ONLINE /oracle/oradata/ora10g/system01.dbf 1 SYSTEM SYSTEM /oracle/oradata/ora10g/example01.dbf 5 EXAMPLE ONLINE SQL> !rm -rf /oracle/oradata/ora10g/* SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> !cp /backup/close/ora10g/* /oracle/oradata/ora10g SQL> startup ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size 79694068 bytes Database Buffers 83886080 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SQL> SQL> !rm -rf /backup/archive1/* SQL> !rm -rf /backup/archive2/*
닫힌상태 - 전체데이터 - 불완전 복구(단순 복구)
|
2006.11.02 15:15:45
|
2006.11.02 15:15:45
|
352
|
Aiden
Total of Attached file
0.00 Bytes of 0 files
2006.11.17
2006.11.16
2006.11.16
2006.11.15
2006.11.02
2006.11.02
2006.10.31
2006.10.30
2006.10.30
2006.10.26
2006.10.25