erro ao criar arquivo de backup - backup oracle

R_mulo_Pacheco · ‎01-25-2010

Pessoal, preciso de um auxilio em um backup do nosso servidor oracle.

está ocorrendo o seguinte log de erro. percebi que ele aponta um arquivo para o caminho E:\BACKUP\ORACLE\CRMPRD\
porém no nosso servidor o caminho ta diferente ta assim: E:\oracle\oradata\crmprd

eu imagino que seja por isso que dá o erro porém não sei como alterar esse caminho, se isso faço no backup exec ou no oracle.. se alguem puder me ajudar ficarei grato :)

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jan 25 12:23:30 2010

# -----------------------------------------------------------------

# RMAN command section

# -----------------------------------------------------------------

RUN {

ALLOCATE CHANNEL ch0

TYPE 'SBT_TAPE';

SEND 'BSA_SERVICE_HOST=172.16.32.5,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={7274632C-A98F-442C-A758-6418E9EC1572},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\brsjpora01.alila.aliaxisla.com\crmprd';

BACKUP

INCREMENTAL LEVEL=0

FORMAT 'BE_U'

TABLESPACE

'USERS' FORCE;

RELEASE CHANNEL ch0;

}

connected to target database: CRMPRD (DBID=234024243)

using target database control file instead of recovery catalog

allocated channel: ch0

channel ch0: sid=298 devtype=SBT_TAPE

channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0

Starting backup at 25-JAN-10

channel ch0: starting incremental level 0 datafile backupset

channel ch0: specifying datafile(s) in backupset

input datafile fno=00004 name=E:\ORACLE\ORADATA\CRMPRD\USERS01.DBF

channel ch0: starting piece 1 at 25-JAN-10

channel ch0: finished piece 1 at 25-JAN-10

piece handle=BE_1il4bhi7_1_1 tag=TAG20100125T122335 comment=API Version 2.0,MMS Version 1.1.0.0

channel ch0: backup set complete, elapsed time: 00:00:03

Finished backup at 25-JAN-10

Starting Control File and SPFILE Autobackup at 25-JAN-10

released channel: ch0

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

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

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

RMAN-03009: failure of Control File and SPFILE Autobackup command on ch0 channel at 01/25/2010 12:23:45

ORA-01580: error creating control backup file E:\BACKUP\ORACLE\CRMPRD\SNAPCF_CRMPRD.F

ORA-27040: file create error, unable to create file

OSD-04002: unable to open file

O/S-Error: (OS 3) The system cannot find the path specified.

Recovery Manager complete.

R_mulo_Pacheco · ‎01-25-2010

podem ignorar o pedido.. ia tentar alterar mas resolvi por criar a pasta e aparentemente deu certo. :)

Dev_T · ‎01-25-2010

Hello,

Look at this thread:

https://www-secure.symantec.com/connect/forums/how-configure-backup-exec-oracle-agent-practical-step-step-instructions

VOX

erro ao criar arquivo de backup - backup oracle