스터디북125 [10/13] 실습 - 1 RMAN - current redolog file =====================================================================Using RMAN ( base on sequence# )===================================================================== SYS@orcl>select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE#---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- -------------.. 2015. 10. 13. [10/13] 정리 Expert Oracle Database 병렬 처리 부분 읽기 51,132 w control_script.sql _allow_resetlogs_corruption undo가 망가질때도 hidden 건드림 최후의 기법 du -a : 현재 디렉토리의 사용량을 파일단위 출력du -s : 총 사용량을 확인du -h : 보기 좋게 바꿔줌 du -sh * : 한단계 서브디렉토리 기준으로 보여준다. temp 파일 공간 관련 error 발생 해서 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_j000_6434.trc:ORA-25153: Temporary Tablespace is EmptyTue Oct 13 09:10:01 2015Starting back.. 2015. 10. 13. [10/12] RMAN 복구 실습 - 4 출처 : http://cafe.naver.com/ocmkorea/4493 이현룡 교수님 카페 참조 RMAN> list copy; specification does not match any datafile copy in the repositoryspecification does not match any control file copy in the repositoryList of Archived Log Copies for database with db_unique_name ORCL===================================================================== RMAN> backup as copy database; Starting backup at 12-OCT-15.. 2015. 10. 12. [10/12] RMAN 복구 실습 - 3 http://cafe.naver.com/ocmkorea/4490 이현룡 교수님 카페 참조 =================================================================RMAN 완전 복구 실습 1 (system file lost)================================================================= RMAN> backup database plus archivelog; Starting backup at 12-OCT-15 RMAN> exit Recovery Manager complete.[oracle@lnx04 ~]$ rm -rf cd /u01/app/oracle/oradata/orcl/system01.dbf[oracle@l.. 2015. 10. 12. 이전 1 ··· 22 23 24 25 26 27 28 ··· 32 다음