Solved

Syntax for "restore validate" in Oracle 9.2

Posted on 2008-10-16
8
966 Views
Last Modified: 2013-12-19
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

0
Comment
Question by:peter991
  • 6
8 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22729863
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
 
LVL 6

Author Comment

by:peter991
ID: 22729890
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
 
LVL 6

Author Comment

by:peter991
ID: 22730147
Please ignore the decimal in the first:

NSR_DATA_VOLUME_POOL=Oracle,

My script doesn't have that.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 7

Accepted Solution

by:
vishal68 earned 500 total points
ID: 22738693
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
 
LVL 6

Author Comment

by:peter991
ID: 22739017
Hi!
Yes I guess you are right about the controlfile.

I will excluding that row for now and run "restore validate database;" only.
0
 
LVL 6

Author Comment

by:peter991
ID: 22739408
Looking good.. 3 pieces validated and still no error.
It's only the syntax for validating the controlfile that is hard to find.
0
 
LVL 6

Author Comment

by:peter991
ID: 22755682
I will leave the controlfile for now.
Thanks for participating and help.

Regards!
0
 
LVL 6

Author Closing Comment

by:peter991
ID: 31506674
Thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question