September 2010

Author Archive

Problemas con RMAN - RMAN-03009

5. May 2008 by coberreuter.

Tengo el siguiente error con RMAN:

RMAN-03009: failure of allocate command on t1 channel at 04/30/2008 22:42:08 ORA-03113: end-of-file on communication channel

el script es el siguiente:

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Apr 30 22:42:01 2008

connected to target database: QLCNT (DBID=4121126273)

connected to recovery catalog database

RMAN> run {

2> allocate channel t1 type ’sbt_tape’

3> parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo_h.opt)’;

5> # realiza un backup del controlfile to trace, queda en el udump.

6> sql ‘alter database backup controlfile to trace’;

8> # respaldar base datos.

9> backup incremental level = 0

10> filesperset 6

11> tag = ‘qlcnt_lv0′

12> format ‘qlcnt_df_men_%T_%u’

13> database keep until time ’sysdate+9999′ logs;

14>

15> # respaldar archivelogs

16> backup format ‘qlcnt_ar_men_%T_%u’ archivelog all delete input;

17>

18> release channel t1;

19> }

20>

21>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of allocate command on t1 channel at 04/30/2008 22:42:08

ORA-03113: end-of-file on communication channel