|
(1) 복구 확인용 테이블스페이스 및 테이블 생성
OS> sqlplus / as sysdba SQL> create tablespace test_ts datafile '/legato/oracle/oradata/master/test.dbf' size 10m; SQL> alter user sys quota unlimited on test_ts; SQL> create table sys.test tablespace test_ts as select 1 as no, sysdate as date1 from dual; SQL> exit
OS> rman target /
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP
OFF;
RMAN> report schema;
using target database control file
instead of recovery catalog
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- --------------------
------- ------------------------
1
510 SYSTEM *** /legato/oracle/oradata/master/system01.dbf
2
210 UNDOTBS1 ***
/legato/oracle/oradata/master/undotbs01.dbf
3
430 SYSAUX ***
/legato/oracle/oradata/master/sysaux01.dbf
4
22 USERS ***
/legato/oracle/oradata/master/users01.dbf
5
300 SPLEXT ***
/legato/oracle/oradata/master/splext01.dbf
6
1000 ALST *** /legato/oracle/oradata/master/alst01.dbf
7
100 SUJI *** /legato/oracle/oradata/master/suji01.dbf
8
2400 QCO *** /legato/oracle/oradata/master/qco01.dbf
9
500 LIVE *** /legato/oracle/oradata/master/live.dbf
10
1024 SPLEXEE *** /legato/oracle/oradata/master/splexee01.dbf
11
10 TEST_TS *** /legato/oracle/oradata/master/test.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- --------------------
----------- --------------------
1
269 TEMP 32767
/legato/oracle/oradata/master/temp01.dbf
(2) 데이터 파일과 컨트롤 파일 백업
RMAN> backup database;
… 생략 …
RMAN> backup current controlfile format
'/u01/app/oracle/oradata/devdb_fra/DEVDB/controlfile001.bck';
… 생략 …
RMAN> sql 'alter system switch logfile';
RMAN> sql 'alter system switch logfile'; RMAN> sql 'alter system switch logfile';
RMAN> sql 'alter system switch logfile';
RMAN> sql 'alter system switch logfile';
(3) 테이블 스페이스 삭제
RMAN> sql 'drop tablespace test_ts including contents and datafiles'; -테이블스페이스 삭제 RMAN> exit
OS> tail -n 20
$ORACLE_HOME/rdbms/log/alert_devdb.log
master:root:/usr/bin]tail -f /legato/oracle/admin/master/bdump/alert_master.log
media 'avtar007'
handle 'CONTROLFILE.master.c-2799742462-20111026-04'
Wed Oct 26 18:26:04 2011
drop tablespace test_ts including
contents and datafiles
Wed Oct 26 18:26:20 2011
Deleted file
/legato/oracle/oradata/master/test.dbf
Starting control autobackup
Control autobackup written to DISK device
handle '/legato/oracle/orahome/dbs/c-2799742462-20111026-05'
Completed: drop tablespace test_ts
including contents and datafiles
^Cmaster:root:/usr/bin]date
Wed Oct 26 18:32:38 KORST 2011
18시 27분 시점으로 복구
(4) 테이블스페이스 삭제 상황이므로 컨트롤 파일과 모든 데이터 파일을 복원하고 복구
OS> export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' OS> export NLS_LANG=american OS> rman target /
RMAN> shutdown immediate
RMAN> startup nomount RMAN>
set dbid=2799742462;
set controlfile autobackup format for
device type sbt to 'CONTROLFILE.master.%F';
run {
allocate channel c1 type sbt
PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so,ENV=(PATH=/usr/sbin:/usr/bin:/sbin:/usr/local/avamar/bin)"
format '%d_%U';
send '"--prefix=10g/master/"' ;
send
'"--flagfile=/usr/local/avamar/var/avtar.txt"' ;
restore controlfile from
'CONTROLFILE.master.c-2799742462-20111026-04';
release channel c1;
}
RMAN> startup mount
RMAN> run {
allocate channel c1 type sbt
PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so,ENV=(PATH=/usr/sbin:/usr/bin:/sbin:/usr/local/avamar/bin)"
format '%d_%U';
send
'"--prefix=10g/master/"' ;
send
'"--flagfile=/usr/local/avamar/var/avtar.txt"' ;
restore database;
release channel c1;
}
(5) 복구 확인
RMAN> report schema; Report of database schema
List of Permanent Datafiles
=========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of report command at 05/18/2010 17:54:41 RMAN-20021: database not set RMAN-06031: could not translate database keyword RMAN> exit
OS> rman target /
RMAN> report schema;
using target database control file
instead of recovery catalog
Report of database schema
List of Permanent Datafiles
=========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 200 SYSTEM *** /u01/app/oracle/oradata/devdb/system01.dbf 2 120 UNDOTBS01 *** /u01/app/oracle/oradata/devdb/undotbs01.dbf 3 200 SYSAUX *** /u01/app/oracle/oradata/devdb/sysaux01.dbf 4 10 UNDO01 *** /u01/app/oracle/oradata/devdb/undo01.dbf 5 10 USER_TAB_TS *** /u01/app/oracle/oradata/devdb/user_tab_ts.dbf 6 5 USER_IND_TS *** /u01/app/oracle/oradata/devdb/user_ind_ts.dbf 7 10 TEST_TS *** /u01/app/oracle/oradata/devdb/test_ts.dbf
List of Temporary Files
======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 20 TEMP 2048 /u01/app/oracle/oradata/devdb/temp01.tmp 2 10 TEMP01 10 /u01/app/oracle/oradata/devdb/temp01.dbf
RMAN> exit
OS> sqlplus / as sysdba SQL> select * from sys.test;
NO DATE1
---------- ------------------- 1 2010-05-18 17:36:59 SQL> exit
(6) 정리
OS> rman target / RMAN> show retention policy; RMAN> crosscheck database; RMAN> crosscheck archivelog all; RMAN> report obsolete; RMAN> delete obsolete; RMAN> list backup by file; RMAN> exit | ||||
|
|
2013년 6월 13일 목요일
Avamar Rman Tapble space 복구 방법
피드 구독하기:
댓글 (Atom)
댓글 없음:
댓글 쓰기