Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

backup database include current controlfile plus archivelog; with CONTROLFILE AUTOBACKUP is ON

DBA092012Aug 22 2016 — edited Aug 22 2016

Hello everybody.

I have oracle 12.1.0.2 two-node RAC . I see that autobackup does not work in my case. Please advise.

Here is the output of some commands :

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ERP_TEST are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

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 RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/snapcf_erp_test.f';

$ cat /home/oracle/rman/backup.rman

run

{

crosscheck backup;

crosscheck archivelog all;

delete noprompt obsolete;

backup database include current controlfile plus archivelog;

backup validate check logical database archivelog all;

restore validate database;

report unrecoverable;

}

$ rman target=/ cmdfile=/home/oracle/rman/backup.rman log=/home/oracle/rman/create_backup_`date +%Y-%m-%d`.log

cat /home/oracle/rman/create_backup_`date +%Y-%m-%d`.log | less

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Aug 22 16:01:23 2016

connected to target database: ERP_TEST (DBID=1690836671)

RMAN> run

2> {

3> crosscheck backup;

4> crosscheck archivelog all;

5> delete noprompt obsolete;

6> backup database include current controlfile plus archivelog;

7> backup validate check logical database archivelog all;

8> restore validate database;

9> report unrecoverable;

10> }

11>

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=302 instance=erptest_2 device type=DISK

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/AUTOBACKUP/2016_08_15/s_919956483.419.919956485 RECID=1 STAMP=919956484

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/AUTOBACKUP/2016_08_16/s_920020975.335.920020977 RECID=2 STAMP=920020976

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/AUTOBACKUP/2016_08_16/s_920024276.334.920024277 RECID=3 STAMP=920024277

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/AUTOBACKUP/2016_08_16/s_920026521.333.920026523 RECID=4 STAMP=920026522

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/BACKUPSET/2016_08_19/annnf0_tag20160819t161541_0.321.920304945 RECID=5 STAMP=920304944

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/BACKUPSET/2016_08_19/annnf0_tag20160819t161541_0.320.920304971 RECID=6 STAMP=920304970

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/BACKUPSET/2016_08_19/nnndf0_tag20160819t161636_0.319.920304997 RECID=7 STAMP=920304996

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/3A1C3BB9A06D2415E053971010ACD721/BACKUPSET/2016_08_19/nnndf0_tag20160819t161636_0.318.920305043 RECID=8 STAMP=920305042

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/3A1C0660EBAF03E8E053971010AC0572/BACKUPSET/2016_08_19/nnndf0_tag20160819t161636_0.317.920305067 RECID=9 STAMP=920305067

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/BACKUPSET/2016_08_19/ncnnf0_tag20160819t161636_0.316.920305083 RECID=10 STAMP=920305083

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/BACKUPSET/2016_08_19/annnf0_tag20160819t161805_0.313.920305087 RECID=11 STAMP=920305086

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=+FRA/ERP_TEST/AUTOBACKUP/2016_08_19/s_920305087.312.920305087 RECID=12 STAMP=920305087

Crosschecked 12 objects

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=302 instance=erptest_2 device type=DISK