Terima kasih sharingnya pak pandu :) On Fri, Jan 9, 2009 at 8:20 PM, Pandu W Perwira <[email protected]> wrote:
> 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]<aa.adipt%40gmail.com>> > wrote: > > From: mohammad arief pradipto <[email protected] <aa.adipt%40gmail.com>> > Subject: Re: [indo-oracle] Rename Datafile di Primary & Standby > To: [email protected] <indo-oracle%40yahoogroups.com> > 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] > > > -- adipt [email protected] 021 68 535 141 http://adipt.net/ [Non-text portions of this message have been removed]
