使用RMAN迁移文件系统数据库到ASM

逃离我推掉我的手 2022-05-15 06:28 145阅读 0赞

*--==================================*

*--* *使用RMAN**迁**移文件系**统数**据**库**到**ASM*

*--==================================*

在实际的工作过程中，由于ASM磁盘管理的便利性，因此很多时候需要将文件系统的数据库迁移到ASM，本文演示了如何将文件系统数据库迁移到ASM实例。

有关如何创建ASM实例及ASM磁盘管理请参考

[创建ASM实例及数据库][ASM]

[ASM 磁盘组及磁盘的管理][ASM 1]

[使用 ASMCMD 工具管理ASM实例][ASMCMD _ASM]

一、主要步骤(假定ASM实例已创建)

1.计算目标数据库(文件系统)的大小

2.根据目标数据库的大小，为新ASM数据库(辅助数据库)准备可用磁盘空间

3.为辅助数据库配置初始化参数文件，密码文件，创建目录

4.备份目标数据库

5.迁移目标数据库到辅助数据库

二、实施迁移

本次迁移在同一台主机实现，因此采用不同的ORACLE\_SID

环境：Oracle Linux 5.4 \+ Oracle 10g R2

目标数据库：orcl

辅助数据库：orclasm

1.计算目标数据库(文件系统)的大小

SQL> show parameter db\_name

NAMETYPEVALUE

*------------------------------------ ----------- ------------------------------*

db\_name string orcl

SQL> select \* from v$version whererownum<2;

BANNER

*----------------------------------------------------------------*

Oracle Database10g Enterprise Edition Release 10.2.0.4.0 - Prod

SQL> selectsum(bytes)/1024/1024 ||'MB'from dba\_segments;

SUM(BYTES)/1024/1024||'MB'

*------------------------------------------*

1195.5MB

2.为辅助数据库准备可用空间，下面显示DG1中有3016MB可用空间，可以满足迁移的需要

ASMCMD> ls -s

Sector Block AU Total\_MB Free\_MB Req\_mir\_free\_MB Usable\_file\_MB Offline\_disks Name

5124096104857661346032030160 DG1/

5124096104857620471997019970 REV/

3.配置辅助数据库

a.启动目标数据库，并为目标数据库创建pfile

\[oracle@oradb ~\]$ echo $ORACLE\_SID

orcl

\[oracle@oradb ~\]$ sqlplus / assysdba

idle> startup

sys@ORCL> createpfilefromspfile;

b.复制目标数据库的pfile来生成辅助数据库的pfile并对其进行修改

\[oracle@oradb dbs\]$ cd $ORACLE\_HOME/dbs

\[oracle@oradb dbs\]$ cp initorcl.ora initorclasm.ora

修改initorclasm.ora

对文件中所有的orcl使用替换命令替换为orclasm(使用vi工具 :%s/orcl/orclasm/g来替换)

修改控制文件为1个(磁盘DG1使用了normal redundancy)，路径为'+DG1/orclasm/controlfile/'*--**使用ASM**应**注意目**录结构**的**变**化*

修改db\_recovery\_file\_dest路径为'+REV'

修改log\_archive\_dest\_1路径为'LOCATION=+REV/orclasm'

修改db\_create\_file\_dest路径为'+DG1'

增加下列参数(恢复完毕后清除)

\*.db\_file\_name\_convert=("orcl","orclasm")

\*.log\_file\_name\_convert=("orcl","orclasm")

下面列出发生变化的几个重要参数

\*.audit\_file\_dest='/u01/app/oracle/admin/orclasm/adump'

\*.background\_dump\_dest='/u01/app/oracle/admin/orclasm/bdump'

\*.control\_files='+DG1/orclasm/controlfile/control01.ctl'

\*.core\_dump\_dest='/u01/app/oracle/admin/orclasm/cdump'

\*.db\_name='orclasm'

\*.db\_recovery\_file\_dest='+REV/orclasm'

\*.log\_archive\_dest\_1='LOCATION=+REV/orclasm'

\*.user\_dump\_dest='/u01/app/oracle/admin/orclasm/udump'

\*.db\_create\_file\_dest='+DG1'

\*.db\_file\_name\_convert=("orcl","orclasm")

\*.log\_file\_name\_convert=("orcl","orclasm")

c.根据刚刚修改过的参数创建目录

\[oracle@oradb ~\]$ mkdir -p $ORACLE\_BASE/admin/orclasm/\{a,b,c,u\}dump

\[oracle@oradb ~\]$ ls $ORACLE\_BASE/admin/orclasm

adump bdump cdump udump

d.创建密码文件

\[oracle@oradb dbs\]$ orapwd file=$ORACLE\_HOME/dbs/orapworclasm password=oracle entries=8

4.备份目标数据库

a.目标数据库应处于归档模式下

SQL> selectname,log\_mode from v$database;

NAME LOG\_MODE

*--------- ------------*

ORCL ARCHIVELOG

b.连接到RMAN并进行备份，此处使用了非catalog方式

\[oracle@oradb ~\]$ uniread rman target sys/oracle@orcl nocatalog

RMAN> crosscheck archivelogall; *--**校**验归档**日志*

RMAN> delete expired archivelogall; *--**删**除**无效的**归档**日志*

RMAN> report obsolete;

RMAN> delete noprompt obsolete; *--**删**除**废**弃的**备份*

RMAN> show channel; *--**查**看缺省的**备份**路**径*

RMAN configuration parameters are:

CONFIGURE CHANNEL DEVICE TYPEDISK FORMAT '/u01/bk/orcl/data\_%d\_%U';

RMAN> showcontrolfile autobackup; *--**查**看控制文件的自**动备份启**用情**况*

using target database control fileinsteadofrecovery catalog

RMAN configuration parameters are:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN> showcontrolfile autobackup format; *--**查**看控制文件的**备份**路**径**、格式*

RMAN configuration parameters are:

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPEDISKTO'/u01/bk/orcl/auto\_ctl\_%d\_%F';

RMAN> run\{*--**对**目**标数**据**库进**行**备份**，此**备份为**0**级**增量包含了**归档**日志，控制文件**spfile**将**自**动备份*

2> allocate channel ch1 device typedisk;

3> backupas compressed backupset

4> incremental level0database format '/u01/bk/orcl/data\_%d\_%U'

5> plus archivelog format '/u01/bk/orcl/bk\_lg\_%U'

6> tag='Inc0\_log';

7> release channel ch1;\}

5.迁移目标数据到ASM

a.查看目标数据库的SEQUENCE，当前为10，便于恢复时指定SEQUENCE

SQL> select \* from v$log;

GROUP\# THREAD\# SEQUENCE\# BYTES MEMBERS ARC STATUS FIRST\_CHANGE\# FIRST\_TIM

*---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------*

119524288001YES ACTIVE 52044530\-OCT-10

2110524288001NOCURRENT52058530\-OCT-10

b.查看目标数据库的数据文件的相关信息，后续需要为datafile指定文件名

RMAN> reportschema;

Reportofdatabaseschema

ListofPermanentDatafiles

===========================

FileSize(MB) Tablespace RB segs DatafileName

*---- -------- -------------------- ------- ------------------------*

1480SYSTEM \*\*\* /u01/app/oracle/oradata/orcl/system01.dbf

225 UNDOTBS1 \*\*\* /u01/app/oracle/oradata/orcl/undotbs01.dbf

3240SYSAUX \*\*\* /u01/app/oracle/oradata/orcl/sysaux01.dbf

45USERS \*\*\* /u01/app/oracle/oradata/orcl/users01.dbf

5100 EXAMPLE \*\*\* /u01/app/oracle/oradata/orcl/example01.dbf

ListofTemporary Files

=======================

FileSize(MB) TablespaceMaxsize(MB) TempfileName

*---- -------- -------------------- ----------- --------------------*

120 TEMP 32767 /u01/app/oracle/oradata/orcl/temp01.dbf

c.查看asm实例是否已正常提供服务，以及磁盘的状态并启动新的orclasm实例

SQL> show parameter instance\_name

NAMETYPEVALUE

*------------------------------------ ----------- ------------------------------*

instance\_name string \+ASM

SQL> select group\_number,name,state,type,total\_mb,free\_mb,usable\_file\_mb from v$asm\_diskgroup;

GROUP\_NUMBER NAME STATE TYPE TOTAL\_MB FREE\_MB USABLE\_FILE\_MB

*------------ ------------------------------ ----------- ------ ---------- ---------- --------------*

1 DG1 MOUNTED NORMAL613460323016

2 REV MOUNTED EXTERN 204719971997

d.启动辅助数据库到nomount状态

\[oracle@oradb ~\]$ export ORACLE\_SID=orclasm

\[oracle@oradb ~\]$ sqlplus / assysdba

idle> startup nomount

ORACLE instance started.

e.使用RMAN连接到目标数据库和辅助数据库来完成迁移

\[oracle@oradb dbs\]$ rman auxiliary / target sys/redhat@orcl

connected to target database: ORCL (DBID=1263182651)

connected to auxiliary database: ORCLASM (not mounted)

RMAN> run \{

2> allocate auxiliary channel ach1 device typedisk;

3> setuntilsequence10thread1;

4> set newname fordatafile1to'+DG1';

5> set newname fordatafile2to'+DG1';

6> set newname fordatafile3to'+DG1';

7> set newname fordatafile4to'+DG1';

8> set newname fordatafile5to'+DG1';

9> set newname fortempfile1to'+DG1';

10> duplicate target databaseto orclasm logfile

11> group1('+DG1') size5m reuse,

12> group2('+DG1') size5m reuse;

13> \}

contentsofMemory Script:

Alterclonedatabaseopenresetlogs;

executing Memory Script

database opened

Finished Duplicate Db at30\-OCT-10

6.后续处理

a.查看数据库状态并关闭数据库

\[oracle@oradb ~\]$ export ORACLE\_SID=orclasm

\[oracle@oradb ~\]$ sqlplus / assysdba

SQL> selectname,open\_mode from v$database;

NAME OPEN\_MODE

*--------- ----------*

ORCLASM READWRITE

SQL> shutdownimmediate;

b.使用vi工具编辑initorclasm.ora

清除下列参数

\*.db\_file\_name\_convert=("orcl","orclasm")

\*.log\_file\_name\_convert=("orcl","orclasm")

c.启动数据库并创建spfile

SQL> startup

SQL> createspfilefrompfile;

SQL> startup force; *--**如果是生**产库**建**议**先**shutdown immediate,**然后startup*

7.验证迁移结果

SQL> show parameter db\_name

NAMETYPEVALUE

*------------------------------------ ----------- ------------------------------*

db\_name string orclasm

SQL> col name format a60

SQL> selectname,status from v$datafile;

NAME STATUS

*------------------------------------------------------------ -------*

\+DG1/orclasm/datafile/system.256.752170937 SYSTEM

\+DG1/orclasm/datafile/undotbs1.259.752170937 ONLINE

\+DG1/orclasm/datafile/sysaux.257.752170937 ONLINE

\+DG1/orclasm/datafile/users.260.752170937 ONLINE

\+DG1/orclasm/datafile/example.258.752170937 ONLINE

SQL> select \* from v$log;

GROUP\# THREAD\# SEQUENCE\# BYTES MEMBERS ARC STATUS FIRST\_CHANGE\# FIRST\_TIM

*---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------*

11552428802YES INACTIVE 56371627\-MAY-11

21652428802NOCURRENT58398527\-MAY-11

SQL> select \* from v$logfile;

GROUP\# STATUS TYPEMEMBER IS\_

*---------- ------- ------- -------------------------------------------------- ---*

2ONLINE \+DG1/orclasm/onlinelog/group\_2.263.752171103 NO

1 STALE ONLINE \+DG1/orclasm/onlinelog/group\_1.262.752171103 NO

1 STALE ONLINE \+REV/orclasm/onlinelog/group\_1.256.752171103 YES

2ONLINE \+REV/orclasm/onlinelog/group\_2.257.752171105 YES

SQL> select file\#,creation\_change\#, status,enabled,bytes,namefrom v$tempfile;

FILE\# CREATION\_CHANGE\# STATUS ENABLED BYTES NAME

*---------- ---------------- ------- ---------- ---------- --------------------------------------------------*

1464714ONLINEREADWRITE20971520 \+DG1/orclasm/tempfile/temp.264.752171113

*--**如果在使用duplicate**时没**有生成**tempfile**文件，可以使用下面的方式**来**手**动**添加**tempfile**文件。*

altertablespace temp addtempfile'+DG1'size100m autoextendoff;

*--**可以添加**归档**目**录**，**并**修改一下**归档**路**径*

*--**连**接到**ASM**实**例**创**建**归档**目**录*

SQL> select instance\_name,status from v$instance;

INSTANCE\_NAME STATUS

*------------------------------ ------------*

\+ASM STARTED

SQL> alterdiskgroup REV adddirectory'+REV/orclasm/arch';

Diskgroup altered.

*--**在orclasm**实**例中修改**归档**路**径*

SQL> select instance\_name,status from v$instance;

INSTANCE\_NAME STATUS

*---------------- ------------*

orclasm OPEN

SQL> altersystemset log\_archive\_dest\_1='LOCATION=+REV/orclasm/arch';

System altered.

SQL> selectnamefrom v$archived\_log whererownum<2orderby stamp;

NAME

*--------------------------------------------------*

\+REV/orclasm/1\_1\_752171102.arc

三、快捷参考

有关性能优化请参考

[Oracle 硬解析与软解析][Oracle]

[共享池的调整与优化(Shared pool Tuning)][Shared pool Tuning]

[Buffer cache 的调整与优化(一)][Buffer cache]

[Oracle 表缓存(caching table)的使用][Oracle _caching table]

有关ORACLE体系结构请参考

[Oracle 表空间与数据文件][Oracle 1]

[Oracle 密码文件][Oracle 2]

[Oracle 参数文件][Oracle 3]

[Oracle 联机重做日志文件(ONLINE LOG FILE)][Oracle _ONLINE LOG FILE]

[Oracle 控制文件(CONTROLFILE)][Oracle _CONTROLFILE]

[Oracle 归档日志][Oracle 4]

[Oracle 回滚(ROLLBACK)和撤销(UNDO)][Oracle _ROLLBACK_UNDO]

[Oracle 数据库实例启动关闭过程][Oracle 5]

[Oracle 10g SGA 的自动化管理][Oracle 10g SGA]

[Oracle 实例和Oracle数据库(Oracle体系结构)][Oracle _Oracle_Oracle]

有关闪回特性请参考

[Oracle 闪回特性(FLASHBACK DATABASE)][Oracle _FLASHBACK DATABASE]

[Oracle 闪回特性(FLASHBACK DROP & RECYCLEBIN)][Oracle _FLASHBACK DROP _ RECYCLEBIN]

[Oracle 闪回特性(Flashback Query、Flashback Table)][Oracle _Flashback Query_Flashback Table]

[Oracle 闪回特性(Flashback Version、Flashback Transaction)][Oracle _Flashback Version_Flashback Transaction]

有关基于用户管理的备份和备份恢复的概念请参考

[Oracle 冷备份][Oracle 6]

[Oracle 热备份][Oracle 7]

[Oracle 备份恢复概念][Oracle 8]

[Oracle 实例恢复][Oracle 9]

[Oracle 基于用户管理恢复的处理][Oracle 10](详细描述了介质恢复及其处理)

[SYSTEM 表空间管理及备份恢复][SYSTEM]

[SYSAUX表空间管理及恢复][SYSAUX]

有关RMAN的备份恢复与管理请参考

[RMAN 概述及其体系结构][RMAN]

[RMAN 配置、监控与管理][RMAN 1]

[RMAN 备份详解][RMAN 2]

[RMAN 还原与恢复][RMAN 3]

[RMAN catalog 的创建和使用][RMAN catalog]

[基于catalog 创建RMAN存储脚本][catalog _RMAN]

[基于catalog 的RMAN 备份与恢复][catalog _RMAN 1]

RMAN 备份路径困惑(使用plus archivelog时)

有关ORACLE故障请参考

[ORA-32004 的错误处理][ORA-32004]

[ORA-01658 错误][ORA-01658]

[CRS-0215 错误处理][CRS-0215]

[ORA-00119，ORA-00132 错误处理][ORA-00119_ORA-00132]

[又一例SPFILE设置错误导致数据库无法启动][SPFILE]

[对参数FAST\_START\_MTTR\_TARGET = 0 的误解及设定][FAST_START_MTTR_TARGET _ 0]

[SPFILE 错误导致数据库无法启动(ORA-01565)][SPFILE _ORA-01565]

有关ASM请参考

[创建ASM实例及ASM数据库][ASM]

[ASM 磁盘、目录的管理][ASM 1]

[使用 ASMCMD 工具管理ASM目录及文件][ASMCMD _ASM]

有关SQL/PLSQL请参考

[SQLPlus 常用命令][SQLPlus]

[替代变量与SQL\*Plus环境设置][SQL_Plus]

[使用Uniread实现SQLplus翻页功能][Uniread_SQLplus]

[SQL 基础*-->SELECT* *查询*][SQL _--_SELECT_]

[SQL 基础*--> NEW\_VALUE* *的使用*][SQL _--_ NEW_VALUE_]

[SQL 基础*-->* *集合**运**算(UNION* *与UNION ALL)*][SQL _--_ _UNION_ _UNION ALL]

[SQL 基础*-->* *常用函**数*][SQL _--_]

[SQL 基础*-->* *视图(CREATE VIEW)*][SQL _--_ _CREATE VIEW]

[SQL 基础*-->* *创**建和管理表*][SQL _--_ 1]

[SQL 基础*-->* *多表**查询*][SQL _--_ 2]

[SQL 基础*-->* *过滤**和排序*][SQL _--_ 3]

[SQL 基础*-->* *子**查询*][SQL _--_ 4]

[SQL 基础*-->* *分**组与**分**组**函**数*][SQL _--_ 5]

[SQL 基础*-->* *层**次化**查询(START BY ... CONNECT BY PRIOR)*][SQL _--_ _START BY ... CONNECT BY PRIOR]

[SQL 基础*--> ROLLUP**与CUBE**运**算符**实现数**据**汇总*][SQL _--_ ROLLUP_CUBE]

[PL/SQL *-->* *游**标*][PL_SQL _--_]

[PL/SQL *-->* *异**常**处**理(Exception)*][PL_SQL _--_ _Exception]

[PL/SQL *-->* *语**言基**础*][PL_SQL _--_ 1]

[PL/SQL *-->* *流程控制*][PL_SQL _--_ 2]

[PL/SQL *--> PL/SQL**记录*][PL_SQL _--_ PL_SQL]

[PL/SQL *-->* *包的**创**建**与**管理*][PL_SQL _--_ 3]

[PL/SQL *-->* *隐**式游**标(SQL%FOUND)*][PL_SQL _--_ _SQL_FOUND]

[PL/SQL *-->* *包重**载**、初始化*][PL_SQL _--_ 4]

[PL/SQL *--> DBMS\_DDL**包的使用*][PL_SQL _--_ DBMS_DDL]

[PL/SQL *--> DML* *触发**器*][PL_SQL _--_ DML_]

[PL/SQL *--> INSTEAD OF* *触发**器*][PL_SQL _--_ INSTEAD OF_]

[PL/SQL *-->* *存**储过**程*][PL_SQL _--_ 5]

[PL/SQL *-->* *函**数*][PL_SQL _--_ 6]

[PL/SQL *-->* *动态SQL*][PL_SQL _--_ _SQL]

[PL/SQL *-->* *动态SQL**的常**见错误*][PL_SQL _--_ _SQL 1]

有关ORACLE其它特性

[Oracle 常用目录结构(10g)][Oracle _10g]

[使用OEM,SQL\*Plus,iSQL\*Plus 管理Oracle实例][OEM_SQL_Plus_iSQL_Plus _Oracle]

[日志记录模式(LOGGING 、FORCE LOGGING 、NOLOGGING)][LOGGING _FORCE LOGGING _NOLOGGING]

[表段、索引段上的LOGGING与NOLOGGING][LOGGING_NOLOGGING]

[Oralce OMF 功能详解][Oralce OMF]

[Oracle 用户、对象权限、系统权限][Oracle 11]

[Oracle 角色、配置文件][Oracle 12]

[Oracle 分区表][Oracle 13]

[Oracle 外部表][Oracle 14]

[使用外部表管理Oracle 告警日志(ALAERT\_$SID.LOG)][Oracle _ALAERT_SID.LOG]

[簇表及簇表管理(Index clustered tables)][Index clustered tables]

[数据泵 EXPDP 导出工具的使用][EXPDP]

[数据泵 IMPDP 导入工具的使用][IMPDP]

[导入导出 Oracle 分区表数据][Oracle 15]

[SQL\*Loader使用方法][SQL_Loader]

[启用用户进程跟踪][Link 1]

[配置非默认端口的动态服务注册][Link 2]

[配置ORACLE 客户端连接到数据库][ORACLE]

[system sys，sysoper sysdba 的区别][system sys_sysoper sysdba]

[ORACLE\_SID、DB\_NAME、INSTANCE\_NAME、DB\_DOMIAN、GLOBAL\_NAME][ORACLE_SID_DB_NAME_INSTANCE_NAME_DB_DOMIAN_GLOBAL_NAME]

[Oracle 补丁全集 (Oracle 9i 10g 11g Path)][Oracle _ _Oracle 9i 10g 11g Path]

[Oracle 10.2.0.1 升级到 10.2.0.4][Oracle 10.2.0.1 _ 10.2.0.4]

[Oracle 彻底 kill session][Oracle _ kill session]

[ASM]: http://blog.csdn.net/robinson_0612/archive/2010/12/16/6080659.aspx
[ASM 1]: http://blog.csdn.net/robinson_0612/archive/2011/01/13/6134071.aspx
[ASMCMD _ASM]: http://blog.csdn.net/robinson_0612/archive/2011/01/13/6134163.aspx
[Oracle]: http://blog.csdn.net/robinson_0612/archive/2011/02/19/6195483.aspx
[Shared pool Tuning]: http://blog.csdn.net/robinson_0612/archive/2011/02/25/6208268.aspx
[Buffer cache]: http://blog.csdn.net/robinson_0612/archive/2011/02/25/6208594.aspx
[Oracle _caching table]: http://blog.csdn.net/robinson_0612/archive/2011/03/06/6226767.aspx
[Oracle 1]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611738.aspx
[Oracle 2]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611672.aspx
[Oracle 3]: http://blog.csdn.net/robinson_0612/archive/2010/05/05/5559174.aspx
[Oracle _ONLINE LOG FILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/20/5749556.aspx
[Oracle _CONTROLFILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/15/5737527.aspx
[Oracle 4]: http://blog.csdn.net/robinson_0612/archive/2010/08/03/5784713.aspx
[Oracle _ROLLBACK_UNDO]: http://blog.csdn.net/robinson_0612/archive/2010/07/13/5731158.aspx
[Oracle 5]: http://blog.csdn.net/robinson_0612/archive/2010/04/29/5542983.aspx
[Oracle 10g SGA]: http://blog.csdn.net/robinson_0612/archive/2010/04/27/5534832.aspx
[Oracle _Oracle_Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529239.aspx
[Oracle _FLASHBACK DATABASE]: http://blog.csdn.net/robinson_0612/archive/2010/12/27/6100429.aspx
[Oracle _FLASHBACK DROP _ RECYCLEBIN]: http://blog.csdn.net/robinson_0612/archive/2010/12/29/6105327.aspx
[Oracle _Flashback Query_Flashback Table]: http://blog.csdn.net/robinson_0612/archive/2011/01/02/6112607.aspx
[Oracle _Flashback Version_Flashback Transaction]: http://blog.csdn.net/robinson_0612/archive/2011/01/02/6112981.aspx
[Oracle 6]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791597.aspx
[Oracle 7]: http://blog.csdn.net/robinson_0612/archive/2010/08/16/5816012.aspx
[Oracle 8]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791585.aspx
[Oracle 9]: http://blog.csdn.net/robinson_0612/archive/2010/07/27/5768233.aspx
[Oracle 10]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041217.aspx
[SYSTEM]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041207.aspx
[SYSAUX]: http://blog.csdn.net/robinson_0612/archive/2010/08/13/5810732.aspx
[RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032525.aspx
[RMAN 1]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032597.aspx
[RMAN 2]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032739.aspx
[RMAN 3]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041247.aspx
[RMAN catalog]: http://blog.csdn.net/robinson_0612/archive/2010/11/29/6043649.aspx
[catalog _RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/12/13/6073020.aspx
[catalog _RMAN 1]: http://blog.csdn.net/robinson_0612/archive/2010/12/13/6073069.aspx
[ORA-32004]: http://blog.csdn.net/robinson_0612/archive/2011/02/19/6195475.aspx
[ORA-01658]: http://blog.csdn.net/robinson_0612/archive/2011/03/14/6249202.aspx
[CRS-0215]: http://blog.csdn.net/robinson_0612/archive/2011/04/05/6303583.aspx
[ORA-00119_ORA-00132]: http://blog.csdn.net/robinson_0612/archive/2011/05/05/6396989.aspx
[SPFILE]: http://blog.csdn.net/robinson_0612/archive/2010/08/03/5784736.aspx
[FAST_START_MTTR_TARGET _ 0]: http://blog.csdn.net/robinson_0612/archive/2010/08/02/5782516.aspx
[SPFILE _ORA-01565]: http://blog.csdn.net/robinson_0612/archive/2010/07/29/5774795.aspx
[SQLPlus]: http://blog.csdn.net/robinson_0612/archive/2010/04/06/5454382.aspx
[SQL_Plus]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084376.aspx
[Uniread_SQLplus]: http://blog.csdn.net/robinson_0612/archive/2010/03/30/5431655.aspx
[SQL _--_SELECT_]: http://blog.csdn.net/robinson_0612/archive/2010/04/15/5487668.aspx
[SQL _--_ NEW_VALUE_]: http://blog.csdn.net/robinson_0612/archive/2011/02/18/6192944.aspx
[SQL _--_ _UNION_ _UNION ALL]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611716.aspx
[SQL _--_]: http://blog.csdn.net/robinson_0612/archive/2010/04/16/5495170.aspx
[SQL _--_ _CREATE VIEW]: http://blog.csdn.net/robinson_0612/archive/2010/05/28/5630426.aspx
[SQL _--_ 1]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5689199.aspx
[SQL _--_ 2]: http://blog.csdn.net/robinson_0612/archive/2010/05/06/5563199.aspx
[SQL _--_ 3]: http://blog.csdn.net/robinson_0612/archive/2010/04/15/5487992.aspx
[SQL _--_ 4]: http://blog.csdn.net/robinson_0612/archive/2010/05/14/5592002.aspx
[SQL _--_ 5]: http://blog.csdn.net/robinson_0612/archive/2010/05/05/5559110.aspx
[SQL _--_ _START BY ... CONNECT BY PRIOR]: http://blog.csdn.net/robinson_0612/archive/2010/05/22/5616877.aspx
[SQL _--_ ROLLUP_CUBE]: http://blog.csdn.net/robinson_0612/archive/2010/06/01/5640031.aspx
[PL_SQL _--_]: http://blog.csdn.net/robinson_0612/archive/2010/12/15/6078622.aspx
[PL_SQL _--_ _Exception]: http://blog.csdn.net/robinson_0612/archive/2010/12/16/6080119.aspx
[PL_SQL _--_ 1]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063399.aspx
[PL_SQL _--_ 2]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063422.aspx
[PL_SQL _--_ PL_SQL]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084390.aspx
[PL_SQL _--_ 3]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084475.aspx
[PL_SQL _--_ _SQL_FOUND]: http://blog.csdn.net/robinson_0612/archive/2010/12/22/6092066.aspx
[PL_SQL _--_ 4]: http://blog.csdn.net/robinson_0612/archive/2010/12/22/6092097.aspx
[PL_SQL _--_ DBMS_DDL]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098248.aspx
[PL_SQL _--_ DML_]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098258.aspx
[PL_SQL _--_ INSTEAD OF_]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098263.aspx
[PL_SQL _--_ 5]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063434.aspx
[PL_SQL _--_ 6]: http://blog.csdn.net/robinson_0612/archive/2010/12/11/6069531.aspx
[PL_SQL _--_ _SQL]: http://blog.csdn.net/robinson_0612/archive/2011/01/05/6118010.aspx
[PL_SQL _--_ _SQL 1]: http://blog.csdn.net/robinson_0612/archive/2011/01/05/6118049.aspx
[Oracle _10g]: http://blog.csdn.net/robinson_0612/archive/2010/05/29/5633093.aspx
[OEM_SQL_Plus_iSQL_Plus _Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529260.aspx
[LOGGING _FORCE LOGGING _NOLOGGING]: http://blog.csdn.net/robinson_0612/archive/2011/01/12/6130866.aspx
[LOGGING_NOLOGGING]: http://blog.csdn.net/robinson_0612/archive/2011/01/12/6131176.aspx
[Oralce OMF]: http://blog.csdn.net/robinson_0612/archive/2010/04/12/5478323.aspx
[Oracle 11]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5688875.aspx
[Oracle 12]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5688997.aspx
[Oracle 13]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925572.aspx
[Oracle 14]: http://blog.csdn.net/robinson_0612/archive/2010/12/15/6078481.aspx
[Oracle _ALAERT_SID.LOG]: http://blog.csdn.net/robinson_0612/archive/2011/02/18/6192979.aspx
[Index clustered tables]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925501.aspx
[EXPDP]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925592.aspx
[IMPDP]: http://blog.csdn.net/robinson_0612/archive/2010/10/08/5926276.aspx
[Oracle 15]: http://blog.csdn.net/robinson_0612/archive/2011/03/13/6246738.aspx
[SQL_Loader]: http://blog.csdn.net/robinson_0612/archive/2010/10/08/5926296.aspx
[Link 1]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925564.aspx
[Link 2]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925526.aspx
[ORACLE]: http://blog.csdn.net/robinson_0612/archive/2010/09/30/5917103.aspx
[system sys_sysoper sysdba]: http://blog.csdn.net/robinson_0612/archive/2010/11/05/5989565.aspx
[ORACLE_SID_DB_NAME_INSTANCE_NAME_DB_DOMIAN_GLOBAL_NAME]: http://blog.csdn.net/robinson_0612/archive/2010/09/30/5917082.aspx
[Oracle _ _Oracle 9i 10g 11g Path]: http://blog.csdn.net/robinson_0612/archive/2011/04/06/6304124.aspx
[Oracle 10.2.0.1 _ 10.2.0.4]: http://blog.csdn.net/robinson_0612/archive/2011/05/05/6396783.aspx
[Oracle _ kill session]: http://blog.csdn.net/robinson_0612/archive/2011/05/23/6439019.aspx