DATAGURAD同步后新增數(shù)據(jù)文件不適用什么參數(shù)

本篇內(nèi)容主要講解“DATAGURAD同步后新增數(shù)據(jù)文件不適用什么參數(shù)”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實用性強。下面就讓小編來帶大家學(xué)習(xí)“DATAGURAD同步后新增數(shù)據(jù)文件不適用什么參數(shù)”吧!

DATAGURAD搭建完成并同步后主庫新增數(shù)據(jù)文件,如果備庫再想修改文件路徑，則新增數(shù)據(jù)文件不再適用參數(shù)db_file_name_convert，
因為這是備庫通過standby_file_management='AUTO'自動創(chuàng)建在備庫的實際路徑，備庫如果想改這個新增文件的路徑備庫只能先設(shè)置standby_file_management='MANUAL'再alter database rename

備庫參數(shù)
db_file_name_convert='/iso/db/oradata/DW','/u01/app/oracle/oradata/DW'
standby_file_management='AUTO'

搭建DATAGUARD時
主庫的文件都在/iso/db/oradata/DW,備庫的文件自然就轉(zhuǎn)入了/u01/app/oracle/oradata/DW

搭建完DATAGURAD后并已經(jīng)同步了
主庫創(chuàng)建了一個數(shù)據(jù)文件，比如/iso/db/oradata/DW/eps.dbf
備庫自然也把該文件放入了/u01/app/oracle/oradata/DW/eps.dbf

現(xiàn)在備庫因為一些原因修改數(shù)據(jù)文件路徑，比如重新?lián)Q個ORACLE_BASE或ORACLE_HOME，把數(shù)據(jù)文件拷貝到其他路徑
例如把/u01/app/oracle/oradata/DW改為/u01/app/oradw/oradata/DW
備庫修改db_file_name_convert='/iso/db/oradata/DW','/u01/app/oradw/oradata/DW'
備庫startup mount后查詢select * from v$dbfile發(fā)現(xiàn)新增文件路徑為/u01/app/oracle/oradata/DW/eps.dbf
沒有變成我們想象中的/u01/app/oradw/oradata/DW/eps.dbf，雖然主庫是/iso/db/oradata/DW/eps.dbf
然后alter database recover managed standby database disconnect from session;
報錯
ORA-01157: cannot identify/lock data file 70 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/DW/eps.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

恢復(fù)操作如下
alter database rename file '/u01/app/oracle/oradata/DW/eps.dbf' to '/u01/app/oradw/oradata/DW/eps.dbf'
ORA-01275: Operation RENAME is not allowed if standby file management is automatic.
只能關(guān)閉數(shù)據(jù)庫修改standby_file_management='MANUAL'
startup mount再執(zhí)行
alter database rename file '/u01/app/oracle/oradata/DW/eps.dbf' to '/u01/app/oradw/oradata/DW/eps.dbf'
在關(guān)閉數(shù)據(jù)庫修改standby_file_management='AUTO'
startup mount
alter database recover managed standby database disconnect from session;
一切正常了

到此，相信大家對“DATAGURAD同步后新增數(shù)據(jù)文件不適用什么參數(shù)”有了更深的了解，不妨來實際操作一番吧！這里是億速云網(wǎng)站，更多相關(guān)內(nèi)容可以進入相關(guān)頻道進行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！