Versions of NETBACKUP... 64 / 32???? 1

[B14speedfreak]

Hi all,

Thanks in advance for any replies and for reading. To be honest I am not sure if I am in the right forum when asking this as it could be an oracle question as well.

Anyhow, we have been running hot backups for one of our test boxes (one which we would definately want to be able to restore). The backups seems to work well, although we have not tried to do a restore of it as of yet. In Oracle you can do a restore validate, where oracle reads the backups and checks weather the restore could be done from this backup. The Oracle database and the netbackup server and tape drive are all on one solaris 8 box, we are pretty sure the OS is 64bit (used a isainfo -kv to find out this).

Problem is I have not been able to run a restore validate on this box. It errors out with the following:

lsi# more DEMO_validate.log
Sun Microsystems Inc. SunOS 5.8 Generic Patch October 2001

Recovery Manager: Release 8.1.7.3.0 - Production

RMAN>
RMAN>
RMAN-06005: connected to target database: DEMO (DBID=3322509280)

RMAN>
RMAN-06008: connected to recovery catalog database

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=11 devtype=SBT_TAPE
RMAN-08526: channel ch1: VERITAS NetBackup for Oracle - Release 4.5GA (00000000)

RMAN-03022: compiling command: send
RMAN-06421: sent command to channel: ch1

RMAN-03022: compiling command: send
RMAN-06421: sent command to channel: ch1

RMAN-03022: compiling command: send
RMAN-06421: sent command to channel: ch1

RMAN-03022: compiling command: send
RMAN-06421: sent command to channel: ch1

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel ch1: starting validation of datafile backupset
RMAN-08502: set_count=2451 set_stamp=594377208 creation_time=2006/06/29:08:46:48
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential fi
le, handle="bk_2451_1_594377208", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: sbtrestore: Failed to open for restore.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
IECE

RMAN>

Recovery Manager complete.

Having read all the documentation from Veritas about this, it would suggest that the libobk file has not been linked properly. The thing is, it is there, but its the 32bit version for solaris not the 64bit version. The thing is though the 64bit libobk file won't softlink, netbackup doesn't like it.

Has anyone got any ideas?

Thanks again for reading and for any replies,

B14... aka... marky mark...

 

[B14speedfreak]

Almost forgot, its an Oracle 8.1.7 version of the database.

 

[creakyjoe]

Is the Oracle instance 32-bit or 64-bit though ?, that caught us out once when one of the DBA's mistakenly installed 32-bit Oracle but thought it was 64-bit. Caused us some scratching of heads for a while.

Also, it's been a few years since i used to have to wrestle with these sort of errors (and the ORA/RMAN errors you've listed above are i think the most generic and therefore annoying to fix, errors of all but i vaguely recall that this sort of problem is simply down to parameters.

Here's an old example restore script/input file/logfile output; it's from an RMAN 'duplicate' ie restore of entire DB to a.n.other server and unfortunately i picked a failed one (which has similar errors to your post); however my point in posting this is to show the params and where they sit. i'm off home now so am rushing my reply but see if you can provide similar info and we can hopefully dust off my cobwebbed memories of these errors and get you sorted... -


script -

#!/bin/ksh

BACKUP_DIR=/u01/oracle;export BACKUP_DIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.7; export ORACLE_HOME ORATAB=/var/opt/oracle/oratab PATH=/usr/local/bin:$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/sbin:/bin:/opt/bin:/usr/ccs/bin:$ORACLE_BASE/product/8.1.7/bin:$ORACLE_BASE/product/8.1.7/ows/3.0/bin:/usr/openwin/bin:/usr/ucb:/etc:$EBU_HOME/bin:./:$HOME/lbin
MANPATH=/usr/man:/usr/local/man:$ORACLE_BASE/product/8.1.7/ows/3.0/omx/man
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/dt/lib:/usr/openwin/lib:$ORACLE_HOME/lib:$EBU_HOME/lib
ORACLE_TERM=ansi
export PATH MANPATH LD_LIBRARY_PATH ORACLE_TERM ORACLE_SID=RMAN;export ORACLE_SID export PS1=`hostname`":"$ORACLE_SID":"'$PWD'"> "
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export NLS_DATE_FORMAT='DD/MM/YYYY'
export NSR_CLIENT=nthgenprod-bkp
export NSR_SERVER=nthsunbackup-bkp

PATH=/usr/local/bin:$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/sbin:/bin:/opt/bin:/usr/ccs/bin:$ORACLE_BASE/product/8.1.7/bin:$ORACLE_BASE/product/8.1.7/ows/3.0/bin:/usr/openwin/bin:/usr/ucb:/etc:$EBU_HOME/bin:./:$HOME/lbin
MANPATH=/usr/man:/usr/local/man:$ORACLE_BASE/product/8.1.7/ows/3.0/omx/man
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/dt/lib:/usr/openwin/lib:$ORACLE_HOME/lib:$EBU_HOME/lib
export PATH MANPATH LD_LIBRARY_PATH ORACLE_TERM

/u01/app/oracle/product/8.1.7/bin/rman catalog=user/password@RMAN.WORLD target=user/password@PROD.WORLD auxiliary=user/password@TEST1.WORLD cmdfile=/u01/oracle/rman-genprod_to_test1-dup.rcv log=/u01/oracle/rman-genprod_to_test1-dup.log


input file (.rcv)

run {

allocate auxiliary channel aux1 type 'sbt_tape' PARMS 'ENV=(NB_ORA_SERV=nthsunbackup-bkp, NB_ORA_CLIENT=nthgenprod-bkp)'; allocate auxiliary channel aux2 type 'sbt_tape' PARMS 'ENV=(NB_ORA_SERV=nthsunbackup-bkp, NB_ORA_CLIENT=nthgenprod-bkp)'; allocate auxiliary channel aux3 type 'sbt_tape' PARMS 'ENV=(NB_ORA_SERV=nthsunbackup-bkp, NB_ORA_CLIENT=nthgenprod-bkp)';


set newname for datafile 1 to '/u02/TEST1/oradata/systemTEST101.dbf';
etc etc etc...
set newname for datafile 59 to '/u07/TEST1/oradata/users_indexTEST101.dbf';

duplicate target database to 'TEST1'
logfile GROUP 1 ('/u02/TEST1/oradata/redoTEST101a.log','/u04/TEST1/oradata/redoTEST101b.log') SIZE 500M,
GROUP 2 ('/u03/TEST1/oradata/redoTEST102a.log','/u02/TEST1/oradata/redoTEST102b.log') SIZE 500M,
GROUP 3 ('/u04/TEST1/oradata/redoTEST103a.log','/u03/TEST1/oradata/redoTEST103b.log') SIZE 500M,
GROUP 4 ('/u05/TEST1/oradata/redoTEST104a.log','/u06/TEST1/oradata/redoTEST104b.log') SIZE 500M;

release channel aux1;
release channel aux2;
release channel aux3;
}

Logfile output -

Recovery Manager: Release 8.1.7.4.0 - Production

RMAN-06005: connected to target database: PROD (DBID=blahblahblah)
RMAN-06008: connected to recovery catalog database
RMAN-06020: connected to auxiliary database

RMAN> run {
2>
3> allocate auxiliary channel aux1 type 'sbt_tape' PARMS
3> 'ENV=(NB_ORA_SERV=nthsunbackup-bkp, NB_ORA_CLIENT=nthgenprod-bkp)';
4> allocate auxiliary channel aux2 type 'sbt_tape' PARMS
4> 'ENV=(NB_ORA_SERV=nthsunbackup-bkp, NB_ORA_CLIENT=nthgenprod-bkp)';
5> allocate auxiliary channel aux3 type 'sbt_tape' PARMS
5> 'ENV=(NB_ORA_SERV=nthsunbackup-bkp, NB_ORA_CLIENT=nthgenprod-bkp)';
6>
7>
8>
9> set newname for datafile 1 to
9> '/u02/TEST1/oradata/systemTEST101.dbf';
etc etc etc...
67> set newname for datafile 59 to
67> '/u07/TEST1/oradata/users_indexTEST101.dbf';
68>
69> duplicate target database to 'TEST1'
70> logfile GROUP 1
70> ('/u02/TEST1/oradata/redoTEST101a.log','/u04/TEST1/oradata/redoTEST1
70> 01b.log') SIZE 500M,
71> GROUP 2
71> ('/u03/TEST1/oradata/redoTEST102a.log','/u02/TEST1/oradata/redoTEST1
71> 02b.log') SIZE 500M,
72> GROUP 3
72> ('/u04/TEST1/oradata/redoTEST103a.log','/u03/TEST1/oradata/redoTEST1
72> 03b.log') SIZE 500M,
73> GROUP 4
73> ('/u05/TEST1/oradata/redoTEST104a.log','/u06/TEST1/oradata/redoTEST1
73> 04b.log') SIZE 500M;
74>
75> release channel aux1;
76> release channel aux2;
77> release channel aux3;
78> }
79>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: aux1
RMAN-08500: channel aux1: sid=16 devtype=SBT_TAPE
RMAN-08526: channel aux1: VERITAS NetBackup for Oracle8 - Release 3.4.1GA (030800)

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: aux2
RMAN-08500: channel aux2: sid=17 devtype=SBT_TAPE
RMAN-08526: channel aux2: VERITAS NetBackup for Oracle8 - Release 3.4.1GA (030800)

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: aux3
RMAN-08500: channel aux3: sid=18 devtype=SBT_TAPE
RMAN-08526: channel aux3: VERITAS NetBackup for Oracle8 - Release 3.4.1GA (030800)

RMAN-03022: compiling command: set
etc etc etc...
RMAN-03022: compiling command: set


RMAN-03022: compiling command: Duplicate Db
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-03027: printing stored script: Memory Script {
set until scn 7620743712;
set newname for datafile 1 to
"/u02/TEST1/oradata/systemTEST101.dbf";
etc etc etc...
set newname for datafile 59 to
"/u07/TEST1/oradata/users_indexTEST101.dbf";
restore
check readonly
clone database
;
}
RMAN-03021: executing script: Memory Script

RMAN-03022: compiling command: set
etc etc etc...
RMAN-03022: compiling command: set

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel aux1: starting datafile backupset restore
RMAN-08502: set_count=7995 set_stamp=518579913 creation_time=20/02/2004
RMAN-08089: channel aux1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00005 to /u03/TEST1/oradata/postcode_dataTEST101.dbf
etc etc etc...
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: aux1
RMAN-08031: released channel: aux2
RMAN-08031: released channel: aux3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-10035: exception raised in RPC: O
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
RMAN-10035: exception raised in RPC: O
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel aux2
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle="psfehpn2_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: sbtrestore: Failed to open for restore.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE

Recovery Manager complete.



Rich

 

[creakyjoe]

can't see a way to edit my previous post, but have now found a complete RMAN Duplicate logfile from a couple years ago. (We no longer recreate/refresh databases from tape as we now have Netapp storage so it's an opportunity to post the output somewhere in case i ever work somewhere we they still use the old tools to restore data -

script -

#!/bin/ksh

BACKUP_DIR=/tmp;export BACKUP_DIR
NB_ORA_POLICY=CL_ORACLEDB_dim_misc;export NB_ORA_POLICY

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.7; export ORACLE_HOME ORATAB=/var/opt/oracle/oratab PATH=/usr/local/bin:$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/sbin:/bin:/opt/bin:/usr/ccs/bin:$ORACLE_BASE/product/8.1.7/bin:$ORACLE_BASE/product/8.1.7/ows/3.0/bin:/usr/openwin/bin:/usr/ucb:/etc:$EBU_HOME/bin:./:$HOME/lbin
MANPATH=/usr/man:/usr/local/man:$ORACLE_BASE/product/8.1.7/ows/3.0/omx/man
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/dt/lib:/usr/openwin/lib:$ORACLE_HOME/lib:$EBU_HOME/lib
ORACLE_TERM=ansi
export PATH MANPATH LD_LIBRARY_PATH ORACLE_TERM ORACLE_SID=RMAN;export ORACLE_SID export PS1=`hostname`":"$ORACLE_SID":"'$PWD'"> "
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export NLS_DATE_FORMAT='DD-MM-YYYY:HH24:MI:SS'
export NSR_CLIENT=nthgentest-bkp
export NSR_SERVER=nthsunbackup-bkp
export NB_ORA_SERV=nthsunbackup-bkp

PATH=/usr/local/bin:$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/sbin:/bin:/opt/bin:/usr/ccs/bin:$ORACLE_BASE/product/8.1.7/bin:$ORACLE_BASE/product/8.1.7/ows/3.0/bin:/usr/openwin/bin:/usr/ucb:/etc:$EBU_HOME/bin:./:$HOME/lbin
MANPATH=/usr/man:/usr/local/man:$ORACLE_BASE/product/8.1.7/ows/3.0/omx/man
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/dt/lib:/usr/openwin/lib:$ORACLE_HOME/lib:$EBU_HOME/lib
export PATH MANPATH LD_LIBRARY_PATH ORACLE_TERM

$ORACLE_HOME/bin/rman catalog=user/password@RMAN.WORLD target=user/password@MISC.WORLD auxiliary=user/password@misctest.world cmdfile=/u01/oracle/rman-MISC_to_gentest_dup.rcv log=/u01/oracle/rman-MISC_to_gentest_dup.log


input file (.rvc) -

allocate auxiliary channel aux1 type 'sbt_tape' PARMS 'ENV=(NB_ORA_SERV=nthsunbackup-bkp, NB_ORA_CLIENT=nthgentest-bkp)';

set until time '03-03-2004 02:30:00';

set newname for datafile 1 to '/u14/TEST4/MISCTEST/oradata/systemMISCTEST01.dbf';
etc etc etc...
set newname for datafile 30 to '/u14/TEST4/MISCTEST/oradata/wirelessindexMISCTEST01.dbf';

duplicate target database to 'MISCTEST'
logfile GROUP 1 ('/u14/TEST4/MISCTEST/oradata/redoMISCTEST01a.log','/u14/TEST4/MISCTEST/oradata/redoMISCTEST01b.log') SIZE 5M,
GROUP 2 ('/u14/TEST4/MISCTEST/oradata/redoMISCTEST02a.log','/u14/TEST4/MISCTEST/oradata/redoMISCTEST02b.log') SIZE 5M,
GROUP 3 ('/u14/TEST4/MISCTEST/oradata/redoMISCTEST03a.log','/u14/TEST4/MISCTEST/oradata/redoMISCTEST03b.log') SIZE 5M;

release channel aux1;
}


logfile output -

Recovery Manager: Release 8.1.7.4.0 - Production

RMAN-06005: connected to target database: MISC (DBID=blahblahblah)
RMAN-06008: connected to recovery catalog database
RMAN-06020: connected to auxiliary database

RMAN> run {
2>
3> allocate auxiliary channel aux1 type 'sbt_tape' PARMS
3> 'ENV=(NB_ORA_SERV=nthsunbackup-bkp, NB_ORA_CLIENT=nthgentest-bkp)';
4>
5>
6>
7> set until time '03-03-2004 02:30:00';
8>
9>
10>
11> set newname for datafile 1 to
11> '/u14/TEST4/MISCTEST/oradata/systemMISCTEST01.dbf';
etc etc etc...
26> set newname for datafile 30 to
26> '/u14/TEST4/MISCTEST/oradata/wirelessindexMISCTEST01.dbf';
27>
28> duplicate target database to 'MISCTEST'
29> logfile GROUP 1
29> ('/u14/TEST4/MISCTEST/oradata/redoMISCTEST01a.log','/u14/TEST4/MISCT
29> EST/oradata/redoMISCTEST01b.log') SIZE 5
M,
30> GROUP 2
30> ('/u14/TEST4/MISCTEST/oradata/redoMISCTEST02a.log','/u14/TEST4/MISCT
30> EST/oradata/redoMISCTEST02b.log') SIZE 5M,
31> GROUP 3
31> ('/u14/TEST4/MISCTEST/oradata/redoMISCTEST03a.log','/u14/TEST4/MISCT
31> EST/oradata/redoMISCTEST03b.log') SIZE 5M;
32>
33> release channel aux1;
34>
35>
36> }
37>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: aux1
RMAN-08500: channel aux1: sid=10 devtype=SBT_TAPE
RMAN-08526: channel aux1: VERITAS NetBackup for Oracle - Release 4.5FP_6 (2003092601)

RMAN-03022: compiling command: set
etc etc etc...
RMAN-03022: compiling command: set

RMAN-03022: compiling command: Duplicate Db

RMAN-03027: printing stored script: Memory Script {
set until scn 7796825991;
set newname for datafile 1 to
"/u14/TEST4/MISCTEST/oradata/systemMISCTEST01.dbf";
etc etc etc...
set newname for datafile 30 to
"/u14/TEST4/MISCTEST/oradata/wirelessindexMISCTEST01.dbf";
restore
check readonly
clone database
;
}
RMAN-03021: executing script: Memory Script

RMAN-03022: compiling command: set
etc etc etc...
RMAN-03022: compiling command: set

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel aux1: starting datafile backupset restore
RMAN-08502: set_count=7207 set_stamp=519789570 creation_time=03-03-2004:01:59:30
RMAN-08089: channel aux1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00002 to /u14/TEST4/MISCTEST/oradata/toolsMISCTEST01.dbf
etc etc etc...
RMAN-08023: channel aux1: restored backup piece 1
RMAN-08511: piece handle=19ffmn03_1_1 tag=null params=NULL
RMAN-08024: channel aux1: restore complete
RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "MISCTEST" RESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 8
MAXLOGHISTORY 2754
LOGFILE
GROUP 1 ( '/u14/TEST4/MISCTEST/oradata/redoMISCTEST01a.log', '/u14/TEST4/MISCTEST/oradata/redoMISCTEST01b.log' ) SIZE 5242880 ,
GROUP 2 ( '/u14/TEST4/MISCTEST/oradata/redoMISCTEST02a.log', '/u14/TEST4/MISCTEST/oradata/redoMISCTEST02b.log' ) SIZE 5242880 ,
GROUP 3 ( '/u14/TEST4/MISCTEST/oradata/redoMISCTEST03a.log', '/u14/TEST4/MISCTEST/oradata/redoMISCTEST03b.log' ) SIZE 5242880
DATAFILE
'/u14/TEST4/MISCTEST/oradata/systemMISCTEST01.dbf'
CHARACTER SET WE8ISO8859P1

RMAN-03027: printing stored script: Memory Script {
switch clone datafile all;
}
RMAN-03021: executing script: Memory Script

RMAN-03022: compiling command: switch
RMAN-03023: executing command: switch
RMAN-08015: datafile 2 switched to datafile copy
RMAN-08507: input datafilecopy recid=1 stamp=519844133 filename=/u14/TEST4/MISCTEST/oradata/toolsMISCTEST01.dbf
etc etc etc...
RMAN-08507: input datafilecopy recid=15 stamp=519844134 filename=/u14/TEST4/MISCTEST/oradata/wirelessindexMISCTEST01.dbf

RMAN-03027: printing stored script: Memory Script {
set until time '03-03-2004 02:30:00';
recover
clone database
check readonly
;
}
RMAN-03021: executing script: Memory Script

RMAN-03022: compiling command: set

RMAN-03022: compiling command: recover

RMAN-03022: compiling command: recover(1)

RMAN-03022: compiling command: recover(2)

RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery

RMAN-03022: compiling command: recover(4)
RMAN-03023: executing command: recover(4)
RMAN-08017: channel aux1: starting archivelog restore to default destination
RMAN-08022: channel aux1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=39248
RMAN-08023: channel aux1: restored backup piece 1
RMAN-08511: piece handle=1cffmo8k_1_1 tag=null params=NULL
RMAN-08024: channel aux1: restore complete
RMAN-08515: archivelog filename=/u14/TEST4/MISCTEST/oradata/arch/arch_1_39248.arc thread=1 sequence=39248 etc etc etc...
RMAN-08055: media recovery complete

RMAN-03027: printing stored script: Memory Script {
sql clone 'Alter database dismount';
}
RMAN-03021: executing script: Memory Script

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: Alter database dismount
RMAN-03023: executing command: sql
RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "MISCTEST" RESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 8
MAXLOGHISTORY 2754
LOGFILE
GROUP 1 ( '/u14/TEST4/MISCTEST/oradata/redoMISCTEST01a.log', '/u14/TEST4/MISCTEST/oradata/redoMISCTEST01b.log' ) SIZE 5242880 ,
GROUP 2 ( '/u14/TEST4/MISCTEST/oradata/redoMISCTEST02a.log', '/u14/TEST4/MISCTEST/oradata/redoMISCTEST02b.log' ) SIZE 5242880 ,
GROUP 3 ( '/u14/TEST4/MISCTEST/oradata/redoMISCTEST03a.log', '/u14/TEST4/MISCTEST/oradata/redoMISCTEST03b.log' ) SIZE 5242880
DATAFILE
'/u14/TEST4/MISCTEST/oradata/systemMISCTEST01.dbf'
CHARACTER SET WE8ISO8859P1

RMAN-03027: printing stored script: Memory Script {
catalog clone datafilecopy "/u14/TEST4/MISCTEST/oradata/systemMISCTEST01.dbf";
etc etc etc...
switch clone datafile 30 to datafilecopy "/u14/TEST4/MISCTEST/oradata/wirelessindexMISCTEST01.dbf";
Alter clone database open resetlogs;
}
RMAN-03021: executing script: Memory Script

RMAN-03022: compiling command: catalog
RMAN-03023: executing command: catalog
RMAN-08050: cataloged datafile copy
RMAN-08513: datafile copy filename=/u14/TEST4/MISCTEST/oradata/systemMISCTEST01.dbf recid=1 stamp=519844462 etc etc etc...
RMAN-03022: compiling command: switch
RMAN-03023: executing command: switch
RMAN-08015: datafile 30 switched to datafile copy
RMAN-08507: input datafilecopy recid=16 stamp=519844537 filename=/u14/TEST4/MISCTEST/oradata/wirelessindexMISCTEST01.dbf

RMAN-03022: compiling command: alter db
RMAN-06400: database opened

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: aux1

Recovery Manager complete.


Rich

 

[B14speedfreak]

Hi Rich,

Yeah looks good. My Problem really is when I try to do a restore database validate. The version of Oracle that we are using is 8i. Anyhow in my shell script I declare the following variables:

NLS_DATE_FORMAT=DD-MON-YYYY:HH24:MI:SS; export NLS_DATE_FORMAT
ORACLE_HOME=/user01/oracle/demodb/8.1.7 export ORACLE_HOME
ORACLE_SID=DEMO export ORACLE_SID
##ORAID=orademo export ORAID
today=`date +"%a"`

The rest of the script is pretty standard. It works with other instances, and I just copied it accross (fortunately its an test instance so the DBA's arn't too bothered but it would be nice to get a restore validate).

Anyhow I get the following error stack:

RMAN-08005: partial resync complete

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08096: channel ch1: starting validation of datafile backupset
RMAN-08502: set_count=2601 set_stamp=596772093 creation_time=2006/07/26:02:01:33
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle="bk_2601_1_596772093", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: sbtrestore: Failed to open for restore.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE

I know its a similar sort of thing. What throws me is that Veritas say that that if you get the:

RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle="bk_2601_1_596772093", parms=""

its a problem linking the libobk file to the oracle home. So in short I am not sure really. Do you think I have to set more variables (eg oracle base?) Thanks, for the posts,



B14... aka... Marky Mark... the frozen monkey in the server room...

 

[creakyjoe]

not sure if you know about sbttest but it's very useful, i had a problem last year, linking Oracle 10G/NBU FP6 (10G wasn't supported until FP8). Anyway, i digress, you can try testing the connectivity etc via - 'sbttest richfile -dbname RICH -trace tracefile'

see how that gets on, but as i say, the 'failed to retrieve sequential file' error is sooo generic, but it's usually something simple (and daft) that's causing this
Rich

 

[B14speedfreak]

Hi Rich,

Yeah I will have a look into sbttest (i take it thats a script? carn't find it on my system does it date back to 5.1?).

I was thinking, when you do a full restore in Oracle and you loose your control file and your repositry you can specify a file to try the restore from for the control file, might be able to do that and see what it does. I definately know that it isn't the tapes, since the tapes only get changed weekly!

Thanks for the post,

B14... aka... Marky Mark... the frozen monkey in the server room...

 

[creakyjoe]

you've found the limits of my Oracle knowledge there

as to sbttest, it's a standard Oracle thing so you should have it; it's in the normal Oracle 'bin' folder. it's quite easy to use, just google for the params as i've long forgotten exactly what my example above stands for.

 

[B14speedfreak]

Sorry Rich,

got its an oracle thing sbttest... will look into it...

thanks,



B14... aka... Marky Mark... the frozen monkey in the server room...

 

[B14speedfreak]

Hi rich,

Just ran it:

OraDEMO >sbttest test -dbname DEMO -trace /marky
The sbt function pointers are loaded.
-- sbtinit succeeded
-- sbtinit (2nd time) succeeded
sbtinit: Media manager supports SBT API version 2.0
sbtinit: Media manager is version 3.2.0.0
sbtinit: vendor description string=VERITAS NetBackup for Oracle8 - Release 3.4GA (030800)
sbtinit: allocated sbt context area of 0 bytes
sbtinit: proxy copy is supported
-- sbtinit2 succeeded
-- regular_backup_restore starts ................................
-- sbtbackup succeeded
write 100 blocks
-- sbtwrite2 succeeded
-- sbtclose2 succeeded
sbtinfo2: SBTBFINFO_NAME=test
sbtinfo2: SBTBFINFO_SHARE=single user
sbtinfo2: SBTBFINFO_ORDER=sequential access
sbtinfo2: SBTBFINFO_LABEL=EUB736
sbtinfo2: SBTBFINFO_CRETIME=Thu Jul 27 11:51:22 2006
sbtinfo2: SBTBFINFO_EXPTIME=Thu Aug 10 11:51:22 2006
sbtinfo2: SBTBFINFO_COMMENT=Backup ID : lsi_1153997482
sbtinfo2: SBTBFINFO_METHOD=stream
-- sbtinfo2 succeeded
MMAPI error from sbtrestore: 7501, sbtrestore: Failed to open for restore.
-- sbtrestore failed
OraDEMO >

Hmmm me thinks that there is something up with the libary file that we are linking with.

Anyhow let me know what you reckon,

thanks,

B14... aka... Marky Mark... the frozen monkey in the server room...

 

[creakyjoe]

right, i dusted off some cobwebs and we need an ldd of the oracle binary to see which libok is linked in.

(sorry if you know this already) -
ldd oracle

..Oracle versions prior to 9i (such as yours above) will show the libok info, however this changed from 9i (and guess what i can't remember why it's different now); anyway, i trawled my old emails from my 8i days and i can't find output from an ldd of an 8i binary but yours will show the info ok.

 

[B14speedfreak]

Hi rich,

This is all really useful stuff, heres the output from it:

OraDEMO >ldd oracle
libskgxp8.so => /user01/oracle/demodb/8.1.7/lib/libskgxp8.so
libjox8.so => /user01/oracle/demodb/8.1.7/lib/libjox8.so
libobk.so => /user01/oracle/demodb/8.1.7/lib/libobk.so
libnsl.so.1 => /usr/lib/libnsl.so.1
libsocket.so.1 => /usr/lib/libsocket.so.1
libgen.so.1 => /usr/lib/libgen.so.1
libdl.so.1 => /usr/lib/libdl.so.1
libsched.so.1 => /usr/lib/libsched.so.1
libc.so.1 => /usr/lib/libc.so.1
libaio.so.1 => /usr/lib/libaio.so.1
librt.so.1 => /usr/lib/librt.so.1
libkstat.so.1 => /usr/lib/libkstat.so.1
libm.so.1 => /usr/lib/libm.so.1
libmp.so.2 => /usr/lib/libmp.so.2
/usr/platform/SUNW,Ultra-4/lib/libc_psr.so.1

Thing is, we tried to change the libobk file for a more update version both 64 and 32 and the 32bit one was the only one we could get to work.

Thanks again,




B14... aka... Marky Mark... the frozen monkey in the server room...

 

[creakyjoe]

let's have an ls -l of that libobk file which should reference the physical libobk file in /usr/openv/netbackup/bin.

what i can't remember is how to determine whether an Oracle instance is 32 or 64-bit, but can only see 32bit libraries listed above so i think it's 32-bit Oracle instance.
Anyway, are you sure you are linking the libobk correctly (hopefully the ls -l will show what we need).

Sorry i'm a tad vague on some of this, it's been a while since i've had to mess with this stuff

Rich

 

[B14speedfreak]

Hi Rich,

No worries, I am really new to Oracle and Veritas anyway, I have posted loads of questions on Tech tips. Here are the results from the ls -l

OraDEMO >ls -l libobk.so
lrwxrwxrwx 1 orademo dba 34 Jul 6 11:35 libobk.so -> /usr/openv/netbackup/bin/libobk.so
OraDEMO >pwd
/user01/oracle/demodb/8.1.7/lib
OraDEMO >

yeah I am pretty sure that its a 32bit instance, althouth the solaris box is 64bit v. 5.8

Thanks for the posts,

B14... aka... Marky Mark... the frozen monkey in the server room...

 

[creakyjoe]

no worries, i've been using Veritas stuff quite a lot for 6years (gets easier). NetBackup, Volume Manager, File System, Flashsnap etc. My Oracle knowledge is a 'needs must' as our DBA's do all that obviously, i just glean the little bits i need as i go along.

can i have the ls -l of the libobk in the netbackup bin folder too ?, cheers. just want to see if i recognise the timestamp on your particular libobk file, though i'd have thought you could use the very latest libobk file and make it work on 8.1.7 anyway.
Just popping out to lunch but may be able to help via my handheld, gonna go buy a new wireless router, mine is crashing constantly. But we should be able to get this problem of yours sorted fairly quickly, it may just be a case of re-linking in the very latest 32-bit libobk if you mooch on Veritas's site

 

[B14speedfreak]

Yeah I am getting the hang of (pushed a client out the other day via the ftp scripts on redhat linux ent (had to enable to the ftp etc...))...

Yeah its a bit well, strange really. I work in a DBA department, but my role really is solely backups (the other DBA carn't be bothered doing it, so they ended up employing me as a trainee!) so I sort of have to be a generalist really.

What sort of router are you looking at? (I used to work for Talk Talk as a board band techi, you can get some really good routers off Ebay I am told (sort of x business type ones))...

ok heres the dump of the /usr/openv/netbackup/bin dir:

lsi# ls -l *libo*.*
-rwxr-xr-x 1 root other 1036744 Jul 6 11:34 libobk.so
-r-xr-xr-x 1 root other 1036744 Jul 6 11:17 libobk.so.1
-r-xr-xr-x 1 root other 1125716 Jun 28 22:12 libobk.so.1.bac
-r-xr-xr-x 1 root other 1125716 Jul 6 10:59 libobk.so.1.backup.mark
-rwxr-xr-x 1 root other 1448384 Jun 27 22:51 libobk.so64.1
lsi#


Yeah any ideas where I could get the latest libobk file from the veritas site, had a look round there for about 2 days and couldn't work it out (the support site they have for netbackup doesn't seem that good (especially for a company like veritas!))...

thanks again,


B14... aka... Marky Mark... the frozen monkey in the server room...

 

[creakyjoe]

Nice one with the trainee DBA thing, keep at it, should be good money/interesting career. And if you can keep your hand in with the generalist stuff, should makes you more employable; I'm happy enough doing Unix Admin myself with an unhealthy dose of NetBackup addiction; btw, without saying too much let's just say i know the firm T.T. very well
as to routers i've been having God-awful trouble with a cheapy Belkin wireless router (we're on Cable until we move to normal broadband soon, well hopefully soon); have just bought a Linksys router so my problems should go away, and when we go normal broadband i have a really nice Linksys router tested and waiting, then i'll take the 2 cable routers back for refund.

Anyways, this should be the libobk file you need -

http://seer.support.veritas.com/docs/279451.htm

as this is a test environment i'd recommend just extracting the libobk file and the oracle_link script, but up to you.

 

[B14speedfreak]

Hi Rich,

ooo cable I feel soo sorry for you, the customer service of the uk cable opporator is legendarily poor having said that I think thats true of most of the standard ISP's. As for routers well I used to know a few things about them, but I don't know an awful lot about wireless ones. Just know a few friends who bought old business ones off Ebay and they the security is excellent.

Thanks for the post, I will have a look at getting the latest libobk file and putting it on.

Yeah the job is good, I enjoy being a bit of generalist, but its nice to specialize as well! I have to say I hadn't done an awful lot with Unix before this job, but I am definately a convert, except when doing webdesign, still don't think you can beat dreamweaver for webdesign at the moment.

Thanks again,


B14... aka... Marky Mark... the frozen monkey in the server room...

 

[B14speedfreak]

Hi Rich,

Sorry I havn't been back in touch. The tape drive that we are currently using on that box I want to do a restore validate to has decided to throw a hissie fit, so I need to get sorted out first (not sure if we have support for it or not)... so this may take me a little while...

thanks,

Mark

B14... aka... Marky Mark... the frozen monkey in the server room...