Restore Validates 1

[B14speedfreak]

Hi all,

Thanks in advance for any posts....

My question is this. I am trying to do a restore Validate on one of our test systems. I have moved a script over from the production systems and customized it to fit the test server. Anyhow when I run it, it goes for about a minuete than throws this at me:

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 Oracle8 - Release 3.4GA (030800)

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=2186 set_stamp=590667980 creation_time=2006/05/17:10:26:20
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_2186_1_590667980", 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

RMAN>

Recovery Manager complete.

The box is running Solaris 5.8, netbackup 5.1 (server and client its on the one box) and oracle 8.1.7.3.3

Anyone any ideas?

Thanks again for reading and any posts,

B14... aka... Marky Mark...

 

[LKBrwnDBA]

1) When restore-validating a backup, use a COPY of the catalog -- Export catalog and Import to another schema.

2) It appeqars to be it's not finding the backup files, (but also there may be something wrong with your script) -- post the script you are using.





----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[B14speedfreak]

Thanks for the replay,

Yeah the script looks like this:

#
# Validate Script
#


#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"`

#main function

#main part of the script
<<EOF su - orademo
<<EOF_1 rman

connect target /
connect catalog rman/rman@rman
#list incarnation;
#list backup summary;
run {
allocate channel ch1 type 'SBT_TAPE';
send "NB_ORA_CLASS=ORAhot_DEMO";
send "NB_ORA_CLIENT=lsi";
#####send "NB_ORA_SERV=eurcomunx001";
send "NB_ORA_SCHED=full";

restore validate database ;

release channel ch1;
}
exit
exit
EOF_1

EOF

exit 0

its a standard one that seems to work well accross the production systems... not sure why its not working here.

Thanks again,

B14... aka... Marky Mark...

 

[LKBrwnDBA]

Your scripts looks ok, except I am not familiar with the purpose of the 'send' commands.

Seems the cause of the error is that RMAN is not finding on the tape the datafile for restore: ORA-19507: failed to retrieve sequential file, handle="bk_2186_1_590667980",

PS: validate causes RMAN to decide which backup sets, datafile copies, and archived logs need to be restored and then scans them to verify their contents. This operation creates no output files. If you actually want to truly validate the restore in another host, remove the 'VALIDATE' option.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[B14speedfreak]

Yeah well the send commands relate to... da derrr... the media manager layer... otherwise known as Veritas Netbackup 5.1 at this moment in time.

Its a strange one really, you see, I couldn't get it to work, so I figured that it must just be either the tape or something, so I kicked off a new backup, and after it had completed started off another restore validate...

We don't currently try restoring the system completely at the moment to another box. We just run the Restore Validate Database (which we know isn't guarnteed).

Anyhow will have a word with some of colleagues and see they have any ideas....

thanks again...

B14... aka... Marky Mark...

 

[LKBrwnDBA]

You could try finding the "bk_2186_1_590667980" file on tape using the Veritas Netbackup GUI (jnbSA).


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[B14speedfreak]

yeah hadn't thought of that...

Thanks again,

MArky MArk...

 

[B14speedfreak]

Yeah looks like the problem is as suspected that NBU cannot find the file to do the restore validate with...

Not sure really what to do about that...

Thanks for the replay though, at least I know what the problem is now...

Thanks again,

B14... aka... Marky Mark

 

[B14speedfreak]

well I carn't find the file that Rman is after, however I am doing a verify on the tabe that its after... will see what that shows.