OraFAQ Forum: Data Guard » Datafiles on Standby Databases

Home » Server Options » Data Guard » Datafiles on Standby Databases

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Datafiles on Standby Databases [message #177992]

Sun, 18 June 2006 23:39

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

Report message to a moderator

Re: Datafiles on Standby Databases [message #178029 is a reply to message #177992]

Mon, 19 June 2006 02:53

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.

Report message to a moderator

Re: Datafiles on Standby Databases [message #178139 is a reply to message #178029]

Mon, 19 June 2006 09:56

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

Report message to a moderator

Re: Datafiles on Standby Databases [message #178218 is a reply to message #177992]

Tue, 20 June 2006 03:07

dlore
Messages: 6
Registered: June 2006
Location: Philippines

Junior Member

Thanks for you inputs...

Regards,
~DLORE
Razz

Report message to a moderator

Re: Datafiles on Standby Databases [message #180140 is a reply to message #177992]

Fri, 30 June 2006 05:31

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

Report message to a moderator

Re: Datafiles on Standby Databases [message #180510 is a reply to message #177992]

Tue, 04 July 2006 00:14

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

Report message to a moderator

Previous Topic:	failover with multiple standby
Next Topic:	Logs not applied on Standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 12 11:04:35 CDT 2026