Question: I am running RMAN and I have entries
in the v$archived_log table where the column name is NULL?
I tried these RMAN commands but I still have NULL values in the
name column of v$archived_log:
RMAN> CROSSCHECK BACKUP
DEVICE TYPE DISK;
RMAN> CROSSCHECK ARCHIVELOG ALL;
RMAN> DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
NOPROMPT EXPIRED BACKUP;
RMAN> DELETE NOPROMPT OBSOLETE;
Why does v$archived_log insist upon having a NULL column
value for the name column?
Answer: You can see NULL values in
v$archived_log with this query:
See this discussion for details on
values in v$archived_log in RMAN.
In some cases there the v$archived_log
name column is NULL, you may see the RMAN-03002 followed by a
ORA-06502 (number precision too large) and if you execute an RMAN
restore, the underlying RMAN PL/SQL package (X$DBMS_RCVMAN) gets the
ORA-06502 error in the alert log.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.