BIG_RM_BAS_OPEN

Size: px

Start display at page:

Download "BIG_RM_BAS_OPEN"

しげのぶやすこ
4 years ago
Views:

1 Oracle8 &

7 Oracle Oracle Enterprise Enterprise Manager Manager Recovery Recovery Manager Manager GUI Oracle8 Oracle8 Oracle8 Oracle8

10 V$BACKUP V$BACKUP_SET... v$ DISK OEM OEM GUI GUI Recovery Recovery Manager Manager MML MML libobk.so libobk.so SQL*Net DBMS_BACKUP _RESTORE Oracle Oracle Oracle Oracle Oracle Oracle FIXED SBT_TAPE DB Recovery Manager RMAN Oracle8 Recovery Manager Oracle Recovery Manager Oracle RMAN DBMS_BACKUP_RESTORE DBMS_BACKUP_RESTORE Recovery Manager NOMOUNT MOUNT Oracle Enterprise Manager Oracle GUI Enterprise Manager OEM Recovery Manager OEM Backup Manager DB Agent Recovery Manager Recovery Manager DB Recovery Manager Recovery Manager 10

11 Oracle Recovery Manager DISK OS SBT_TAPE Oracle Recovery Manager Recovery 2 MMV Media Management Library MML Oracle Oracle $ORACLE_HOME/bin/oracle MML Sun Solstice Backup Database Module for Oracle DMO Business Suit for Oracle BMO DB 11

12 %setenv ORACLE_SID je803 %rman target system/manager rcvcat Recovery Manager: Production RMAN-06005: : JE803 RMAN-06008: RMAN> Recovery Manager target rcvcat cmdfile msglog Recovery Manager Recovery Manager nocatalog %rman target system/manager nocatalog CONNECT DB DB Recovery Manager CONNECT %rman nocatalog Recovery Manager: Production RMAN-06009: RMAN> CONNECT TARGET RMAN-06005: : JE803 RMAN> 12

13 RUN RUN { ALLOCATE CHANENL ch1 ch1 TYPE SBT_TAPE ; BACKUP FORMAT tbs_1_%d_%s_%p_%t (TABLESPACE tbs1); RELEASE CHANNEL ch1; } RUN{ ALLOCATE CHANNEL ch1 ch1 TYPE DISK; ALLOCATE CHANNEL ch2 ch2 TYPE 'SBT_TAPE'; RESTORE TABLESPACE tbs1; RECOVER TABLESPACE tbs1; } Recovery Manager RUN RUN... RUN ALLOCATE DISK OS SBT_TAPE BACKUP Oracle COPY FORMAT %d %d RELEASE CHANNEL 13

15 RUN RUN { ALLOCATE CHANENL ch1 ch1 TYPE DISK; BACKUP FORMAT /backup/%d_%s_%p_%t (TABLESPACE tbs1); RELEASE CHANNEL ch1; } Recovery Manager RUN RUN... RUN ALLOCATE DISK OS SBT_TAPE BACKUP Oracle COPY FORMAT %d &Tips RELEASE CHANNEL 15

16 1 RUN RUN { ALLOCATE ALLOCATE CHANENL CHANENL ch1 ch1 TYPE TYPE DISK; DISK; BACKUP BACKUP FORMAT FORMAT /backup/%d_%s_%p_%t (TABLESPACE tbs1); tbs1); RELEASE RELEASE CHANNEL CHANNEL ch1; ch1; } tbs Recovery Manager tbs1 tbs2 BACKUP FORMAT '/backup/%d_%s_%p_%t' (TABLESPACE tbs1,tbs2); tbs1 tbs2 BACKUP FORMAT '/backup/%d_%s_%p_%t' (TABLESPACE tbs1 TABLESPACE tbs2); 16

17 1 RUN RUN { ALLOCATE ALLOCATE CHANENL CHANENL ch1 ch1 TYPE TYPE DISK; DISK; SET SET LIMIT LIMIT CHANNEL CHANNEL KBYTES; KBYTES; BACKUP BACKUP FORMAT FORMAT /backup/%d_%s_%p_%t (TABLESPACE tbs1); tbs1); RELEASE RELEASE CHANNEL CHANNEL ch1; ch1; } tbs Recovery Manager SET LIMIT SET LIMIT CHANNEL ch1 nnnn KBYTES nnnn OS 1 17

18 DB DB DB SCN 18

19 RUN{ ALLOCATE CHANNEL ch1 ch1 TYPE 'SBT_TAPE'; BACKUP ARCHIVELOG ALL ALL DELETE INPUT FORMAT arc_%d_%s_%p_%t ; }

20 allocate allocate channel channel node_1 node_1 type type disk disk connect connect allocate allocate channel channel node_2 node_2 type type disk disk connect connect backup backup filesperset 1 format format 'df_%s_%p' 'df_%s_%p' (tablespace system, system, data1, data1, data2 data2 channel channel node_1) node_1) (tablespace data3, data3, data4 data4 channel channel node_2); node_2); run { allocate channel node_1 type disk connect 'internal/kernel@node_1'; allocate channel node_2 type disk connect 'internal/kernel@node_2'; backup filesperset 1 format 'df_%s_%p' (tablespace system, data1, data2 channel node_1) (tablespace data3, data4 channel node_2); backup filesperset 20 format 'al_%s_%p' (archivelog until time 'SYSDATE' thread 1 delete input channel node_1); (archivelog until time 'SYSDATE' thread 2 delete input channel node_2); release channel node_1; release channel node_2; } 20

21 31 level 0 level 2 level 1 level Oracle ARCHIEVLOG NOARCHIVELOG NOARCHIVELOG SHUTDOWN NORMAL IMMEDIATE 21

22 RUN { ALLOCATE CHANNEL ch1 TYPE 'SBT_TAPE'; BACKUP INCREMENTAL LEVEL 0 FORMAT 'inclv0_db_%s_%p_%t' (DATABASE); } 0 RUN{ ALLOCATE CHANNEL ch1 TYPE DISK; COPY LEVEL 0 DATAFILE '/oracle/data/rman_db/dbs/data2rman_db.dbf' TO '/oracle/backup/rman_db/data2rman_db.bak'; } 22

23 D E F G B C REDO level 0 level 2 level 2 level 2 level 1 level 2 level 2 A E F G REDO RUN{ ALLOCATE CHANNEL ch1 TYPE SBT_TAPE ; BACKUP INCREMENTAL LEVEL 2 (DATABASE FORMAT 'inclv2_db_%d_%s_%p_%t'); RELEASE CHANNEL ch1; } 23

24 D E F G A B C REDO level 0 level 2 level 2 level 2 level 1 level 2 level 2 A E G REDO CUMULATIVE BACKUP CUMULATIVE RUN{ ALLOCATE CHANNEL ch1 TYPE SBT_TAPE ; BACKUP INCREMENTAL LEVEL 2 CUMULATIVE (DATABASE FORMAT 'inclv2c_db_%d_%s_%p_%t'); RELEASE CHANNEL ch1; } 24

25 DB SCN SCN SCN SCN SCN SCN SCN 25

26 RUN{ ALLOCATE CHANNEL ch1 ch1 TYPE DISK; ALLOCATE CHANNEL ch2 ch2 TYPE 'SBT_TAPE'; RESTORE TABLESPACE tbs1; RECOVER TABLESPACE tbs1; } C D B A level 0 level 2 level 2 level 2 level 1 level 2 level 2 A E F G REDO E F G REDO Recovery Manager Recovery Manager RESTORE DB RUN RESTORE RECOVER RECOVER DB RECOVER Recovery Manager Recovery Manager 26

27 DB Recovery Manager RUN{ ALLOCATE CHANNEL ch1 TYPE DISK; COPY DATAFILE '/oracle/data/rman_db/dbs/data2rman_db.dbf' TO '/oracle/backup/rman_db/data2rman_db.bak'; } RUN{ ALLOCATE CHANNEL ch1 TYPE DISK; COPY DATAFILE 05 TO '/oracle/backup/rman_db/data2rman_db.bak'; } 27

28 RESTORE SWITCH DB Recovery Manager RESTORE SWITCH 2 SWITCH SQL ALTER DATABASE RENAME FILE SWITCH RESTORE RUN{ ALLOCATE CHANNEL ch1 TYPE DISK; RESTORE DATAFILE '/mnt3/dbs/tstrman.dbf'; RECOVER DATAFILE '/mnt3/dbs/tstrman.dbf'; SQL "ALTER DATABASE DATAFILE ''/mnt3/dbs/tstrman.dbf'' ONLINE"; } SWITCH RUN{ ALLOCATE CHANNEL ch1 TYPE DISK; SWITCH DATAFILE '/mnt3/dbs/tstrman.dbf' TO DATAFILECOPY '/mnt3/backkup/tstrman.dbf'; RECOVER DATAFILE '/mnt3/backkup/tetrman.dbf'; SQL "ALTER DATABASE DATAFILE ''/mnt3/backkup/testrman_db.dbf'' ONLINE"; } Recovery Manager SQL SQL SQL SQL '' 28

29 DB SWITCH

30 RMAN>CATALOG DATAFILECOPY '/backup/systemora803.dbf'; RMAN>CATALOG ARCHIVELOG '/backup/arch18.log'; Oracle8 Recovery Manager Oracle7 OS OS ALTER... BEGIN BACKUP BEGIN BACKUP REDO OS ALTER... END BACKUP Recovery Manager CATALOG OS OS Recovery Manager OS 30

31 Recovery Manager Server Manager ALTER TABLESPACE... BEGIN BACKUP REDO Recovery Manager REDO REDO Recovery Manager 31

32 OS Solaris OS 512bytes 2KB 4 OS 32

33 RUN{ ALLOCATE CHANNEL ch1 ch1 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch2 ch2 TYPE 'SBT_TAPE'; BACKUP FORMAT '%d_%s_%p_%t' (TABLESPACE data1) (TABLESPACE data2) (TABLESPACE data3) (TABLESPACE data4); }

34 RUN{ ALLOCATE CHANNEL c1 c1 TYPE disk; ALLOCATE CHANNEL c2 c2 TYPE disk; COPY DATAFILE TO TO /backups/copy_01.dbf, DATAFILE TO TO /backups/copy_02.dbf ; } RUN{ ALLOCATE CHANNEL c1 c1 TYPE disk; ALLOCATE CHANNEL c2 c2 TYPE disk; COPY DATAFILE TO TO /backups/copy_01.dbf ; COPY DATAFILE TO TO /backups/copy_02.dbf ; } Recovery Manager RUN... COPY COPY 34

36 Oracle7 Oracle8 Recovery Manager Recovery Manager Recovery Manager UNRECOVERABLE REPORT UNRECOVERABLE... REPORT OBSOLETE UNTIL TIME... n (REPORT NEED BACKUP DAYS n...) n REPORT NEED BACKUP INCREMENTAL n... 36

37 RMAN> RMAN> LIST LIST BACKUPSET BACKUPSET OF OF DATABASE; DATABASE; RMAN> RMAN> LIST LIST COPY COPY OF OF TABLESPACE TABLESPACE tbs1; tbs1; RMAN> RMAN> LIST LIST BACKUPSET BACKUPSET OF OF DATABASE DATABASE DEVICE DEVICE TYPE TYPE SBT_TAPE ; RMAN> RMAN> LIST LIST INCARNATION OF OF DATABASE; DATABASE; LIST BACKUPSET RMAN> LIST BACKUPSET OF DATABASE; RMAN-03022: : list RMAN-06230: RMAN-06231: File LV Ckp SCN Ckp RMAN-06232: RMAN-06233: Full RMAN-06233: Full RMAN-06233: Full RMAN-06233: Full RMAN-06233: Full LIST INCARNATION RMAN> LIST INCARNATION OF DATABASE; RMAN-03022: : list RMAN-06240: RMAN-06241: DB Inc DB DB ID CUR Reset SCN Reset RMAN-06242: RMAN-06243: CATALOG YES RMAN-06243: 1 2 RMAN_DB YES

38 RMAN> RMAN> REPORT REPORT UNRECOVERABLE DATABASE; DATABASE; REPORT UNRECOVERBLE SQL ALTER DATABASE CREATE DATAFILE REPORT UNRECOVERABLE UNRECOVERBLE NOLOGGING REPORT UNRECOVERABLE RMAN>REPORT UNRECOVERABLE DATABASE; RMAN-03022: : report RMAN-06250: RMAN-06251: File RMAN-06252: RMAN-06253: 6 full /test/mnt9/data/test1.dbf RMAN-06253: 9 full /test/mnt9/data/test4.dbf RMAN-06253: 10 full /test/mnt9/data/test5.dbf RMAN-06253: 11 full /test/mnt9/data/test6.dbf Oracle7 CREATE TABLE CREATE INDEX UNRECOVERABLE Oracle8 NOLOGGING UNRECOVERABLE" NOLOGGING 38

39 RMAN>REPORT OBSOLETE OBSOLETE UNTIL UNTIL TIME TIME "08/18/ :17:00"; 16:17:00"; REPORT OBSOLETE RMAN>REPORT OBSOLETE UNTIL TIME "1997/08/18 16:17:00"; RMAN-06280: RMAN-03022: : report RMAN-06281: Recid RMAN-06282: RMAN-06284: Backup Set RMAN-06285: Backup Piece /test/backups/bpi0_35_1 RMAN-06284: Backup Set RMAN-06285: Backup Piece /test/backups/bpi0t_36_1 REPORT Recovery Manager RUN REPORT OBSOLETE NLS_DATE_FORMAT REPORT OBSOLETE UNTIL TIME NLS_DATE_FORMAT UNTIL TIME NLS_DATE_FORMAT YYYY 4 %setenv NLS_DATE_FORMAT YYYY/MM/DD HH24:MI:SS 39

40 RMAN>REPORT NEED NEED BACKUP BACKUP DAYS DAYS 7 DATABASE; DATABASE; RMAN>REPORT NEED NEED BACKUP BACKUP INCREMENTAL 5 DATABASE; DATABASE; REPORT NEED BACKUP DAYS # 3 RMAN>REPORT NEED BACKUP DAYS 3 DATABASE; RMAN-03022: : report RMAN-06270: 3 RMAN-06271: File RMAN-06272: RMAN-06273: 1 4 /test/data/test1.dbf RMAN-06273: 2 4 /test/data/test2.dbf 40

42 RMAN>RESYNC CATALOG; CATALOG; RMAN>CATALOG DATAFILECOPY '/backup/systemora803.dbf'; RMAN>CATALOG ARCHIVELOG ARCHIVELOG '/backup/arch18.log'; Recovery Manager 2 Recovery Manager Recovery Manager RESYNC CATALOG REDO Recovery Manager Recovery Manager RESYNC OS Recovery Manager OS OS Recovery Manager 42

43 RMAN> RMAN> CHANGE CHANGE BACKUPPIECE '/mnt/backup/bk_1_1' UNCATALOG; UNCATALOG; RMAN> RMAN> CHANGE CHANGE DATAFILECOPY '/mnt/backup/data1.dbf' UNCATALOG; UNCATALOG; RMAN> RMAN> ALLOCATE ALLOCATE CHANNEL CHANNEL FOR FOR DELETE DELETE TYPE TYPE DISK; DISK; RMAN> RMAN> CHANGE CHANGE BACKUPPIECE '/mnt/backup/bk_1_1' DELETE; DELETE; RMAN> RMAN> CHANGE CHANGE DATAFILECOPY '/mnt/backup/data1.dbf' DELETE; DELETE; ALLOCATA CHANNEL FOR DELETE ALLOCATE CHANNEL... RUN... CHANGE... DELETE D LIST RMAN> LIST COPY OF TABLESPACE tbs1; RMAN-03022: : list RMAN-06210: RMAN-06211: File S Ckp SCN Ck RMAN-06212: RMAN-06213: D / up/b.bk RMAN-06213: A /bkup/tbs1.dbf 43

46 RMAN Oracle DB 2 Recovery Manager Recovery Manager Point-In-Time Point - in - Time Recovery Manager DB OS Recovery Manager OS 46

47 DB DB DB 10MB DB DB Oracle7 RDBMS 2. RECOVERY_CATALOG_OWNER catalog.sql CONNECT RESOURCE SVRMGR> CONNECT INTERNAL SVRMGR> CREATE USER rman IDENTIFIED BY rman 2> TEMPORARY TABLESPACE temp 3> DEFAULT TABLESPACE data 4> QUOTA UNLIMITED ON data; SVRMGR> GRANT RECOVERY_CATALOG_OWNER TO rman; 3. CATRMAN.SQL $ORACLE_HOME/admin/catrman.sql SVRMGR> CONNECT rman/rman 4. SQL*Net Recovery Manager SQL*Net tnsnames.ora listener.ora SQL*Net DB DB SQL*Net 5. Recovery Manager REGISTER DB RMAN>REGISTER DATABASE; 47

48 Solaris Solstice Backup Backup MML /usr/lib/libobk.so %cd %cd $ORACLE_HOME/rdbms/lib %make %make-f -f ins_rdbms.mk ioracle ioracle LLIBMM=/usr/lib/libobk.so Recovery Manager MML Oracle ORACLE_HOME/rdbms/README.doc Oracle MML OS Solaris ldd %cd $ORACLE_HOME/bin %ldd./oracle libobk.so => /usr/lib/libobk.so libnsl.so.1 => /usr/lib/libnsl.so.1 libsocket.so.1 => /usr/lib/libsocket.so.1 libdl.so.1 => /usr/lib/libdl.so.1 libc.so.1 => /usr/lib/libc.so.1 libaio.so.1 => /usr/lib/libaio.so.1 libm.so.1 => /usr/lib/libm.so.1 libintl.so.1 => /usr/lib/libintl.so.1 libmp.so.1 => /usr/lib/libmp.so.1 libw.so.1 => /usr/lib/libw.so.1 48

50 I/O SET LIMIT CHANNEL RUN READRATE DB_BLOCK_SIZE DB_FILE_DIRECT_IO_COUNT 64 DB_BLOCK_SIZE 50

51 RMAN RMAN DB DB RMAN RMAN DB DB 51

52 RMAN>RUN{ RMAN>RUN{ 2> 2> ALLOCATE ALLOCATE CHANNEL CHANNEL ch1 ch1 TYPE TYPE DISK; DISK; 3> 3> ALLOCATE ALLOCATE CHANNEL CHANNEL ch2 ch2 TYPE TYPE 'SBT_TAPE'; 4> 4> RESTORE RESTORE CONTROLFILE TO TO '/ '/ /bkrman_db.ctl'; 5> 5> REPLICATE REPLICATE CONTROLFILE FROM FROM '/ '/ /bkrman_db.ctl'; 6> 6> SQL SQL "ALTER "ALTER DATABASE DATABASE MOUNT"; MOUNT"; 7> 7> RESTORE RESTORE DATABASE; DATABASE; NOMOUNT NOMOUNT 2. RESTORE CONTROLFILE 3. REPLICATE CONTROLFILE REPLICATE... CONTROL_FILES 4. MOUNT RESETLOGS 7. Recovery Manager RESET DATABASE RESETLOGS DATABASE Recovery Manager RESETLOGS RMAN>RESET DATABASE; 8. RESETLOGS 52

53 OS SET LIMIT FORMAT Recovery Manager FORMAT %d %n 8 RMAN RMANxxxx %s %p %t %u 8 RMAN CHANGE... UNCATALOG CHANGE DATAFILECOPY '/oracle/backup/temprman_db.dbf' UNCATALOG; 53

54 LSM Oracle8.0.4 Oracle LSM Oracle LSM ( LSM Legato Networker LSM Legato Networker OS 4 16 Sony DTF, IBM Magster, Storage Tek Redwood, Amplex DST Oracle Enterprise Networker Manager 54

ORACLE RECOVERY MANAGER (RMAN) 10g: 再起動

ORACLE RECOVERY MANAGER (RMAN) 10g: Tammy Bednar, Oracle Oracle (DBA) Oracle Oracle Data Guard 1 Oracle Oracle Oracle Oracle Recovery Manager Oracle Database 10g Oracle Database 10g RECOVERY MANAGER Recovery