DATABASE/RECOVERY
RMAN RESTORE 및 RECOVER 명령
YUNZZANG
2024. 4. 2. 11:17
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