Re: Rename Datafile on Physical Standby

From: Bill Zakrzewski <bill_at_intactus.com>
Date: Tue, 29 Nov 2011 22:39:06 -0500
Message-Id: <EBFDC678-C783-45C8-8502-76E394F30FC3_at_intactus.com>

You can disregard, I found a document that showed the steps required…..

1. Shutdown standby
2. Move data files
3. Mount Standby 
4. Change STANDBY_FILE_MANAGEMENT to MANUAL
5. Rename datafiles
6. Change STANDBY_FILE_MANAGEMENT to AUTO
7. Switch on managed recovery

Bill

On Nov 29, 2011, at 10:01 PM, Bill Zakrzewski wrote:

> All -
>
> Oracle 9i
> HP-UX 11.x
>
> I have a primary database on one server and a physical standby database on another - databases and servers are identical. I recently had to move some files around on the primary because of tablespace growth and would like to get the standby database to have the same structure. Can anyone tell me how to rename data files on a physical standby database? When I attempted to ALTER DATABASE RENAME FILE '…….' TO '…….'; I received the error below…..
>
> ORA-01511: error in renaming log/data files
> ORA-01275: Operation RENAME is not allowed if standby file management is
> automatic.
>
> I would like to get the physical structure of the standby database to match the primary database.
>
> Thanks in advance,
> Bill

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 29 2011 - 21:39:06 CST