Home » Server Options » Data Guard » Datafiles on Standby Databases
Datafiles on Standby Databases [message #177992] Sun, 18 June 2006 23:39 Go to next message
dlore
Messages: 6
Registered: June 2006
Location: Philippines
Junior Member

Hi Guru's!...

Please help me with my standby databases.. Here is my question, I have renamed two datafiles on my Primary database.. Do I also need to change the name of that datafiles on my standby databases?.. And if there's any inconsistencies with my standby databases if the datafiles does not have the same name with the primary database?..

Thanks in advance...
~DLORE

Re: Datafiles on Standby Databases [message #178029 is a reply to message #177992] Mon, 19 June 2006 02:53 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Teoretically there must no to be problem, because datafile names are maintain in controlfile, and generally datiafiles of standby and primary database can be placed in different places(controlfiles of primary and standby database are not identical, when datafiles are strictly identical to precision of SCN). For database real sense have file_id, and not file name - but in this situation file_id are not changing.
Re: Datafiles on Standby Databases [message #178139 is a reply to message #178029] Mon, 19 June 2006 09:56 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

In respect with 10g..

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10823/manage_ps.htm#1034173
Re: Datafiles on Standby Databases [message #178218 is a reply to message #177992] Tue, 20 June 2006 03:07 Go to previous messageGo to next message
dlore
Messages: 6
Registered: June 2006
Location: Philippines
Junior Member

Thanks for you inputs...

Regards,
~DLORE
Razz
icon14.gif  Re: Datafiles on Standby Databases [message #180140 is a reply to message #177992] Fri, 30 June 2006 05:31 Go to previous messageGo to next message
bansalhr
Messages: 1
Registered: June 2006
Location: Bangalore(INDIA)
Junior Member
renaming of the datafile is required at the standby location.
Even you are using standby file management AUTO

go to ur standby database and check the log after the rename at primary has been applied or not if applied
shutdown it
change standby file management manual
rename the file
startup nomount
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RENAME FILE............

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE..

I hope this will work..


harsh


Re: Datafiles on Standby Databases [message #180510 is a reply to message #177992] Tue, 04 July 2006 00:14 Go to previous message
dlore
Messages: 6
Registered: June 2006
Location: Philippines
Junior Member

Hi bansalhr,

Thanks for your response.. That's what i deed on renaming my datafiles on standby databases.. It's ok now.. Thanks again for your input...

Regards,
~DLORE
Cool
Previous Topic: failover with multiple standby
Next Topic: Logs not applied on Standby
Goto Forum:
  


Current Time: Mon Mar 30 01:48:19 CDT 2020