RMAN> backup database plus archivelog;
SQL> alter database open resetlogs;
your restore script is ok.
SHUTDOWN; STARTUP MOUNT; BACKUP DATABASE PLUS ARCHIVELOG; exit;
The following archive log sequence 24565 is unavailable for RMAN to backup. Uncatalog the archive log sequence and backup the full database.
ORA-19625: error identifying file /opt/app/oracle/oradata/archive/TECHDATA/arch_24565.arc ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3
RMAN>change archivelog sequence 24565 uncatalog;
Vidhya.V wrote:Looks like the expected archivelog has gone missing. I suspect you've been doing housekeeping outside of rman. If the requested archivelog (/opt/app/oracle/oradata/archive/TECHDATA/arch_24565.arc) was backed up at the OS level, you could restore it from that backup, then repeat your rman backup. But if that is the case, I also suspect there is a boat-load of other archives that would need to be restored. The only other way around would be to write-off those archives, accept the fact that you have a period of time for which you cannot recover your database, and start fresh. First thing you'd need to do in that case is to CROSSCHECK your archivelogs, then DELETE EXPIRED. Then immediately take a full Inc 0 backup plus archivelogs. then you need to review your entire backup methodology. You should be using rman to back up both the database and archivelogs. You should be using rman to delete archivelogs once they are backed up. You should be using rman to crosscheck for missing backups and archivelogs - and investigate why they went missing. You should use rman to delete any expired backups or archivelogs (expired means the crosscheck found they had gone missing). You should use rman to delete obsolete backups. In short, you should use rman for all backup and recovery management operations. Any time you try to do things outside of rman, then rman has no way of knowing what you've done and is unable to do its job properly.
i am getting the below error if i give BACKUP DATABASE PLUS ARCHIVELOG through RMAN Prompt. Please suggest
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Starting backup at 26-DEC-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=16 devtype=DISK
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of backup command at 12/26/2012 11:20:46
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /opt/app/oracle/oradata/archive/TECHDATA/arch_24565.arc
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Kindly let me know if i nedd to make changes in the default configuration. Currently my configuration isI'd review the retention policy to make sure you can meet your requirements.
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # defaultI'd turn optimization on.
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/opt/backup/RMAN/rbackup/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
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 '/opt/backup/RMAN/rbackup/%d_%T_%s_%p' MAXPIECESIZE 4 G;
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/app/oracle/product/9.2.0/dbs/snapcf_TECHDATA.f'; # default
Please help me in recovering the entire database.