This content has been marked as final. Show 13 replies
Seems you have gaps in standby, see following link for resolving gaps
Managing physical standby
There is another way to resolve by taking back from current SCN in standby database and applying to standby.
I have also faced same problem.
Archive was backed up & deleted from the archive location, but while doing backup testing on new server database was asking for last archivelog though it was backed up during backup.
Is there is any solution to this.
Hi Abhay K ,
What is your method of deleting your previous archivelogs? Is it OS command?
If OS command, your controlfile might not be updated so it treats that those archivelogs are still available in your disk. You should update your controlfile when deleting archivelogs using OS command.
RMAN> crosscheck archivelog all; // validate all archvelogs in your disk. If some are missing, it will treat it as expired.
RMAN> delete expired archivelog all; // it ill delete expired archivelog and updates your controlfile.
Check the V$BACKUP view on both the sites, there will be difference in the backup
We are not deleting the archive logs manually, below is the script that we are using.
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
sql 'alter system switch logfile';
backup as compressed backupset incremental level 0
backup as compressed backupset archivelog all format 'E:\script\compress\bak1\arch_%U.bak' delete input;
but while restoring the database on different host system was asking the archive log wchich was backed up during backup.
Can you cross check once again your backups.
- Pavan Kumar N
Oracle 9i/10g - OCP
"restoring the database on 'different host system' "?
Does that host system have exisiting database and archivelogs and you are just updating it with new database by restoring the backup from your production?
is the destination of archivelogs and datafiles from your source to your 'different host system' the same?
Since no extra system was avaliable we decided to perform the testing on one of the standby database system we have. standby system is having same mount points as the prod system.
Is autobackup of controlfile in RMAN enabled? You sure you restore it first before restoring the backup of database?
I already experienced this kind of problem. In standby database, there are exisiting archivelogs that are being cataloged
when I restore my backup of controlfile and mounting the database. What I did is delete this archivelogs in the standby server
and perform restore and recover of the database.
I will check, I think I have not configured the control file auto backup, I will check & enable it.
Also i will try restore & recovery by deleting all the archives from standby.
is this solved?
yeah, is this resolved? I have such a similar problem too :(
although my standby is now the active one (i switched them), and my primary is also active but not used as prod,
and I just leave it for testing. but why is my RMAN failed when I backup this old primary?
864312 wrote:given that the thread was opened FOUR YEARS ago, and last resuscitated THREE YEARS ago .....
is this solved?