首页 > 其他分享 >主库新添加数据文件后 备库修改数据文件路径——备库OMF管理方式

主库新添加数据文件后 备库修改数据文件路径——备库OMF管理方式

时间:2022-10-02 19:00:36浏览次数:60  
标签:主库 datafile 备库 数据文件 app oradata file oracle u01

文档课题:备库db_create_file_dest和db_file_name_convert&log_file_name_convert同时存在,主库添加数据文件后会按照omf的路径生成数据文件,如何将新添加的数据文件路径修改到和其它数据文件路径一样?
系统:oel 7.9 64位
数据库:oracle 11.2.0.4 64位
环境:rac(双节点) + dg
以下测试过程:
主库添加数据文件.
> alter tablespace users add datafile '+data' size 100m autoextend on;
> select file#,name,status,bytes/1024/1024 from v$datafile

FILE# NAME STATUS BYTES/1024/1024
---------- -------------------------------------------------- ------- ---------------
1 +DATA/orcl/datafile/system.256.1107818145 SYSTEM 740
2 +DATA/orcl/datafile/sysaux.257.1107818147 ONLINE 700
3 +DATA/orcl/datafile/undotbs1.258.1107818147 ONLINE 105
4 +DATA/orcl/datafile/users.259.1107818147 ONLINE 16.25
5 +DATA/orcl/datafile/undotbs2.267.1107818231 ONLINE 50
6 +DATA/orcl/datafile/system.319.1110101255 SYSTEM 20
7 +DATA/orcl/datafile/users.555.1117045771 ONLINE 100

7 rows selected.
说明:+DATA/orcl/datafile/users.553.1116979173为新增数据文件.

以下操作均在备库执行.
> select file#,name from v$datafile;

FILE# NAME
---------- -----------------------------------------------------------------
1 /u01/app/oracle/oradata/system.256.1107818145
2 /u01/app/oracle/oradata/sysaux.257.1107818147
3 /u01/app/oracle/oradata/undotbs1.258.1107818147
4 /u01/app/oracle/oradata/users.259.1107818147
5 /u01/app/oracle/oradata/undotbs2.267.1107818231
6 /u01/app/oracle/oradata/system.319.1110101255
7 /u01/app/oracle/oradata/ORCLDG/datafile/o1_mf_users_kmjs15z3_.dbf

7 rows selected.
说明:可以看到o1_mf_users_kmjs15z3_.dbf为备库端新增文件.
> show parameter db_create

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string /u01/app/oracle/oradata
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
备库omf路径为/u01/app/oracle/oradata.
> alter database recover managed standby database cancel;
> alter system set standby_file_management=manual;
[oracle@hisdbdg ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 2 14:37:15 2022

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1635598952)

RMAN> backup as copy datafile 7 format '/u01/app/oracle/oradata/users.553.1116979173';

Starting backup at 02-OCT-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCLDG/datafile/o1_mf_users_kmjs15z3_.dbf
output file name=/u01/app/oracle/oradata/users.553.1116979173 tag=TAG20221002T143939 RECID=15 STAMP=1117031980
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 02-OCT-22
SQL> alter database datafile 7 offline for drop;
SQL> select name,file#,status from v$datafile;

NAME FILE# STATUS
----------------------------------------------------------------- ---------- -------
/u01/app/oracle/oradata/system.256.1107818145 1 SYSTEM
/u01/app/oracle/oradata/sysaux.257.1107818147 2 ONLINE
/u01/app/oracle/oradata/undotbs1.258.1107818147 3 ONLINE
/u01/app/oracle/oradata/users.259.1107818147 4 ONLINE
/u01/app/oracle/oradata/undotbs2.267.1107818231 5 ONLINE
/u01/app/oracle/oradata/system.319.1110101255 6 SYSTEM
/u01/app/oracle/oradata/ORCLDG/datafile/o1_mf_users_kmjs15z3_.dbf 7 RECOVER
SQL> shutdown immediate
SQL> startup mount;
[oracle@hisdbdg oradata]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 2 18:33:51 2022

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1635598952, not open)
RMAN> switch datafile 7 to copy;

using target database control file instead of recovery catalog
datafile 9 switched to datafile copy "/u01/app/oracle/oradata/users.555.1117045771"

SQL> alter database datafile 7 online;

Database altered.

SQL> select name from v$datafile;

NAME
-----------------------------------------------------------------
/u01/app/oracle/oradata/system.256.1107818145
/u01/app/oracle/oradata/sysaux.257.1107818147
/u01/app/oracle/oradata/undotbs1.258.1107818147
/u01/app/oracle/oradata/users.259.1107818147
/u01/app/oracle/oradata/undotbs2.267.1107818231
/u01/app/oracle/oradata/system.319.1110101255
/u01/app/oracle/oradata/users.555.1117045771

7 rows selected.
SQL> alter database open;

Database altered.
SQL > alter system set standby_file_management=auto;
SQL > alter system set db_create_file_dest=’’;

标签:主库,datafile,备库,数据文件,app,oradata,file,oracle,u01
From: https://blog.51cto.com/u_12991611/5729374

相关文章

  • 备库执行采集awr报告时,报错ORA-01110 ORA-01157
    系统:CentOS7.964位数据库:Oracle11.2.0.464位环境:rac(双节点)+dg问题描述:备库执行采集awr报告时,报错ORA-01110、ORA-01157,如下所示:press<return>tocontinue,otherw......
  • 网页伪静态、视图层、模板层、form表单如何携带数据文件
    目录网页伪静态1.什么是伪静态网页?2.伪静态的好处3.实现伪静态网页视图层1.三板斧2.三板斧的本质Django视图层函数必须要返回一个HttpResponse对象研究底层源码3.视图函数......
  • 检查表空间数据文件占用
    1、检查表空间数据文件占用:selectb.file_name物理文件名,b.tablespace_name表空间,b.bytes/1024/1024大小M,(b.bytes-sum(nvl(a.bytes,0)))/1024/1024已使用M,su......
  • MySQL六:InnoDB数据文件
    转载~一、数据文件的组成innodb数据逻辑存储形式为表空间,而每一个独立表空间都会有一个.ibd数据文件,ibd文件从大到小组成:一个ibd数据文件-->Segment(段)-->Extent(区)-->P......
  • VS2019使用dbml数据文件
    1.场景:以前的项目数据库对象用的是dbml,但是因为VS使用的是2019,打开就没有图像了(只能手动写映射类对象属性)2.处理方式;安装【LINQtoSQL工具】和【EntityFramework6......
  • 主库备份后异机进行恢复
    环境:OS:Centos7DB:DM8主库:192.168.1.136恢复库:192.168.1.134 1.在主库上进行备份(全备份+归档日志备份)[dmdba@localhostscript]$morefull_backckup.sh......
  • 解决vs“错误CS0006:未能找到元数据文件”,终极解决方法
    解决vs“错误CS0006:未能找到元数据文件”,终极解决方法问题引起起因:将A类库里的某些对象class迁移到 新创建的B类库(JF.Domain.csproj),通过这样的一顿骚操作后,编译的时候,错......
  • 【新手必看】docker直接安装应用没挂载数据文件怎么办?
    今天安装用docker安装ngnix后,出现了问题。直接使用命令安装dockerrun--namenginx-p80:80-dnginx 安装后ngnix的并不知道配置文件在何处。删掉重建吧太费劲,作为......
  • KingbaseES集群管理维护案例之---备库checkpoint分析
    ​数据库异常关闭时,数据库关闭时来不及或者没机会做checkpoint,则需要从上一个一致性检查的开始恢复。KingbaseES备机checkpoint是不能产生checkpointWAL日志条目的,因为如......