OraFAQ Forum: Data Guard » The column name is null in V$archive

Home » Server Options » Data Guard » The column name is null in V$archive_log (Oracle 10.2.0.3)

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

The column name is null in V$archive_log [message #467200]

Thu, 22 July 2010 11:10

xowine
Messages: 1
Registered: November 2007
Location: Toronto

Junior Member

In V$Archived_log, the column "name" showed No any content, can anyone explain it?

select name,SEQUENCE#,ARCHIVED,APPLIED,DELETED,STATUS,COMPLETION_TIME from v$archived_log

NAME SEQUENCE# ARC APP DEL S COMPLETIO
------------------------------ ---------- --- --- --- - ---------
2565 YES NO YES D 20-JUL-10
2566 YES NO YES D 21-JUL-10
2567 YES NO YES D 21-JUL-10
2568 YES NO YES D 22-JUL-10
2569 YES NO YES D 22-JUL-10
2570 YES NO YES D 22-JUL-10

Report message to a moderator

Re: The column name is null in V$archive_log [message #467204 is a reply to message #467200]

Thu, 22 July 2010 11:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1016.htm#I1030011

"Archived log file name. If set to NULL, either the log file was cleared before it was archived or an RMAN backup command with the "delete input" option was executed to back up archivelog all (RMAN> backup archivelog all delete input;)."

Report message to a moderator

Previous Topic:	standby on same server
Next Topic:	log archive dest issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 23:10:29 CST 2025