why command:"brbackup -d rman_util -m all" not execute switch logfile

[xue_nan]

When I backup Oracle RAC Database 11.2 using command:"brbackup -d rman_util -m all",I find the detail log did not perform logfile switch,just list current archive log:

BR0280I BRBACKUP time stamp: 2014-04-03 17.30.47
BR0502I Normal database backup using RMAN successful

BR0280I BRBACKUP time stamp: 2014-04-03 17.30.51
BR0319I Control file copy created: /oracle/HSP/sapbackup/cntrlHSP1.dbf 24166400

BR0117I ARCHIVE LOG LIST after backup for database instance HSP1

Parameter                      Value

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +ARCH/hsp/oraarch
Archive format                 %t_%s_%r.dbf
Oldest online log sequence     535
Next log sequence to archive   542
Current log sequence           542              SCN: 300631249
Database block size            8192             Thread: 1
Current system change number   300754472        ResetId: 840633919

BR0117I ARCHIVE LOG LIST after backup for database instance HSP2

Parameter                      Value

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +ARCH/hsp/oraarch
Archive format                 %t_%s_%r.dbf
Oldest online log sequence     484
Next log sequence to archive   491
Current log sequence           491              SCN: 300531873
Database block size            8192             Thread: 2
Current system change number   300754535        ResetId: 840633919

Do I need to added statement:'alter system archive log current' in the backup script ,or there is a better solution.

[SymTerry]

Hello,

Yes, the 'alter system archive log current' command is needed to  do a log switch within RMAN.

By default, NetBackup includes this command in their sample scripts.  These scripts are located in the directory /usr/openv/netbackup/ext/db_ext/oracle/samples/rman.

Here is a snippet of the hot_database_backup.sh 

RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
    $BACKUP_TYPE
    SKIP INACCESSIBLE
    TAG hot_db_bk_level0
    FILESPERSET 5
    # recommended format
    FORMAT 'bk_%s_%p_%t'
    DATABASE;
    sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
   filesperset 20
   FORMAT 'al_%s_%p_%t'
   ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;

[Nicolai]

When using SAP brbackup utility the RMAN script is generated automatic. You can't alter it - as far as I can remember.

Doesn't SAP backup the archive files after wards  ?

[xue_nan]

/usr/openv/netbackup/ext/db_ext/oracle/samples/rman just for Oracle agent,not using sap brtools,and not using backint interface.I look forward to using the SAP Agent,in order to use Tcode DB14 monitor database backup.

Script sample I reference  is /usr/openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/sap_rman_backup.

Command:

brbackup -d rman_util -t online -m full -c

I understand that this script is complete switch logs automatically after the data file backup, but in fact it does not switch

[Nicolai]

doesn't SAP do this later when running the archive part after the backup ?

Attach the output from brbackup to a post as a file please.