Problemas con Rman 9i

Sasa
12 de Septiembre del 2008
Alguien me podría ayudar a resolver un pequeño problema que tengo con una recuperación?
Mi situación es la siguiente:
- 2 máquinas AIX 5L en HACMP (host1 y host2)
- Veritas Netbackup 4.5MP6
- Rman 9.2.0.5
- B.D. en Oracle 9.2.0.5

He hecho hot backup de un BD de test con Rman y NB en host1.
Borro un tablespace de usuario y recupero con éxito.
Basculamos host1 a host2, de forma que todos los servicios son recogidos por Host2.
Hacemos la misma operación de borrar un tablespace de usuario y me da el siguiente error.

**********************************************************************
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=42 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: VERITAS NetBackup for Oracle - Release 4.5MP6 (00000000)
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=37 devtype=DISK
channel ORA_SBT_TAPE_1: starting datafile backupset restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /db/DBREP/dat/PRUEBAS.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/13/2004 09:07:26
ORA-19507: failed to retrieve sequential file, handle="BK_DBREP_26_1_530969494", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
sbtrestore: Backup file not found.
**********************************************************************

La cinta es la misma que en la que hice la prueba en el host 1 --> la cinta es correcta, el backup existe y funciona.
La libobk.a esta lincada correctamente.
Netbackup salva y recupera ficheros de SO indistintamente en host1 que en host2, por lo que el NB tb funciona bien.
Alguien puede darme un idea de por donde continuar?




Manny
12 de Septiembre del 2008
Hi,

Puedes provar a eseguir este tipo de solucion,
seguramente hay problemas con el netbackup.

The error "ORA-19511: sbtrestore: Failed to open for restore" essentially means that there is some issue in Netbackup.

If this is a new installation of Netbackup and it is first time restore, then ensure that Netbackup installation and configuration is fine.

Check the installation/configuration with :
$ su - oracle
$ cd $ORACLE_HOME/bin
$ sbttest test

This is suppose to return 0 or 1.
Sometime this command returns the following:

The sbt function pointers are loaded.

Return code -1 from sbtinit, bsercoer = 4110, bsercerrno = 0 Message 4110 not found; product=RDBMS; facility=SBT

Then check the availability of disk space where Netbackup writes its log files.

If there is NO space in the disk, you may see the above error. The location of the logfiles normally is : /usr/openv/netbackup/logs


bye,
suerte.

Manny
12 de Septiembre del 2008
Hi,

O visto este documento de Veritas NetBackup.

Causa: The oracle user for the restore does not match the user id used to perform the database backup.



fix:

See the Veritas Support TechNote ID 245192 for a detailed description of the problem. This note also describes three workarounds.

One workaround is to temporarily remove the setuid permissions of the $ORACLE_HOME/bin/oracle executable on the target server long enough to do the Rman restore operation. As root, issue

# chmod u-s $ORACLE_HOME/bin/oracle

Reset the original setuid permissions after the restore. As root, issue

# chown u+s $ORACLE_HOME/bin/oracle

Reference:

Veritas Support TechNote ID: 245192

bye
Suerte

Manny
12 de Septiembre del 2008
Hi,

O visto esto:

The error "ORA-19511: sbtbackup: Failed to open for backup" essentially means that there is some issue in Netbackup. Possible causes are :

a) You try to run more backups that the class frequency provided for.

These extra backups, over the specificed fequency would not run. To avoid this error, Increase class frequency for suplementary backups.

b) When you run the backups manually by executing the backup scripts normally used by RMAN. Normally the NBU client binaries run as root and, not surprisingly, the processes they start run as root too.

The default permissions to write to the NBU client log files is root as well. However, when a db extension backup is run a script is executed on the client that will normally exec the backup from the dba account.

What we are looking at in this log is a permissions problem on these client log files.

To change permissions, chmod 777 to these client directories and the log files in them:

/usr/openv/netbackup/logs/user_ops,
/usr/openv/netbackup/logs/bphdb,
/usr/openv/netbackup/logs/dbclient.

bye,
suerte.

Jago
12 de Septiembre del 2008
Hola no se si es demasiado tarde
solucionastes tu problema, sino te comunicas conmigo
[email protected]

Adios

Javier