Rename a Datafile in Primary Within in Physical Dataguard Configuration_733796.1
How to Rename a Datafile in Primary Database Within in Physical Dataguard Configuration (Doc ID 733796.1)
In this Document
Applies to:Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]Information in this document applies to any platform. ***Checked for relevance on 28-Sep-2012*** ***Checked for relevance on 5-Aug-2014*** GoalHow to rename a datafile in the primary database and manually propagate the changes to the standby database.
When you rename one or more datafiles in the primary database, the change is not propagated to the standby database, even if the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO.
ORA-00283: recovery session canceled due to errors
ORA-01157: cannot identify/lock datafile 14 - see DBWR trace file ORA-01110: datafile 14: '/Disk1/oracle/oradata/mum/payroll_01.dbf' Solution
The following steps describe how to rename a datafile in the primary database and manually propagate the changes to the standby database.
SQL>ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;
SQL> ALTER TABLESPACE tbs_4 OFFLINE;
% mv /Disk1/oracle/oradata/mum/payroll_1.dbf /Disk1/oracle/oradata/mum/payroll_01.dbf
SQL> ALTER TABLESPACE tbs_4 RENAME DATAFILE '/Disk1/oracle/oradata/mum/payroll_1.dbf' TO '/Disk1/oracle/oradata/mum/payroll_01.dbf';
SQL> ALTER TABLESPACE tbs_4 ONLINE;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> SHUTDOWN;
% mv /Disk1/oracle/oradata/mum/payroll_1.dbf /Disk1/oracle/oradata/mum/payroll_01.dbf
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE RENAME FILE '/Disk1/oracle/oradata/mum/payroll_1.dbf' TO '/Disk1/oracle/oradata/mum/payroll_01.dbf';
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
SQL>ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;
|
|
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1363612/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 配置 Oracle 10g RAC primary + RAC physical standby dataguardOracle 10g
- Configure Oracle Dataguard Primary-ASM to Physical-ASM薦OracleASM
- rman copy asm datafile(rename asm datafile)ASM
- 【RAC,DATAGUARD】Creating a physical standby from ASM (RAC ) primary之四ASM
- Renaming a Datafile in the Primary DatabaseDatabase
- 配置Oracle physical DataGuardOracle
- DataGuard:Physical Standby Switchover
- Dataguard Physical Standy Switchover
- DataGuard:Physical Standby FailoverAI
- Creating a physical standby from ASM primaryASM
- Oracle 11.2.0.4 physical dataguard和snapshot dataguard切換Oracle
- Creating a physical standby from ASM primary [ID 787793.1]ASM
- 【DataGuard】Oracle 11g physical standby switchoverOracle
- DATAGUARD PHYSICAL STANDY下EXPDP資料
- ORACLE10g DataGuard 配置Physical Standby DatabaseOracleDatabase
- 關於建立DataGuard Physical Standby資料庫資料庫
- 【DATAGUARD 學習】監控primary庫和standby庫
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之三ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary 之二ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之一ASM
- Case two -- Recover a datafile in primary site from the backup taken in standby site without using c
- Case One -- Recover a datafile in primary site from the backup taken in standby site using catalog d
- Oracle 11g Data Guard (physical standby - active dataguard) [final]Oracle
- dataguard 搭建 oracle_sid不同 2節點 primary+standbyOracle
- dataguard 搭建 oracle_sid相同 2節點 primary+standbyOracle
- 資料檔案實驗操作datafile的create/offline/drop/rename等操作
- Creating Physical Standby using RMAN Duplicate Without Shutting Primary_789370.1
- Changing Primary DB Character Set without Recreate DG Physical Standby_1124165.1
- Step-By-Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMANGUIIDEORMASM
- Rename or Move a datafile In Oracle 19c RAC-20220117Oracle
- Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary [ID 789370.1]
- 10g dataguard ORA-00313 rename備用日誌操作
- Oracle11g的Dataguard測試,建立物理備庫(Physical Standby Database)OracleDatabase
- oracle實驗記錄 (oracle 10G dataguard(7)physical dg轉換)Oracle
- 配置Oracle11g的Dataguard測試,建立物理備庫(Physical Standby Database)OracleDatabase
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(10)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(9)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(8)LinuxOracle 10g