‘When
I despair, I
remember that all through history the ways of truth and love
have always won. There have been tyrants, and murderers, and for
a time they can seem invincible, but in the end they always
fall. Think of it - always.’ Gandhi |
CAN NOT USE BACKUP/RESTORE OF EM APPLICATION SERVER CONTROL
When I try to use the EM application server control backup/restore option I get
the following errors:
allocated channel: dev1
channel dev1: sid=364 devtype=DISK
Starting backup at 14-JUN-06
current log archived
released channel: dev1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 06/14/2006 13:14:04
RMAN-06059: expected archived log not found, lost of archived log compromises
recoverability
ORA-19625: error identifying file
/u04/oradata/db4grid/archive/1_100_580828963.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
### Detail any error numbers, or error messages that you are receiving. See Not
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 06/14/2006 13:14:04
RMAN-06059: expected archived log not found, lost of archived log compromises
recoverability
ORA-19625: error identifying file
/u04/oradata/db4grid/archive/1_100_580828963.dbf
ORA-27037: unable to obtain file status
In order that you can take the backup, you need to execute the RMAN Command "crosscheck archivelog all" in order that this command validates if the archivelog file exist physically on the disk. I
f the file does not exist physically, then RMAN changes the status of this archivelog file to Expired and when you try to take the abckup, RMAN will not try to
take the backup of this file.
- You can not execute the RMAN Command "crosscheck" using EM application server control.
On the server where the database is running, to do :
+ Check if ORACLE_SID has the correct value :
$ echo $ORACLE_SID
+ Start RMAN :
$ rman target /
RMAN> crosscheck archivelog all;
+ Now, try to take the backup using EM application server control.
Is very important that you know the following : If in any moment you restore any backup of your database and the archivelog file with sequence 100 is required, you will not able to apply this archivelog file because RMAN did not take the backup of this file because this file was deleted via Operating system.
|