OraFAQ Forum: Data Guard » Wrong datafiles and logfiles address in standby Controlfile

Home » Server Options » Data Guard » Wrong datafiles and logfiles address in standby Controlfile (oracle 11gr2 data guard)

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

Wrong datafiles and logfiles address in standby Controlfile [message #622300]

Mon, 25 August 2014 01:13

saeed_sp
Messages: 3
Registered: October 2006
Location: Global Village

Junior Member

Hi any body.
While creating data guard i use "Alter database create standby control file as 'd:\somefile.txt' " to create controlfile for standby database.but when i mount standby database using this controlfile data files and log files address (v$datafile,v$logfile ) are same as primary database.I have different path on standby for database files .and i set db_file_name_convert and log_file_name_convert.
db_file_name_convert='dbg1','db'
log_file_name_convert='dbg1','db1'

so after mounting redo transfer works ok but applying redo doesn't work.So i forced to startup mount and then renaming all data files and log file with new path on standby.and it works ok!
I have some question:
1-I did the same process some months ago and it worked ok!, So wahts the problem?
2-Does oracle itself changes data file and log file names for standby control file when I create it!?(Alter database create standby controlfile as 'd:\somefile.txt')
Or it did it while mounting controlfile on standby database?!(startup mount)
3-at last where can i find oracle command source to know what relay it does?!!
(for example source of this command : "alter database create standby control file")

Report message to a moderator

Re: Wrong datafiles and logfiles address in standby Controlfile [message #622321 is a reply to message #622300]

Mon, 25 August 2014 02:35

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

When you say this,
Quote:

i set db_file_name_convert and log_file_name_convert.

do you mean that you specified them in your DUPLICATE DATABASE FOR STANDBY command, or do you mean that all you did was set them in your standby instance parameter file?

Does this
Quote:

Alter database create standby control file

mean tat you are trying to do it manually, rather than with RMAN?

Report message to a moderator

Re: Wrong datafiles and logfiles address in standby Controlfile [message #622331 is a reply to message #622321]

Mon, 25 August 2014 03:53

saeed_sp
Messages: 3
Registered: October 2006
Location: Global Village

Junior Member

Quote:

When you say this,
Quote:
i set db_file_name_convert and log_file_name_convert.
do you mean that you specified them in your DUPLICATE DATABASE FOR STANDBY command, or do you mean that all you did was set them in your standby instance parameter file?

No.I specified them just in standby parameter file.

Quote:

Does this
Quote:
Alter database create standby control file
mean tat you are trying to do it manually, rather than with RMAN?

I created standby database manually and didn't use rman duplicate command.

Report message to a moderator

Re: Wrong datafiles and logfiles address in standby Controlfile [message #622332 is a reply to message #622331]

Mon, 25 August 2014 03:55

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

You are in Iran. Your use of Oracle is illegal. I regret having replied earlier, and cannot give further assistance.

Report message to a moderator

Previous Topic:	Database sync
Next Topic:	Datafile Fractured

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 14:05:42 CDT 2023