Problém
RMAN-06214: Archivelog /mnt/backup/orcl/archlog1_351_893193559.arc
RMAN-06214: Archivelog /mnt/backup/orcl/archlog1_352_893193559.arc
RMAN-06214: Archivelog /mnt/backup/orcl/archlog1_353_893193559.arc
ORA-00245: control file backup failed; target is likely on a local file system
RMAN-08132: WARNING: cannot update recovery area reclaimable file list
Řešení
RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‚/u01/app/oracle/product/11.2.0.4/dbhome_2/dbs/snapcf_orcl2.f‘; # default
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‚+RECO/snapcf_orcl.f‘;
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‚+RECO/snapcf_orcl.f‘;
new RMAN configuration parameters are successfully stored
RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name orcl are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‚+RECO/snapcf_orcl.f‘;
RMAN> delete archivelog all; —> OK
Druhá chyba (díky nedokončenému RMAN DUPLICATE)
crosscheck backup nic neudělá.
Do you really want to delete the above objects (enter YES or NO)? yes
RMAN-06207: WARNING: 283 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: ————— —————————————————
RMAN> crosscheck copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=175 instance=orcl2 device type=DISK
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
RMAN> delete expired copy;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=175 instance=orcl2 device type=DISK
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
List of Archived Log Copies for database with db_unique_name orcl
=====================================================================