DB스토리

Archive log mode 확인 select log_mode from v$database; full backup 본 있을 것. rman target / list backup of database; rman 관련. RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTR..

-- 데이터의 이전. External Table insert into~ Loader yes --Create Directory S SYS> create directory dmpdir as '/home/oracle'; Directory created. S SYS> grant write,read on directory dmpdir to scott,hr; Grant succeeded. S SCOTT> select * from all_directories; OWNER DIRECTORY_NAME ------------------------------ ------------------------------ DIRECTORY_PATH -----------------------------------------------..

--Flashback mode 로 전환 하는 절차 ---- OMF 모드에서. --1. 모드 확인 S SYS> select log_mode, flashback_on from v$database; LOG_MODE FLASHBACK_ON ------------ ------------------ ARCHIVELOG NO --2. mount S SYS> shutdown immediate --3 mount 모드로 S SYS> startup mount S SYS> alter database flashback on; Database altered. --4. open S SYS> alter database open; Database altered. --5 . 동작 확인 S SYS> show parameter db_rec..

에러난 파일 찾아주는 스크립트 select name, error from v$datafile join v$recover_file using (file#) / online 상태(open 상태) 에서 복구 ---1 고장내기 rm /u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_53cr5v92_.dbf S SYS> create table x(x date) tablespace example; Table created. 에러 안나고 성공시 S SYS> alter system checkpoint; S SYS> @errFile NAME -----------------------------------------------------------------------------..