文档课题:备库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=’’;
主库新添加数据文件后 备库修改数据文件路径——备库OMF管理方式
原创Liujun_Deng 博主文章分类:Oracle ©著作权
文章标签 omf db_create_file_dest db_file_name_convert 文章分类 Oracle 数据库
©著作权归作者所有:来自51CTO博客作者Liujun_Deng的原创作品,请联系作者获取转载授权,否则将追究法律责任
上一篇:备库状态为read only with apply 但v$managed_standby却未见rfs进程信息
下一篇:系统启动报错:you might want to save “/run/initramfs/rdsosreport.txt“ to a USB stick or /boot
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
运用OMF更改备库自动生成数据文件的位置
运用OMF更改备库自动生成数据文件的位置
oracle sql 数据文件 -
更改备库自动生成数据文件路径
更改备库自动生成数据文件路径
oracle sql 数据文件 -
oracle11g dataguard物理备库搭建(关闭主库cp数据文件到备库)
本文主要介绍通过停主库,scp数据文件到配库的方式搭建dataguard环境。
oracle dataguard 搭建 -
主库数据文件存在坏块,运用备库rman备份进行恢复
主库数据文件存在坏块,运用备库rman备份进行恢复
主库坏块 运用备库rman备份恢复 -
ADG 备库数据文件损坏处理
ADG 备库数据文件损坏处理
ADG恢复备库数据文件 -
Oracle OMF管理 数据文件,redo文件
ORACLE OMF 管理文件 测试环境:Solaris10+Oracle
ORACLE 休闲 REDO OMF TABLESPACE -
运用主库数据文件rman备份对备库单个坏块的恢复—blockrecover
运用主库数据文件rman备份对备库单个坏块的恢复—blockrecover
oracle blockrecover 索引块损坏 -
更改数据库数据文件位置
更改数据库数据文件位置
sql 数据库 数据文件