RMAN-06726 & RMAN-03002 especially when V$archived_log doesn't say anything
Hi,
I am receiving "RMAN-06726: could not locate archivelog" as explained below.
Setup:
====
Oracle 10.2.0.4.0
2 Node Oracle RAC: Primary Site
2 Node Oracle RAC: Standby Site
OS: Solaris 10
DG Broker configured with MaxAvailability mode and Fast Start Failover.
Backups: rman backups are taken from standby nodes.
Following is RMAN configuration:
oracle@bassmtprd1db02$ rman target / catalog rman/passwd@rman_cat
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jun 24 09:16:59 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: INFPRD (DBID=4180891465, not open)
connected to recovery catalog database
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u03/oradata/infprd/backup/rman_backup/ora_cf%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COPY;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u03/oradata/infprd/backup/rman_backup/%d_%u_%p_%N_fileno:%f.dbf';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/u03/oradata/infprd/backup/rman_backup/ora_df_%d_%T_%s_%c_%p' CONNECT '*';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/u03/oradata/infprd/backup/rman_backup/ora_df_%d_%T_%s_%c_%p' CONNECT '*';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_infprd2.f';
Inside the script, we run command "BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT '$DATA_FILE_DIR/ora_arch_%d_%s_%T_%c_%p';". And variable $DATA_FILE_DIR=/u03/oradata/instid/backup/rman_backup
But it gives this error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/20/2011 23:03:59
RMAN-06726: could not locate archivelog /u03/app/oracle/infprd/arch/infprd2_1_751803403_1.arc
standby-SQL> select inst_id, name,stamp, completion_time, dest_id,SEQUENCE#,STANDBY_DEST,ARCHIVED,APPLIED,STATUS from gv$archived_log where NAME like '%infprd2_1_751803403_1%';
no rows selected
Following connect strings are used by rman:
INFPRD1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bassmtprd1db01)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = infprd)
(INSTANCE_NAME = infprd1)
)
)
INFPRD2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bassmtprd1db02)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = infprd)
(INSTANCE_NAME = infprd2)
)
)
I have already looked at following metalink notes, but they are not helpful in this scenario:
1. RMAN-03002 and RMAN-06726 While Taking Backup on RAC [ID 258094.1]
2. RMAN-06726: RAC - RMAN Backup of Archivelogs could Not Locate Archivelogs of one Thread [ID 273145.1]
3. OERR: RMAN-6726 could not locate archivelog %s [ID 291435.1]
If this archive was never generated, how come RMAN complaining about something that never existed?
regards,
--
Anjum