2

I perform oracle database backup using the following rman command:

RUN { 
    ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'C:\Windows\TEMP\%u'; 
    ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT 'C:\Windows\TEMP\%u'; 
    BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG TAG MyTAG; 
}

But unfortunately MyTag is applied only for archive logs BS. The query list backup; return 6 rows:

BS of archive logs;
BS of data files;
BS of data files;
BS of data spfile;
BS of data controlfile;
BS of archive logs;

The query list backup summary tag 'MyTag'; return only 2 rows

BS of archive logs;
BS of archive logs;

How to apply TagName for all backup files ?

1
  • 1
    Try to change BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG TAG MyTAG; to BACKUP AS COMPRESSED BACKUPSET TAG MyTAG DATABASE PLUS ARCHIVELOG;
    – Popeye
    Jul 4, 2019 at 15:20

1 Answer 1

3

Specify the tag for the database backup as well:

BACKUP AS COMPRESSED BACKUPSET DATABASE TAG MyTAG PLUS ARCHIVELOG TAG MyTAG; 

Ok, I tested this, this does not add the specified tag to the controlfile backup. The below creates an additional controlfile backup and adds the specified tag to that as well:

BACKUP AS COMPRESSED BACKUPSET DATABASE TAG MyTAG INCLUDE CURRENT CONTROLFILE PLUS ARCHIVELOG TAG MyTAG; 
2
  • and what about spfile ?
    – isxaker
    Jul 4, 2019 at 15:52
  • @isxaker Just add backup spfile tag MyTAG;. Jul 4, 2019 at 15:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.