Hello,
db=11.2.0.3 on rhl
db1rq - primary
db2rq - Physcical standby
I am informed that there are some missing archivelogs on the physical standby db. I have to find out which one are missing and restore from backup. I would appreciate the help.
I dont know where to look and start. At the moment I have only found out this. I dont know its the right direction or not.
# db2rq .. phy.standbydb
1* SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG where APPLIED='NO'
SEQUENCE# APP
---------- ---
188655 NO
188656 NO
# db1rq . Primary
1* SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG where APPLIED='NO'
188657 NO
188658 NO
- - - - - -
196254 NO
196255 NO
7599 rows selected. ------------------ Is this NORMAL?
# db2rq. phystandby db
$ rman target /
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 28 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 '/remote/backup/cha/%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/remote/backup/cha/%U' MAXPIECESIZE 2000 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
Does this NO in APPLIED column of standby db represents missing archivelogs or there is some other way to find out? Right now I have no such idea what happened, this is new DB and some archival stuck on standby db, something clearing Flash recovery area space..deleting pieces to free space doesnt on Primary doesnt applied to standby
Thanks a lot
Regards
Edited by: John-M on Jun 11, 2012 9:05 AM