| Data Guard after upgrade to 10g [message #409988] |
Wed, 24 June 2009 13:13  |
nateholtrop
Messages: 24
Registered: May 2008 |
Junior Member |
|
|
Hello,
I recently upgraded my production environment from 9.2.0.8 to 10.2.0.3. Everything went fine except for data guard. I was following Oracle Doc ID 407040.1 but due to circumstances beyond my control i wasn't able to get the listener up for the standby in time. Now, I am left with wondering how to get my standby up to date with the primary database. I have the database up and it is saying it is 10.2.0.3. However when I attempt to connect to it from my primary system using rman (duplicate db for standby)it is still seeing it as 9.2.0.8. I am baffled by this as the listener is pointing to the right home, and the banner also says 10.2.0.3. Any help would be appreciated. Thanks
|
|
|
|
|
| Re: Data Guard after upgrade to 10g [message #409992 is a reply to message #409991] |
Wed, 24 June 2009 14:10  |
|
>> recently upgraded my production environment from 9.2.0.8 to 10.2.0.3. Everything went fine except for data guard
>>My 9.2.0.8 instance was still up.
You already done V9 to V10 upgrade;
1/ Why still V9 running?
2/ What's your problem in V10 dataguard?
3/ Did you upgraded your V9 standby database to V10?
Thanks
|
|
|
|
| Re: Data Guard after upgrade to 10g [message #410164 is a reply to message #410117] |
Thu, 25 June 2009 09:04 |
|
>>I didn't know my old 9i instance was running
You already done V9 to v10 upgrade; So right your customer using V10 database only not V9; In this case why still V9 running?
Ask to your Database Admin; to clarify the above question.
>>My errors now consists of missing config files which are something to the effects of dr1(sid).dat and dr2(sid).dat
1/ Post your exact database version (4 digit)
2/ Post your error message.
Babu
|
|
|
| Re: Data Guard after upgrade to 10g [message #410165 is a reply to message #409988] |
Thu, 25 June 2009 09:09 |
nateholtrop
Messages: 24
Registered: May 2008 |
Junior Member |
|
|
I didn't know my 9i instance was running still. I was baffled to see it even up and running. I had shut it down Saturday when I did the upgrade and don't remember turning it back on.
10.2.0.3
DG 2009-06-24-12:51:32 0 2 0 DMON: cannot open configuration file "/oracle10g/oracle/oracle/product/
10.2.0/db_1/dbs/dr2mx1bprd.dat"
DG 2009-06-24-12:51:32 0 2 0 ORA-27037: unable to obtain file status
DG 2009-06-24-12:51:32 0 2 0 HP-UX Error: 2: No such file or directory
DG 2009-06-24-12:51:32 0 2 0 Additional information: 3
DG 2009-06-24-12:51:32 0 2 0 DMON: Error opening /oracle10g/oracle/oracle/product/10.2.0/db_1/dbs/dr
2mx1bprd.dat, error = ORA-16572
DG 2009-06-24-12:51:32 0 2 0 DMON: unable to get FSFO data from "/oracle10g/oracle/oracle/product/10
.2.0/db_1/dbs/dr2mx1bprd.dat"
DG 2009-06-24-12:51:32 0 2 0 status = ORA-16572
DG 2009-06-24-12:51:32 0 2 0 DMON: cannot open configuration file "/oracle10g/oracle/oracle/product/
10.2.0/db_1/dbs/dr1mx1bprd.dat"
DG 2009-06-24-12:51:32 0 2 0 ORA-27037: unable to obtain file status
DG 2009-06-24-12:51:32 0 2 0 HP-UX Error: 2: No such file or directory
DG 2009-06-24-12:51:32 0 2 0 Additional information: 3
DG 2009-06-24-12:51:32 0 2 0 DMON: Error opening /oracle10g/oracle/oracle/product/10.2.0/db_1/dbs/dr
1mx1bprd.dat, error = ORA-16572
DG 2009-06-24-12:51:32 0 2 0 DMON: Establishing /oracle10g/oracle/oracle/product/10.2.0/db_1/dbs/dr1
mx1bprd.dat as the least current file
DG 2009-06-24-12:51:32 0 2 0 DMON: cannot open configuration file "/oracle10g/oracle/oracle/product/
10.2.0/db_1/dbs/dr2mx1bprd.dat"
DG 2009-06-24-12:51:32 0 2 0 ORA-27037: unable to obtain file status
DG 2009-06-24-12:51:32 0 2 0 HP-UX Error: 2: No such file or directory
|
|
|
| Re: Data Guard after upgrade to 10g [message #410170 is a reply to message #410165] |
Thu, 25 June 2009 09:23 |
|
>>I didn't know my 9i instance was running still. I was baffled to see it even up and running. I had shut it down Saturday when I did the upgrade and don't remember turning it back on.
Please check with your DBA. I think we need to start new topic. Why V9 database running after upgrade V10. How you done database upgrade using manual method? Or DBUA ?
ORA-16572: Data Guard configuration file not found
Cause: The Data Guard broker configuration file was either unavailable or did not exist.
Action: Verify that the configuration file was successfully created. If the dg_broker_config_file[1|2] parameter was changed,
ensure the filename on disk and the parameter value match, there is space on the device, and you have the right permissions.
Please read the OraFAQ Forum Guide before posting.
http://www.orafaq.com/forum/t/88153/0/
|
|
|
|
| Re: Data Guard after upgrade to 10g [message #410172 is a reply to message #410171] |
Thu, 25 June 2009 09:32 |
|
Hello Nateholtrop,
>>Where is this file stored in 9i? I've been looking for it now for awhile and I am not able to find it.
I'm not understand your question; Your asking V9 ORACLE_HOME? Or DataGuard Broker file location?
Thanks
|
|
|
|
|
|
|
| Re: Data Guard after upgrade to 10g [message #410188 is a reply to message #409988] |
Thu, 25 June 2009 10:27 |
nateholtrop
Messages: 24
Registered: May 2008 |
Junior Member |
|
|
SQL> show parameter dg
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dg_broker_config_file1 string /oracle10g/oracle/oracle/produ
ct/10.2.0/db_1/dbs/dr1mx1bprd.
dat
dg_broker_config_file2 string /oracle10g/oracle/oracle/produ
ct/10.2.0/db_1/dbs/dr2mx1bprd.
dat
dg_broker_start boolean TRUE
|
|
|
| Re: Data Guard after upgrade to 10g [message #410195 is a reply to message #410188] |
Thu, 25 June 2009 11:18 |
|
>>I am asking where the broker config file is. I inherited this environment so I do not know where the files for data guard specifics are located
I hope now you find out file location.
>>DG 2009-06-24-12:51:32 0 2 0 DMON: cannot open configuration file "/oracle10g/oracle/oracle/product/10.2.0/db_1/dbs/dr2mx1bprd.dat"
Why NOT opening this file? Check from OS level.
Thanks
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
