rman的备份，我们平时总是希望越快越好。 但是有时候，rman的备份会撑爆HBA卡的流量，严重影响生产系统。在一个大的cluster中，有17个db，当13个db发起rman备份的时候，主机上的HBA卡流量几乎被撑爆了，几乎所有的IO操作都不可进行了。 所以，我们要想办法让rman“慢”一些，减少 […]
各种备份方式简单比较
呵呵，用表格说明一下吧～
oracle备份和还原学习小结
oracle对数据的备份和还原提供了两种模式，一种是用户管理的备份和还原，另一种是利用rman进行备份和还原。 1.用户管理 1.1 用户管理的备份 1.1.1 关闭数据库的备份(整体冷备) 条件：允许停机 备份内容：所有的数据文件(v$datafile.name)、所有控制文件(v$control […]
undo表空间丢失之恢复
|
1 2 3 4 5 6 7 8 9 10 11 |
sys@ORALOCAL(10.1.19.11)> insert into hejianmin.kk values(222333); 已创建 1 行。 已用时间: 00: 00: 00.05 sys@ORALOCAL(10.1.19.11)> shutdown abort; ORACLE 例程已经关闭。 sys@ORALOCAL(10.1.19.11)> exit; 从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production中断开 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
C:\Documents and Settings\Administrator>d: D:\>cd D:\oracle\oradata\oralocal D:\oracle\oradata\oralocal>ls CONTROL01.CTL DRSYS01.DBF REDO0201.LOG REDO101.LOG REDO301.LOG TS_DATA_USER01.DBF TS_UNDO_02.DBF CONTROL02.CTL EXAMPLE01.DBF REDO0202.LOG REDO102.LOG REDO302.LOG TS_INDX_01.DBF XDB01.DBF CONTROL03.CTL ODM01.DBF REDO0301.LOG REDO201.LOG SYSTEM01.DBF TS_RMAN_01.DBF CWMLITE01.DBF PERFSTAT.DBF REDO0302.LOG REDO202.LOG TEMP.DBF TS_UNDO_01.DBF D:\oracle\oradata\oralocal>rm TS_UNDO_01.DBF D:\oracle\oradata\oralocal>set nls_lang=american D:\oracle\oradata\oralocal>sqlplus "/ as sysdba" |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 |
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jul 5 13:48:49 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to an idle instance. > startup ORACLE instance started. Total System Global Area 133765984 bytes Fixed Size 453472 bytes Variable Size 79691776 bytes Database Buffers 50331648 bytes Redo Buffers 3289088 bytes Database mounted. ORA-01157: cannot identify/lock data file 2 - see DBWR trace file ORA-01110: data file 2: 'D:\ORACLE\ORADATA\ORALOCAL\TS_UNDO_01.DBF' > alter database datafile 'D:\ORACLE\ORADATA\ORALOCAL\TS_UNDO_01.DBF' offline drop; Database altered. Elapsed: 00:00:00.02 > alter database open; Database altered. Elapsed: 00:00:18.00 > create undo tablespace UNDOTBS03 datafile 'D:\ORACLE\ORADATA\ORALOCAL\TS_UNDO_03.dbf' size 100M; Tablespace created. Elapsed: 00:00:09.08 > alter system set undo_tablespace=UNDOTBS03 scope=spfile; System altered. Elapsed: 00:00:00.01 > shutdown immediate; ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2: 'D:\ORACLE\ORADATA\ORALOCAL\TS_UNDO_01.DBF' > select status from v$instance; select status from v$instance * ERROR at line 1: ORA-00600: internal error code, arguments: [1236], [], [], [], [], [], [], [] Elapsed: 00:00:02.00 > shutdown immediate; ORA-00600: internal error code, arguments: [1236], [], [], [], [], [], [], [] > startup; ORA-01081: cannot start already-running ORACLE - shut it down first > shutdown abort; ORACLE instance shut down. > startup ORACLE instance started. Total System Global Area 133765984 bytes Fixed Size 453472 bytes Variable Size 79691776 bytes Database Buffers 50331648 bytes Redo Buffers 3289088 bytes Database mounted. Database opened. > select SEGMENT_NAME,STATUS from dba_rollback_segs; SEGMENT_NAME STATUS ------------------------------ ---------------- SYSTEM ONLINE _SYSSMU1$ OFFLINE _SYSSMU2$ NEEDS RECOVERY _SYSSMU3$ NEEDS RECOVERY _SYSSMU4$ NEEDS RECOVERY _SYSSMU5$ NEEDS RECOVERY _SYSSMU6$ NEEDS RECOVERY _SYSSMU7$ NEEDS RECOVERY _SYSSMU8$ NEEDS RECOVERY _SYSSMU9$ NEEDS RECOVERY _SYSSMU10$ NEEDS RECOVERY _SYSSMU11$ OFFLINE _SYSSMU12$ OFFLINE _SYSSMU13$ OFFLINE _SYSSMU14$ OFFLINE _SYSSMU15$ OFFLINE _SYSSMU16$ OFFLINE _SYSSMU17$ OFFLINE _SYSSMU18$ OFFLINE _SYSSMU19$ OFFLINE _SYSSMU20$ NEEDS RECOVERY _SYSSMU21$ ONLINE _SYSSMU22$ ONLINE _SYSSMU23$ ONLINE _SYSSMU24$ ONLINE _SYSSMU25$ ONLINE _SYSSMU26$ ONLINE _SYSSMU27$ ONLINE _SYSSMU28$ ONLINE _SYSSMU29$ ONLINE _SYSSMU30$ ONLINE 31 rows selected. Elapsed: 00:00:02.00 > drop tablespace TS_UNDO_01 including contents and datafiles; drop tablespace TS_UNDO_01 including contents and datafiles * ERROR at line 1: ORA-01548: active rollback segment '_SYSSMU2$' found, terminate dropping tablespace Elapsed: 00:00:02.01 > shutdown immediate; ORA-00376: file 2 cannot be read at this time ORA-01110: data file 2: 'D:\ORACLE\ORADATA\ORALOCAL\TS_UNDO_01.DBF' > shutdown abort; ORA-00600: internal error code, arguments: [1236], [], [], [], [], [], [], [] >exit |
vi INIToralocal.ORA *.aq_tm_processes=1 *.backgroun […]
rman 学习笔记－rman qucik review
今天粗看了一遍《Recovery Manager Quick Reference》，又了解一些以前不知道的rman（Recovery Manager）的特性和一些还原的步骤。 1、rman也可有日志：rman nocatalog target /log=’rman.log’ […]