• SnapAssure迁移ASM+RAC库到单节点文件系统


    recover controlfile from '恢复后的控制文件全路径';

    创建adump、bdump、cdump、udump目录;

    修改pfile里的各个参数。 startup mount pfile='/xxx/init.ora';

    alter database rename file '+DATA/rac/datafile/undotbs1.260.781442329' to   '/backup/oradata/undotbs1.260.781442329'; alter database rename file '+DATA/rac/datafile/sysaux.261.781442329'  to  '/backup/oradata/sysaux.261.781442329'  ; alter database rename file '+DATA/rac/datafile/undotbs2.263.781442331'  to  '/backup/oradata/undotbs2.263.781442331'; alter database rename file '+DATA/rac/datafile/users.264.781442333'  to '/backup/oradata/users.264.781442333' ;  alter database rename file '+DATA/rac/datafile/test01.dbf'  to '/backup/oradata/test01.dbf';   

    alter database rename file '+DATA/rac/onlinelog/group_1.257.781442325' to  '/backup/oradata/group_1.257.781442325' ; alter database rename file '+DATA/rac/onlinelog/group_2.258.781442325' to  '/backup/oradata/group_2.258.781442325' ; alter database rename file '+DATA/rac/onlinelog/group_3.265.781443203' to  '/backup/oradata/group_3.265.781443203' ; alter database rename file '+DATA/rac/onlinelog/group_4.266.781443205' to  '/backup/oradata/group_4.266.781443205' ; alter database rename file '+DATA/rac/onlinelog/group_5.269.781465249' to  '/backup/oradata/group_5.269.781465249' ; alter database rename file '+DATA/rac/onlinelog/group_6.270.781465267' to  '/backup/oradata/group_6.270.781465267' ;

  • 相关阅读:
    数据库知识总结
    servlet总结
    创建Dynamic Web Project工程
    Python--(爬虫与数据库的连接)
    Mongodb数据库操作
    Python Web(Django)连接SQL SERVER
    Python操作MySql
    Python(Django)项目与Apache的管理交互
    Python Django连接(听明白了是连接不是创建!)Mysql已存在的数据库
    Python selenium自动化网页抓取器
  • 原文地址:https://www.cnblogs.com/luoyx/p/2492140.html
Copyright © 2020-2023  润新知