DG数据迁移方案

  • 数据构造
    1. 检查数据构造之前主备的状态

主库:

SQL> select name,open_mode,switchover_status from v$database;

备库:

SQL> select name,open_mode,switchover_status from v$database;

    1. 主库创建用户

创建表空间:

CREATE TABLESPACE MYTBS

DATAFILE '/opt/oracle/oradata/ITPUXDB/MYTBS.DBF' SIZE 500M

AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

创建用户配置文件

create profile zgcprofile limit

  password_life_time 10

  failed_login_attempts 3

  password_lock_time 1;

创建用户

create user zgc identified by 123456

default tablespace MYTBS

Quota 20m on MYTBS

Profile zgcprofile;

权限授予:

GRANT CONNECT TO zgc;

GRANT CREATE TABLE,CREATE INDEXTYPE TO zgc;

GRANT DBA TO zgc;

    1. 数据构造

见《oracle数据库验证数据构造方案》

    1. 创建一览

查看学生表

select * from students;

查看教师表

select * from teachers;

查看班级表

select * from classes;

  • 主备切换
    1. 主库切备库(在主库中操作)

sqlplus / as sysdba

SQL>startup   

SQL> select name,open_mode,switchover_status from v$database;

SQL> alter system switch logfile;

SQL> alter system archive log current;

SQL> alter database commit to switchover to physical standby with session shutdown;

SQL> shutdown abort

SQL> startup mount

SQL> select switchover_status from v$database;

SQL> alter database open;

SQL> select switchover_status from v$database;

    1. 备库切主库(在备库中操作)

在主库启动时,备库在mount状态

记得在之前:

开启数据同步

sqlplus / as sysdba

SQL>startup mount

SQL> ALTER  DATABASE RECOVER MANAGED STANDBY  DATABASE DISCONNECT FROM SESSION;

SQL> alter database commit to switchover to primary with session shutdown;

SQL> alter database open;

SQL> select name,open_mode,switchover_status from v$database;

    1. 新备库(原主库)启用实时日志应用

SQL> alter database recover managed standby database using current logfile disconnect from session;

SQL> select name,open_mode,switchover_status from v$database;

    1. 新主库切换日志

SQL> alter system switch logfile;

    1. 分别查看当前主备库切换后当前日志序列

主库:

SQL> archive log list

备库:

SQL> archive log list

    1. 查看当前主备库状态

主库:

SQL> select name,open_mode,switchover_status from v$database;

备库:

SQL> select name,open_mode,switchover_status from v$database;

  • 数据验证(展示一部分)
    1. 查看表和数据

select * from students;

select * from teachers;

select * from classes;

完成

  • 7
    点赞
  • 12
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值