Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 981
  • Last Modified:

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

0
peter991
Asked:
peter991
  • 6
1 Solution
 
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
 
peter991Author Commented:
Please ignore the decimal in the first:

NSR_DATA_VOLUME_POOL=Oracle,

My script doesn't have that.
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
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
 
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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now