Home » Server Options » Data Guard » The column name is null in V$archive_log (Oracle 10.2.0.3)
The column name is null in V$archive_log [message #467200] Thu, 22 July 2010 11:10 Go to next message
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


Re: The column name is null in V$archive_log [message #467204 is a reply to message #467200] Thu, 22 July 2010 11:21 Go to previous message
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;)."
Previous Topic: standby on same server
Next Topic: log archive dest issue
Goto Forum:
  


Current Time: Fri Mar 29 07:50:23 CDT 2024