Solved

Syntax for "restore validate" in Oracle 9.2

Posted on 2008-10-16
8
965 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 142

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

813 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now