Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Error backup Oracle 8.0.4 ORA-19506

Jesus Fdez.
Valued Contributor

Error backup Oracle 8.0.4 ORA-19506

Hi all, I have DP 5.10 in WinXP with integration oracle 8.0.4, when I execute one backup I obtain this:

Recovery Manager: Release 8.0.4.0.0 - Production

RMAN>
RMAN-06005: connected to target database: CEM3000

RMAN>
RMAN-06008: connected to recovery catalog database

RMAN>
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=cem3000,OB2BARLIST=Prueba_804)';
4> allocate channel 'dev_1' type 'sbt_tape'
5> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=cem3000,OB2BARLIST=Prueba_804)';
6> allocate channel 'dev_2' type 'sbt_tape'
7> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=cem3000,OB2BARLIST=Prueba_804)';
8> allocate channel 'dev_3' type 'sbt_tape'
9> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=cem3000,OB2BARLIST=Prueba_804)';
10> backup incremental level 0 filesperset 1
11> format 'Prueba_804.dbf'
12> tablespace AJUS01_DATA
13> current controlfile
14> ;
15> backup filesperset 1
16> format 'Prueba_804.dbf'
17> archivelog all
18> ;
19> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev_0
RMAN-08500: channel dev_0: sid=11 devtype=SBT_TAPE

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev_1
RMAN-08500: channel dev_1: sid=8 devtype=SBT_TAPE

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev_2
RMAN-08500: channel dev_2: sid=20 devtype=SBT_TAPE

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: dev_3
RMAN-08500: channel dev_3: sid=26 devtype=SBT_TAPE

RMAN-03022: compiling command: backup
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03023: executing command: backup
RMAN-08008: channel dev_0: starting datafile backupset
RMAN-08502: set_count=349 set_stamp=537638816
RMAN-08010: channel dev_0: including datafile 11 in backupset
RMAN-00569: ================error message stack follows================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel dev_0
RMAN-10032: unhandled exception during execution of job step 1: ORA-06512: at line 85
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry possible
ORA-19506: failed to create sequential file, name="Prueba_804<537638816:1>.dbf", parms=""
ORA-27000: skgfqpini: failed to initialize storage subsystem (SBT) layer
HP-UX Error: 1602: Unknown system error
Additional information: 7110
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 408
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

RMAN> **end-of-file**

RMAN>
RMAN-08031: released channel: dev_0
RMAN-08031: released channel: dev_2
RMAN-08031: released channel: dev_3

Could you help me?

Thanks

Jesus Fdez.
3 REPLIES
Marcel Boogert_1
Trusted Contributor

Re: Error backup Oracle 8.0.4 ORA-19506

Jesus,

ORA-19506: failed to create sequential file

Have you searched http://metalink.oracle.com for this message?

MB.
Eric Antunes
Honored Contributor

Re: Error backup Oracle 8.0.4 ORA-19506

Hi Jesus,

"ORA-19506: failed to create sequential file, name=name, parms=name

Cause: A call to create the sequential file returned an error. Most likely the access permissions were set incorrectly.

Action: One or more other messages should be displayed to help pinpoint the cause of the error. Check access permissions and correct if necessary. Then retry the operation. "

The most common error are on the permissions for the target of filesets.
Each and every day is a good day to learn.
Indira Aramandla
Honored Contributor

Re: Error backup Oracle 8.0.4 ORA-19506

Hi Jesus,

Most of the time these are error messages when the 3rd party tape library is not linked correctly.

ORA-19506: failed to create sequential file, name="df_BACK8A_1_0ccbh4ru", parms= ""
ORA-27000: skgfqpini: failed to initialize storage subsystem (SBT) layer
Additional information:

When errors occur through the SBT interface, the true error is shown by Recovery Manager as an 'Additional Information' message. Bellow is the list of 'Additional Information' message numbers, and the corresponding error text.

In your case the it reports

ORA-27000: skgfqpini: failed to initialize storage subsystem (SBT) layer
HP-UX Error: 1602: Unknown system error
Additional information: 7110

Metalink says the errors prefixed with '*' are internal and should never be seen during normal operation.

The Additional information 7110 as given in the list of 'Additional information' message numbers, and the corresponding error text has a â *â as a prefix.

And the error text says it is an error code for sbtinit: 7110 meaning
â Invalid argument(s) to sbtinitâ
Never give up, Keep Trying