standby數據庫相關issue
當standby數據庫recover的時候,遇到以下錯誤:
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 20 is unknown - rename to correct file
ORA-01110: data file 20: '/u01/product/oracle/dbs/UNNAMED00020'
ORA-01157: cannot identify/lock data file 20 - see DBWR trace file
ORA-01111: name for data file 20 is unknown - rename to correct file
ORA-01110: data file 20: '/u01/product/oracle/dbs/UNNAMED00020'
直接在主數據庫上創建新的standby controlfile,然後再將產生的standby controlfile傳送到standby數據庫上,注意和以前的standby數據庫上的control file位置一致.
之後再開啟standby 數據庫,修改standby_file_management為manual,創建20號文件
alter database create datafile 20 as '/ocfs_data1/ecsdb/expense_data05.dbf';
再執行recover standby database
最後修改standby_file_management為auto
再重啟數據庫,最後就可正常的restore了.
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 20 is unknown - rename to correct file
ORA-01110: data file 20: '/u01/product/oracle/dbs/UNNAMED00020'
ORA-01157: cannot identify/lock data file 20 - see DBWR trace file
ORA-01111: name for data file 20 is unknown - rename to correct file
ORA-01110: data file 20: '/u01/product/oracle/dbs/UNNAMED00020'
直接在主數據庫上創建新的standby controlfile,然後再將產生的standby controlfile傳送到standby數據庫上,注意和以前的standby數據庫上的control file位置一致.
之後再開啟standby 數據庫,修改standby_file_management為manual,創建20號文件
alter database create datafile 20 as '/ocfs_data1/ecsdb/expense_data05.dbf';
再執行recover standby database
最後修改standby_file_management為auto
再重啟數據庫,最後就可正常的restore了.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25198367/viewspace-704262/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
