RMAN-03009: failure of Control File and SPFILE Autobackup command on


oracle@bakuexa1dbadm01:~$ export ORACLE_SID=MISDEV1
oracle@bakuexa1dbadm01:~$ echo $ORACLE_SID
MISDEV1
oracle@bakuexa1dbadm01:~$ rman
Recovery Manager: Release 11.2.0.3.0 - Production on Mon Jan 26 14:42:58 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /;
connected to target database: MISDEV (DBID=247039367)
RMAN> list backup of database;
using target database control file instead of recovery catalog
specification does not match any backup in the repository
RMAN> backup database plus archivelog;
Starting backup at 26-JAN-15
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=198 instance=MISDEV1 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=2 sequence=12 RECID=32 STAMP=867452734
input archived log thread=1 sequence=21 RECID=34 STAMP=868493750
input archived log thread=2 sequence=13 RECID=33 STAMP=868268670
input archived log thread=2 sequence=14 RECID=35 STAMP=870014632
input archived log thread=1 sequence=22 RECID=36 STAMP=870014634
channel ORA_DISK_1: starting piece 1 at 26-JAN-15
channel ORA_DISK_1: finished piece 1 at 26-JAN-15
piece handle=+RECOC1/misdev/backupset/2015_01_26/annnf0_tag20150126t144355_0.319.870014635 tag=TAG20150126T144355 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 26-JAN-15
Starting backup at 26-JAN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATAC1/misdev/datafile/system.286.865245843
input datafile file number=00003 name=+DATAC1/misdev/datafile/undotbs1.282.865245869
input datafile file number=00004 name=+DATAC1/misdev/datafile/undotbs2.274.865245891
input datafile file number=00002 name=+DATAC1/misdev/datafile/sysaux.285.865245861
input datafile file number=00005 name=+DATAC1/misdev/datafile/users.259.865245909
input datafile file number=00006 name=+DATAC1/misdev/datafile/misdev_data.296.866052191
input datafile file number=00007 name=+DATAC1/misdev/datafile/misdev_index.295.866052211
channel ORA_DISK_1: starting piece 1 at 26-JAN-15
channel ORA_DISK_1: finished piece 1 at 26-JAN-15
piece handle=+RECOC1/misdev/backupset/2015_01_26/nnndf0_tag20150126t144440_0.318.870014681 tag=TAG20150126T144440 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 26-JAN-15
Starting backup at 26-JAN-15
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=23 RECID=38 STAMP=870014690
input archived log thread=2 sequence=15 RECID=37 STAMP=870014690
channel ORA_DISK_1: starting piece 1 at 26-JAN-15
channel ORA_DISK_1: finished piece 1 at 26-JAN-15
piece handle=+RECOC1/misdev/backupset/2015_01_26/annnf0_tag20150126t144452_0.314.870014693 tag=TAG20150126T144452 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JAN-15
Starting Control File and SPFILE Autobackup at 26-JAN-15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 01/26/2015 14:44:54
ORA-00245: control file backup failed; target is likely on a local file system
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 1.15G DISK 00:00:06 26-JAN-15 
 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20150126T144440
 Piece Name: +RECOC1/misdev/backupset/2015_01_26/nnndf0_tag20150126t144440_0.318.870014681
 List of Datafiles in backup set 3
 File LV Type Ckp SCN Ckp Time Name
 ---- -- ---- ---------- --------- ----
 1 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/system.286.865245843
 2 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/sysaux.285.865245861
 3 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/undotbs1.282.865245869
 4 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/undotbs2.274.865245891
 5 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/users.259.865245909
 6 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/misdev_data.296.866052191
 7 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/misdev_index.295.866052211
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name MISDEV are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.3/dbhome_1/dbs/snapcf_MISDEV1.f'; # default
Solution: 

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATAC1/MISDEV/snapcf_MISDEV1.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATAC1/MISDEV/snapcf_MISDEV1.f';
new RMAN configuration parameters are successfully stored
RMAN> show all;
RMAN configuration parameters for database with db_unique_name MISDEV are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATAC1/MISDEV/snapcf_MISDEV1.f';
RMAN> backup database plus archivelog;
Starting backup at 26-JAN-15
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=264 instance=MISDEV1 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=2 sequence=12 RECID=32 STAMP=867452734
input archived log thread=1 sequence=21 RECID=34 STAMP=868493750
input archived log thread=2 sequence=13 RECID=33 STAMP=868268670
input archived log thread=2 sequence=14 RECID=35 STAMP=870014632
input archived log thread=1 sequence=22 RECID=36 STAMP=870014634
input archived log thread=1 sequence=23 RECID=38 STAMP=870014690
input archived log thread=2 sequence=15 RECID=37 STAMP=870014690
input archived log thread=2 sequence=16 RECID=40 STAMP=870016901
input archived log thread=1 sequence=24 RECID=39 STAMP=870016901
channel ORA_DISK_1: starting piece 1 at 26-JAN-15
channel ORA_DISK_1: finished piece 1 at 26-JAN-15
piece handle=+RECOC1/misdev/backupset/2015_01_26/annnf0_tag20150126t152151_0.282.870016911 tag=TAG20150126T152151 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 26-JAN-15
Starting backup at 26-JAN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATAC1/misdev/datafile/system.286.865245843
input datafile file number=00003 name=+DATAC1/misdev/datafile/undotbs1.282.865245869
input datafile file number=00004 name=+DATAC1/misdev/datafile/undotbs2.274.865245891
input datafile file number=00002 name=+DATAC1/misdev/datafile/sysaux.285.865245861
input datafile file number=00005 name=+DATAC1/misdev/datafile/users.259.865245909
input datafile file number=00006 name=+DATAC1/misdev/datafile/misdev_data.296.866052191
input datafile file number=00007 name=+DATAC1/misdev/datafile/misdev_index.295.866052211
channel ORA_DISK_1: starting piece 1 at 26-JAN-15
channel ORA_DISK_1: finished piece 1 at 26-JAN-15
piece handle=+RECOC1/misdev/backupset/2015_01_26/nnndf0_tag20150126t152246_0.269.870016967 tag=TAG20150126T152246 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 26-JAN-15
Starting backup at 26-JAN-15
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=25 RECID=41 STAMP=870016974
input archived log thread=2 sequence=17 RECID=42 STAMP=870016976
channel ORA_DISK_1: starting piece 1 at 26-JAN-15
channel ORA_DISK_1: finished piece 1 at 26-JAN-15
piece handle=+RECOC1/misdev/backupset/2015_01_26/annnf0_tag20150126t152301_0.258.870016981 tag=TAG20150126T152301 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JAN-15
Starting Control File and SPFILE Autobackup at 26-JAN-15
piece handle=+RECOC1/misdev/autobackup/2015_01_26/s_870016982.259.870016983 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-15
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 1.15G DISK 00:00:06 26-JAN-15 
 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20150126T144440
 Piece Name: +RECOC1/misdev/backupset/2015_01_26/nnndf0_tag20150126t144440_0.318.870014681
 List of Datafiles in backup set 3
 File LV Type Ckp SCN Ckp Time Name
 ---- -- ---- ---------- --------- ----
 1 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/system.286.865245843
 2 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/sysaux.285.865245861
 3 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/undotbs1.282.865245869
 4 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/undotbs2.274.865245891
 5 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/users.259.865245909
 6 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/misdev_data.296.866052191
 7 Full 21732688 26-JAN-15 +DATAC1/misdev/datafile/misdev_index.295.866052211
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 1.15G DISK 00:00:06 26-JAN-15 
 BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20150126T152246
 Piece Name: +RECOC1/misdev/backupset/2015_01_26/nnndf0_tag20150126t152246_0.269.870016967
 List of Datafiles in backup set 6
 File LV Type Ckp SCN Ckp Time Name
 ---- -- ---- ---------- --------- ----
 1 Full 21739134 26-JAN-15 +DATAC1/misdev/datafile/system.286.865245843
 2 Full 21739134 26-JAN-15 +DATAC1/misdev/datafile/sysaux.285.865245861
 3 Full 21739134 26-JAN-15 +DATAC1/misdev/datafile/undotbs1.282.865245869
 4 Full 21739134 26-JAN-15 +DATAC1/misdev/datafile/undotbs2.274.865245891
 5 Full 21739134 26-JAN-15 +DATAC1/misdev/datafile/users.259.865245909
 6 Full 21739134 26-JAN-15 +DATAC1/misdev/datafile/misdev_data.296.866052191
 7 Full 21739134 26-JAN-15 +DATAC1/misdev/datafile/misdev_index.295.866052211
RMAN> exit
Recovery Manager complete.
oracle@bakuexa1dbadm01:~$

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: