Database Software

Hello,

Last week we had a SAN crash and both our primary and dataguard databases were affected. In order to get the primary up we had to restore the control file from autobackup, recover, then open reset logs. We have been back up since Friday and I had to rebuild the dataguard but I am getting errors on the recovery. We take full RMAN backups every night. Today I issued the following commands to rebuild the dataguard.

On primary

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 3;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
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_64/Db_1/dbs/snapcf_bcso.f'; # default


SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
RMAN>BACKUP ARCHIVELOG ALL NOT BACKED UP 1 TIMES;
RMAN> BACKUP CURRENT CONTROLFILE FOR STANDBY;

scp today backupset folder to SCP site.

On standby

RMAN> restore standby controlfile from '/<standby control>';

RMAN> run {
ALLOCATE CHANNEL c1 DEVICE TYPE DISK ;
restore database;}

RMAN> list backup of archivelog all; --Max seq = 793

RMAN> recover database until sequence 794;

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01190: control file or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/u01/app/oracle/oradata/bcso/system01.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/07/2013 14:27:28
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 595 lowscn 10841587866338 found to restore
.
.
.
RMAN-06025: no backup of log thread 1 seq 542 lowscn 10841534510522 found to restore
MAN-06025: no backup of log thread 1 seq 541 lowscn 1084153449
Recovery Manager complete.


I understand it wants these files but why does it want them when I did a full backup and backup of all archivelogs since the full backup? Why does it want the older archivelogs than the backup itsself? The dataguard is up but its only taking the new archivelogs and not applying them. It is not fixing the gaps. There shouldn't be any gaps since I moved over the full backup and archivelogs since the backup.

Thanks