Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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