8.4.3 Renaming a Datafile in the Primary Database When you rename one or more datafiles in the primary database, the change is not propagated to the standby database. Therefore, if you want to rename the same datafiles on the standby database, you must manually make the equivalent modifications on the standby database because the modifications are not performed automatically, even if the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO. The following steps describe how to rename a datafile in the primary database and manually propagate the changes to the standby database. If you do not want the standby database to have the same physical structure as the primary database, then these steps are not required.
To rename the datafile in the primary database, take the tablespace offline: SQL> ALTER TABLESPACE tbs_4 OFFLINE; Exit from the SQL prompt and issue an operating system command, such as the following UNIX mv command, to rename the datafile on the primary system: % mv tbs_4.dbf tbs_x.dbf Rename the datafile in the primary database and bring the tablespace back online: SQL> ALTER TABLESPACE tbs_4 RENAME DATAFILE 'tbs_4.dbf' 2> TO 'tbs_x.dbf'; SQL> ALTER TABLESPACE tbs_4 ONLINE; Connect to the standby database and make sure that all the logs are applied; then stop managed recovery operations: SQL> SELECT NAME, SEQUENCE#, ARCHIVED, APPLIED 2> FROM V$ARCHIVED_LOG; SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; Shut down the standby database: SQL> SHUTDOWN; Rename the datafile at the standby site using an operating system command, such as the UNIX mv command: % mv tbs_4.dbf tbs_x.dbf Start and mount the standby database with the new control file: SQL> STARTUP NOMOUNT; SQL> ALTER DATABASE MOUNT STANDBY DATABASE; Rename the datafile in the standby controlfile. Note that the STANDBY_FILE_MANAGEMENT initialization parameter must be set to MANUAL. SQL> ALTER DATABASE RENAME FILE 'tbs_4.dbf' 2> TO 'tbs_x.dbf'; On the standby database, restart managed recovery operations: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE 2> DISCONNECT FROM SESSION; If you do not rename the corresponding datafile at the standby site, and then try to refresh the standby database control file, the standby database will attempt to use the renamed datafile, but it will not find it. Consequently, you will see error messages similar to the following in the alert log:ORA-00283: recovery session canceled due to errors ORA-01157: cannot identify/lock data file 4 - see DBWR trace file ORA-01110: data file 4: '/disk1/oracle/dbs/tbs_x.dbf' regards, pandu wp --- On Fri, 1/9/09, mohammad arief pradipto <[email protected]> wrote: From: mohammad arief pradipto <[email protected]> Subject: Re: [indo-oracle] Rename Datafile di Primary & Standby To: [email protected] Date: Friday, January 9, 2009, 1:30 AM Butuh register dulu ya pak..? Boleh artikelnya langsung share di sini..? On Sat, Jan 10, 2009 at 6:43 AM, joey <inij...@gmx. com> wrote: > kebetulan saya juga lagi testing dataguard dan nemu resource > troubleshoot yang mungkin bisa membantu : > http://searchoracle .techtarget. com/tip/0, 289483,sid41_ gci1302327, 00.html# > > joey > > > ----- Original Message ----- > From: mohammad arief pradipto > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > Sent: Wednesday, January 07, 2009 7:05 PM > Subject: [indo-oracle] Rename Datafile di Primary & Standby > > Dear Pendekars, > > Saya berniat memindahkan beberapa datafile di Server Prod Primary untuk > menjaga load balance dan juga menghindari harddisk penuh, bagaimana dengan > server physical standby dari database tersebut. Benarkah step-step saya > ini: > > Server Primary: > ------------ --------- - > > 1. alter database datafile '/aaa/uuu/eee. dbf' offline; > 2. mv /aaa/uuu/eee. dbf /aaa/iii/eee/ dbf > 3. alter database rename file '/aaa/uuu/eee. dbf' to '/aaa/iii/eee. dbf'; > 4. recover datafile '/aaa/iii/eee. dbf'; > 5. alter database datafile '/aaa/iii/eee. dbf' online; > > Server Standby: > ------------ --------- -- > > 1. mv /aaa/uuu/eee. dbf /aaa/iii/eee/ dbf > 2. alter database rename file '/aaa/uuu/eee. dbf' to '/aaa/iii/eee. dbf'; > > Apa hal-hal yang perlu saya perhatikan dalam me-rename datafile di server > primary, hubungannya dengan server standby..? > > Trima kasih atas pencerahannya. . > > -- > adipt > aa.ad...@gmail. com <aa.adipt%40gmail. com> > 021 68 535 141 > http://adipt. net/ > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > -- adipt aa.ad...@gmail. com 021 68 535 141 http://adipt. net/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
