| Archive log files [message #339424] |
Thu, 07 August 2008 08:33  |
oracle_emc
Messages: 1
Registered: August 2008
|
Junior Member |
|
|
Hi,
I'm running the query:
SQL> select name, dest_id from gv$archived_log;
As output I get the name field as blank for few archive log files, while it comes correct for others:
NAME DEST_ID
1
2
..............
..............
/ora10g_redo1/archive/ARCH_55194_1_643390600.arc 1
/ora10g_redo0/archive/ARCH_55194_1_643390600.arc 2
..............
..............
Attached a file with sample output too.
Any idea, why is the NAME field coming as NULL/ blank though the DEST_ID is coming as valid?
|
|
|
|
| Re: Archive log files [message #339442 is a reply to message #339424] |
Thu, 07 August 2008 09:07  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
Which version of Oracle you are using?
Upgrade your 10gR1 databases to R2, As per oracle suggestion its a Bug.
Better talk to oracle for support....
Long time back i was facing one problem in which i was not able to see my DR is in sync with primary from primay site ... but when i connected at DR side, i was seeing DR is in sync with primary, for that oracle suggest to restart the primary DB ... we did that while applying cpu patch and thing worked fine but that DB was 9.2.0.8 on windows ...
[Updated on: Thu, 07 August 2008 09:17] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
