$ARCHIVE displays information about redo log files in need of archiving. Each row displays information for one thread. This information is also available in V$LOG. Oracle recommends that you use V$LOG.
• GROUP# – Log file group number
• THREAD# – Log file thread number
• SEQUENCE# – Log file sequence number
• ISCURRENT – This is the current online redo log
• CURRENT – This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in ISCURRENT.
• FIRST_CHANGE# – First SCN stored in the current log
SQL> select * from v$archive; no rows selected
Starting backup at 24-APR-12
using channel ORA_DISK_1
specification does not match any archive log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 24-APR-12
RMAN> RUN{
2> ALLOCATE CHANNEL C1 TYPE DISK;
3> BACKUP
4> ARCHIVELOG LIKE ‘D:\ORACLE\ORADATA\PROD\ARCHIVE%’;
5> }
released channel: ORA_DISK_1
allocated channel: C1
channel C1: sid=156 devtype=DISK
Starting backup at 24-APR-12
released channel: C1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/24/2012 11:12:50
RMAN-20242: specification does not match any archive log in the recovery catalo
RMAN> QUIT
Recovery Manager complete.
D:\ORACLE\product\10.2.0\db_1\database>SQLPLUS / AS SYSDBA
SQL*Plus: Release 10.2.0.1.0 – Production on Tue Apr 24 11:13:38 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
SQL> SELECT * FROM V$ARCHIVED_LOG;
no rows selected
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> SELECT * FROM V$ARCHIVED_LOG;
no rows selected
WHAT I HAVE TO DO NOW?
I AM USING ORACLE 10G ON WINDOWS OS.
PLZ SOLVE MY ISSUE.
THANK U.