본문 바로가기
DATABASE/RECOVERY

RMAN RESTORE 및 RECOVER 명령

by YUNZZANG 2024. 4. 2.
728x90
RMAN에서 시작
Alter tablespace <tablename> offline immediate;
Restore tablespace <tablename>
Recover tablespace <tablename>
Alter tablespace <tablename> online;
--- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
데이터파일의 fail
disk - rename - restore - recover
file -restroe - recover

--- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---

noarchivelog 복원
startup force nomount;
restore controlfile;
alter database mount;
restore database;
recover database noredo;
alter database open resetlogs;
complete recovery

댓글