Home » RDBMS Server » Server Administration » Archive log files (Oracle 10g R2, Red hat linux)
Archive log files [message #339424] Thu, 07 August 2008 08:33 Go to next message
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 Go to previous message
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

Previous Topic: ORA-1115 error
Next Topic: 11G migration
Goto Forum:
  


Current Time: Thu Dec 08 22:22:15 CST 2016

Total time taken to generate the page: 0.08588 seconds