Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

DBA-initiated backup/restore job

Created: 05 Dec 2012 • Updated: 12 Apr 2013 | 2 comments
hidetoshi_hishinuma@dell.com's picture
This issue has been solved. See solution.

Hello guys,

My environment runs backup exec 2012 with Oracle agents on 2 RAC nodes.

Backups initiated from backup exec server (single job) runs FINE.

For testing purposes, our DBA decided to initiate a backup from one oracle RAC node. Lets say, node1.

Using default template for dba-initiated backups.

We tried to start the backup by using the following code:

RUN {
ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=10.10.2.10,NBBSA_TOTAL_STREAMS=1,NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\RAC-ECP-1713844555\ECP';
BACKUP
     FORMAT 'BE_U'
     ARCHIVELOG ALL FORCE NOT BACKED UP;
BACKUP CURRENT CONTROLFILE
     FORMAT 'BE_U';

RELEASE CHANNEL ch0;
}
 

Note that we removed NBBSA_JOB_COOKIE parameter that is automatically generated when starting a backup from the backup server.

See below the RMAN job log provided by DBA.

#########################################

RMAN> RUN {
2> ALLOCATE CHANNEL ch0
3> TYPE 'SBT_TAPE';
4> SEND
'BSA_SERVICE_HOST=10.10.2.10,NBBSA_TOTAL_STREAMS=1,NBBSA_DB_DEVICE_NAME
=Oracle-Win::\\RAC-FPWPRD-2128741988\FPWPRD';
5> BACKUP
6> FORMAT 'BE_U'
7> ARCHIVELOG ALL FORCE NOT BACKED UP;
8> BACKUP CURRENT CONTROLFILE
9> FORMAT 'BE_U';
10>
11> RELEASE CHANNEL ch0;
12> }

canal liberado: ORA_DISK_1
canal alocado: ch0
canal ch0: SID=598 instÔncia=fpwprd2 tipo de dispositivo=SBT_TAPE
canal ch0: Symantec/BackupExec/1.1.0

comando enviado para o canal: ch0

Iniciando backup em 05/12/12
log atual arquivado
canal ch0: iniciando conjunto de backups de log arquivado
canal ch0: especificando log(s) arquivado no conjunto de backups
thread do log arquivado de entrada=1 sequÛncia=829 RECID=204 STAMP=801236372
thread do log arquivado de entrada=2 sequÛncia=428 RECID=202 STAMP=801234136
thread do log arquivado de entrada=2 sequÛncia=429 RECID=203 STAMP=801236368
thread do log arquivado de entrada=2 sequÛncia=430 RECID=207 STAMP=801241253
thread do log arquivado de entrada=1 sequÛncia=830 RECID=205 STAMP=801240211
thread do log arquivado de entrada=1 sequÛncia=831 RECID=206 STAMP=801241250
canal ch0: iniciando o componente 1 em 05/12/12
canal ch0: componente 1 finalizado em 05/12/12
handle de componente=BE_U tag=TAG20121205T150058 comentßrio=API Version
2.0,MMS
Version 1.1.0.0
canal ch0: conjunto de backups concluÝdo, tempo decorrido: 00:02:15
Finalizado backup em 05/12/12

Iniciando backup em 05/12/12
canal ch0: iniciando conjunto de backup completo de arquivo de dados
canal ch0: especificando arquivo(s) de dados no conjunto de backups
incluindo arquivo de controle atual no conjunto de backups
canal ch0: iniciando o componente 1 em 05/12/12
canal liberado: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: falha do comando backup no canal de ch0 em 12/05/2012 15:03:34
ORA-19506: falha ao criar arquivo sequencial, nome="BE_U", parms=""
ORA-27028: skgfqcre: sbtbackup retornou erro
ORA-19511: Erro recebido da camada do gerenciador de mÝdia, texto do erro:
BEError(0xe0001500) A opera┐ foi finalizada devido a um erro de sistema.
 

#########################################

Im sorry! RMAN error output is in portuguese.

ORA-19511 - error received from media manager.

Although RMAN reported such error I could see that about 3GB of archives were transfered successfully.

Does anyone knows the correct syntax of RMAN SEND parameters for DBA-initiated backups?

Do I need to specify the dba-initiated template to use?

Thank you in advance,

Hide

Comments 2 CommentsJump to latest comment

swati's picture

Hello,

You need not specify parameters in "send" command. Also , BE will use DEFAULT DBA template, so you need not specify it, if you intend to use DEFAULT template. Job cookie is required , iff you are running multiple RMAN scripts at a time and want BE to create separate jobs for those scripts. Otherwise cookie is also not required. Here is the sample RMAN script which you can run.

RMAN> run {allocate channel ch0 type 'sbt_tape';backup incremental level=0 format 'BE_%U' database force plus archivelog force not backed up;backup current controlfile format 'BE_%U';release channel ch0;}

Thanks & Regards,

Swati

SOLUTION
hidetoshi_hishinuma@dell.com's picture

Swati,

Thanks for your reply.

Will mark this as a solution.

Regards,
Hide