Syntax for "restore validate" in Oracle 9.2

Hi!
I'm running some validate-tests against Oracle 10g with success but when I try to apply the script on a Oracle 9.2 I get errors.

I believe that it has to do with the syntax or perhaps that the database has to be dismounted.
In 10g the database can be online.

Question is:
Is my syntax correct?
Can you validate Oracle 9.2 online?
connect target sys/syspasswd@DBID
connect catalog rmanuser/rmanpass@RMANXX
replace script "restore_validate" {
        set command id to "restore_validate";
        allocate channel t1 type 'SBT_TAPE' parms 'ENV=(
                NSR_SERVER=backupsrv,
                NSR_DATA_VOLUME_POOL=Oracle,
                )';
                allocate channel t2 type 'SBT_TAPE' parms 'ENV=(
                NSR_SERVER=backupsrv,
                NSR_DATA_VOLUME_POOL=Oracle
                )';
                restore validate controlfile;
                restore validate database;
                restore validate archivelog from scn 123456789;
                release channel t1;
                release channel t2;
        }
        run {execute script "restore_validate";}

Open in new window

LVL 6
peter991Asked:
Who is Participating?
 
vishal68Commented:
Hi

If I remeber correctly, there is a problem in restore validate controlfile in 9i. You have to use
 restore controlfile to 'filename' validate

HTH
Vishal
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
it would be helpful to see what errors you get.
anyhow, I do not remember the VALIDATE in oracle 9.2, but I might be wrong...
0
 
peter991Author Commented:
Yes of course.

RMAN-06496: must use the TO clause when the database is mounted or open

Perhaps it's just a rumor but I heard it should be possible in 9.2.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
peter991Author Commented:
Please ignore the decimal in the first:

NSR_DATA_VOLUME_POOL=Oracle,

My script doesn't have that.
0
 
peter991Author Commented:
Hi!
Yes I guess you are right about the controlfile.

I will excluding that row for now and run "restore validate database;" only.
0
 
peter991Author Commented:
Looking good.. 3 pieces validated and still no error.
It's only the syntax for validating the controlfile that is hard to find.
0
 
peter991Author Commented:
I will leave the controlfile for now.
Thanks for participating and help.

Regards!
0
 
peter991Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.