Solved

Syntax for "restore validate" in Oracle 9.2

Posted on 2008-10-16
8
969 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Veeam gives away 10 full conference passes

Veeam is a VMworld 2017 US & Europe Platinum Sponsor. Enter the raffle to get the full conference pass. Pass includes the admission to all general and breakout sessions, VMware Hands-On Labs, Solutions Exchange, exclusive giveaways and the great VMworld Customer Appreciation Part

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

636 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