Oracle-备份策略-用友NC案例-dataguard异地容灾、rman备份和逻辑备份

项目编号：项目名称：文档编号：版本号：V1.0Oracle备份策略-用友NC案例dataguard异地容灾、rman备份和逻辑备份建立日期:2015-03-23文档控制更改记录审阅人姓名职位审阅签字备注日期作者版本更改参考号备注余超目录...................................................................................................................................................1一、NC数据库主库创建......................................................................................................11.创建表空间和用户.....................................................................................................12、每个表空间增加一个表空间文件.............................................................................23.数据库参数修改(NC要求)........................................................................................24.添加存储过程ANALYZE_TB；....................................................................................35.添加计划执行ANALYZE_TB：（每周天2：00执行）............................................5二、创建dataguard..........................................................................................................61.Primary端准备..........................................................................................................62.Standby端准备........................................................................................................103．数据库迁移...............................................................................................................144．最大性能切换到最大可用.......................................................................................155．检查动作...................................................................................................................166.手动切换switchover和failover........................................................................188.启动dataguard........................................................................................................209.关闭dataguard........................................................................................................20三、设置相同的服务名...................................................................................................22四、数据库的RMAM备份和还原.....................................................................................241、RMAN配置..................................................................................................................242、还原和备份脚本.......................................................................................................24五、数据库的逻辑备份和还原.......................................................................................271．备份.........................................................................................................................272．还原.........................................................................................................................29六、启用oracle快闪.....................................................................................................29第1页一、NC数据库主库创建1.创建表空间和用户创建表空间：CREATETABLESPACENNC_DATA01DATAFILE'D:\app\Administrator\oradata\orcl1\nnc_data01.dbf'SIZE4000MAUTOEXTENDONNEXT400MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_DATA02DATAFILE'D:\app\Administrator\oradata\orcl1\nnc_data02.dbf'SIZE2000MAUTOEXTENDONNEXT200MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;CREATETABLESPACENNC_DATA03DATAFILE'D:\app\Administrator\oradata\orcl1\nnc_data03.dbf'SIZE4000MAUTOEXTENDONNEXT400MEXTENTMANAGEMENTLOCALUNIFORMSIZE512K;CREATETABLESPACENNC_INDEX01DATAFILE'D:\app\Administrator\oradata\orcl1\nnc_index01.dbf'SIZE3000MAUTOEXTENDONNEXT200MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;CREATETABLESPACENNC_INDEX02DATAFILE'D:\app\Administrator\oradata\orcl1\nnc_index02.dbf'SIZE2000MAUTOEXTENDONNEXT200MEXTENTMANAGEMENTLOCALUNIFORMSIZE128K;CREATETABLESPACENNC_INDEX03DATAFILE'D:\app\Administrator\oradata\orcl1\nnc_index03.dbf'SIZE3000MAUTOEXTENDONNEXT400MEXTENTMANAGEMENTLOCALUNIFORMSIZE256K;创建用户：CREATEUSERNTXXNC57IDENTIFIEDBYNTXXNC57DEFAULTTABLESPACENNC_DATA01TEMPORARYTABLESPACEtemp;赋予用户角色：GRANTconnect,dbatoNTXXNC57;第2页2、每个表空间增加一个表空间文件ALTERTABLESPACENNC_DATA01ADDDATAFILE'D:\app\Administrator\oradata\orcl1\nnc_data01_2.dbf'SIZE4000MAUTOEXTENDONNEXT400M;ALTERTABLESPACENNC_DATA02ADDDATAFILE'D:\app\Administrator\oradata\orcl1\nnc_data02_2.dbf'SIZE2000MAUTOEXTENDONNEXT200M;ALTERTABLESPACENNC_DATA03ADDDATAFILE'D:\app\Administrator\oradata\orcl1\nnc_data03_2.dbf'SIZE4000MAUTOEXTENDONNEXT400M;ALTERTABLESPACENNC_INDEX01ADDDATAFILE'D:\app\Administrator\oradata\orcl1\nnc_index01_2.dbf'SIZE3000MAUTOEXTENDONNEXT200M;ALTERTABLESPACENNC_INDEX02ADDDATAFILE'D:\app\Administrator\oradata\orcl1\nnc_index02_2.dbf'SIZE2000MAUTOEXTENDONNEXT200M;ALTERTABLESPACENNC_INDEX03ADDDATAFILE'D:\app\Administrator\oradata\orcl1\nnc_index03_2.dbf'SIZE3000MAUTOEXTENDONNEXT400M;3.数据库参数修改(NC要求)ALTERPROFILEDEFAULTLIMITPASSWORD_LIFE_TIMEUNLIMITED;（用户密码永不过期）altersystemsetopen_cursors=4000scope=spfile;altersystemsetoptimizer_dynamic_sampling=4scope=spfile;altersystemsetprocesses=300scope=spfile;altersystemsetsessions=300scope=spfile;altersystemsetoptimizer_index_cost_adj=40scope=spfile;altersystemsetdeferred_segment_creation=falsescope=s