Raw Device 환경에서 RMAN을 이용한 FileSystem으로 데이터파일 백업하기
1. 현재 환경확인
RMAN> report schema;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 599 SYSTEM *** /dev/raw/raw6
2 199 UNDOTBS1 *** /dev/raw/raw8
3 299 SYSAUX *** /dev/raw/raw7
4 199 UNDOTBS2 *** /dev/raw/raw9
5 99 USERS *** /dev/raw/raw10
6 99 TS_NEW *** /dev/raw/raw24
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 99 TEMP 100 /dev/raw/raw11
2. Raw Device -> File로 백업
run {
copy datafile 1 to ‘/data/rman/SYSTEM.dbf’;
copy datafile 2 to ‘/data/rman/UNDOTBS1.dbf’;
copy datafile 3 to ‘/data/rman/SYSAUX.dbf’;
copy datafile 4 to ‘/data/rman/UNDOTBS2.dbf’;
copy datafile 5 to ‘/data/rman/USERS.dbf’;
copy datafile 6 to ‘/data/rman/TS_NEW.dbf’;
}
3. 파일 복원
$ dd if=/data/rman/TS_NEW.dbf of=/dev/raw/raw24 bs=8k
출처 : http://gyh214.tistory.com/158
최신 댓글