11g dataguard 下standby database的数据文件迁移

最新推荐文章于 2021-07-16 15:23:31 发布

liweihadoop

最新推荐文章于 2021-07-16 15:23:31 发布

阅读量696

点赞数

CC 4.0 BY-SA版权

分类专栏： dataguard 文章标签： standby database 数据

本文链接：https://blog.youkuaiyun.com/u010409445/article/details/51025200

dataguard 专栏收录该内容

5 篇文章

订阅专栏

本文介绍在Oracle DataGuard环境中重启及数据文件迁移的过程。包括关闭主备数据库、将备用数据库置于mount状态、更改数据文件路径、打开数据库并取消恢复操作等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY WITH APPLY

若是standby处于 Read Only 模式下则

重启dataguard

首先关闭primary database

关闭standby database

打开standby database到mount状态

SQL>alter database mount standby database;

SQL> alter database rename file '/u01/app/oracle/oradata/dsg/DSG_DG/datafile/o1_mf_secooler_cgdphhp1_.dbf'
2 to '/u01/app/oracle/oradata/dsg/o1_mf_secooler_cgdphhp1_.dbf';

SQL> select file#,name from v$datafile;

FILE# NAME
---------- ---------------------------------------------------------------------
1 /u01/app/oracle/oradata/dsg/system.263.896387105
2 /u01/app/oracle/oradata/dsg/sysaux.268.896387107
3 /u01/app/oracle/oradata/dsg/undotbs1.267.896387107
4 /u01/app/oracle/oradata/dsg/users.266.896387107
5 /u01/app/oracle/oradata/dsg/example.259.896387567
6 /u01/app/oracle/oradata/dsg/undotbs2.258.896388663
7 /u01/app/oracle/oradata/dsg/o1_mf_secooler_cgdphhp1_.dbf

7 rows selected.

SQL> alter database open;

Database altered.

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

Database altered.

若是standby 处于mount 模式下

SQL> select open_mode from v$database;

OPEN_MODE
--------------------

MOUNTED

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database rename file '/u01/app/oracle/oradata/dsg/o1_mf_secooler_cgdphhp1_.dbf' to '/u01/app/oracle/oradata/dsg/secooler01.dbf';

Database altered.

SQL> alter database open;

Database altered.

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

Database altered.

SQL> select file#,name from v$datafile;

FILE# NAME
---------- ---------------------------------------------------------------------
1 /u01/app/oracle/oradata/dsg/system.263.896387105
2 /u01/app/oracle/oradata/dsg/sysaux.268.896387107
3 /u01/app/oracle/oradata/dsg/undotbs1.267.896387107
4 /u01/app/oracle/oradata/dsg/users.266.896387107
5 /u01/app/oracle/oradata/dsg/example.259.896387567
6 /u01/app/oracle/oradata/dsg/undotbs2.258.896388663
7 /u01/app/oracle/oradata/dsg/secooler01.dbf

7 rows selected.

SQL>

至此standby database的数据文件迁移完毕

多说一句

SQL> alter tablespace SECOOLER_TBS offline;
alter tablespace SECOOLER_TBS offline
*
ERROR at line 1:
ORA-01109: database not open

SQL> alter database datafile 7 offline;
alter database datafile 7 offline
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files

数据库不是read write状态不能用离线表空间或者离线数据文件的方式