Fix RMAN-20242: Specification Does Not Match Any Archive Log

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Error Description:
RMAN> run
2> {
3>  backup as copy archivelog from sequence 700 until sequence 710 format '+RECO/%d/BACKUPS/PROD2_%t_%s_%r.arc';
4> }


Starting backup at 29-NOV-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5 instance=PROD21 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=524 instance=PROD21 device type=DISK
specification does not match any archived log in the repository
backup cancelled because there are no files to backup
Finished backup at 29-NOV-11

Solution Description:

This is a RAC database and the thread number is not specified in the backup command. You should specify the command in the following format.

backup as copy archivelog from sequence 700 until sequence 710 thread 2 format '+RECO/%d/BACKUPS/PROD2_%t_%s_%r.arc';

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer