1.rman备份源库
    mkdir /opt/oracle/backup

    1. backup database include   current controlfile for  standby format '/opt/oracle/backup/%U'  ;

    2.移动文件
    3.解压spfile 文件

    1.  startup  nomount;
    2.  restore   spfile  from '/opt/oracle/backup/08up46d2_1_1';
    3.  shutdown abort;

    4.解压控制文件

    1. startup nomount;
    2. restore   controlfile  from '/opt/oracle/backup/08up46d2_1_1';

    5.修改数据库为mount

    1.  alter   database   mount;

    6注册备份集

    1.  catalog  start  with '/opt/oracle/backup/';

    7.查看备份集信息

    1. list backup;
    2. report schema;

    8.还原数据文件

    1. run{                                                                                                                                                       
    2.  set newname for database to '/opt/oracle/oradata/orcl/%U';                                                                                                    
    3.  restore  database;                                                                                                                                            
    4.  switch datafile all;                                                                                                                                          
    5.  }

    9.添加standby 日志文件

    1. select group#,status,members,archived   from v$log;  
    2. select *   from v$logfile;
    4. alter   database  add standby  logfile group 5;                                                                                                            
    5. alter   database  add standby  logfile group 6;                                                                                                            
    6. alter   database  add standby  logfile group 7;                                                                                                            
    7. alter   database  add standby  logfile group 8;
    8. alter   database  add standby  logfile group 9;

    10.dbua 升级

    1. shutdown immediate; 
    2. startup upgrade; 
    4. 执行@?/rdbms/admin/catupgrd.sql 升级
    5. 12.1以上版本执行下列语句
    6. quit
    7. cd $ORACLE_HOME/rdbms/admin                                                                                                              
    8. $ORACLE_HOME/perl/bin/perl catctl.pl -n 4 catupgrd.sql   
    10. alter  database open;
    11.  @?/rdbms/admin/utlrp.sql编译无效对象

    11.修改compatible