Solved

Oracle 9i RMAN Parameters

Posted on 2014-04-29
28
480 Views
Last Modified: 2014-05-01
The below command in Oracle 9i is failing

RMAN> run
2> {
3> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "backup": expecting one of: ";"
RMAN-01007: at line 3 column 42 file: standard input


I took the reference from

http://www.oracle-base.com/articles/10g/rman-enhancements-10g.php

Thanks
Gaurav
0
Comment
Question by:gaurav12345
  • 15
  • 12
28 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
Why use a 10g enhancements page for 9i command?

My guess is it is the COMPRESSED keyword since it talks about backup compression in the 10g enhancements link you posted.
0
 

Author Comment

by:gaurav12345
Comment Utility
yes you are right .. let me recheck my query ..
0
 

Author Comment

by:gaurav12345
Comment Utility
Compression is not supported in Oracle 9i .. I was using wrong command
0
 

Author Comment

by:gaurav12345
Comment Utility
I've requested that this question be closed as follows:

Accepted answer: 0 points for gaurav12345's comment #a40030098

for the following reason:

Because i found the answer correctly
0
 

Author Comment

by:gaurav12345
Comment Utility
Whats the basic objective to this portal .. To earn points or to resolve issue
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
I'm afraid I'll have to object to you accepting your own post as the solution.

Didn't I mention compression was likely the issue and why?
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>Whats the basic objective to this portal .. To earn points or to resolve issue

The main point to the site is for people to find answers to their questions.  They can do this two ways:  Either ask a question or search the knowledgebase for an accepted answer to a question.

When they find that someone else has asked the same question, all you would need to do is find the accepted answer and it should answer their question.

The problem comes in when people do not properly accept solutions to their questions.  The 'accepted' answer may have nothing to do with the question.

The people that answer the questions are all volunteer.  The points are just our reward for taking the time to help others solve their problems.

The grade tells others how well we did at answering the question.

This is why the correct grade and accepting the correct solutions to the question is very important to any questions asked.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
I suggest you spend some time reading here:
http://support.experts-exchange.com/

Specifically the New User Guide.
0
 

Author Comment

by:gaurav12345
Comment Utility
Thanks a lot !!
0
 

Author Comment

by:gaurav12345
Comment Utility
But i had a situation earlier in my question where i was questioned why i assigned some one Grade B not grade A and i was asked for explaination.. Are we suppose to spend extra time on expalining why this grade was choose and why not grade was choosen .. Does not it looks that there is a chase for getting grade A .. Even if the solution has been provided by pasting URL of the website . Rather explaining in the elaborative way
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>> i was questioned why i assigned some one Grade B not grade A and i was asked for explaination

Look at who questioned it?  It was me.

>>Are we suppose to spend extra time on expalining why this grade was choose and why not grade was choosen ..

Take a look at the link I posted in the previous question.  It was a link that explains the grading system.

If you didn't feel the question was properly answered you should explain why to the Experts or allow them to provide additional information on something that wasn't clear before giving them a penalty.

>>Does not it looks that there is a chase for getting grade A ..

You can click the Request attention link and ask a Moderator to reopen the question so you can close it properly.

>>Even if the solution has been provided by pasting URL of the website . Rather explaining in the elaborative way

This is a long topic to discuss.

In a nutshell:
Some times a link is the correct answer.  Say the question is "where can I download XYZ"?

Some times it would take too long to try to explain things in enough detail in a Q&A forum like this and a link can explain things better or the link has already explained it.

There are also a few members that troll for points by just posting nothing but links.

The decision on what type of post the link was in is up to you but again, before providing a penalty grade, you should explain what would be necessary for an "A" grade.

Otherwise, the Expert can challenge the closing and ask Moderators to get involved.
0
 

Author Comment

by:gaurav12345
Comment Utility
Sounds good !!
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
FYI:
Before we got side tracked, did you notice I objected to the way you proposed to close this question?

Your closing comments here: http:#a40030111

My objection here: http:#a40030112
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 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
Have you forgotten to come back and close this?
0
 

Author Comment

by:gaurav12345
Comment Utility
What you want ..
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
The question asked was why the RMAN command you were using wasn't working.

What post answered that question?  That should be the post that is accepted.
0
 

Author Comment

by:gaurav12345
Comment Utility
That's Perfect thank you ..let me choose that !!
0
 

Author Comment

by:gaurav12345
Comment Utility
I've requested that this question be closed as follows:

Accepted answer: 0 points for gaurav12345's comment #a40030098

for the following reason:

I did my finding and found out that compression is not supported in 9i
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>I did my finding and found out that compression is not supported in 9i

I'll again have to object to your accepting your own answer after I pointed out that the problem was probably compression.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
As I suggested back up in http:#a40030132, have you reviewed the New Users guide that talks about how the site works?

In a nutshell:
You ask a question.
One or more Experts answer the question.
You reward us with points for answering your question.
0
 

Author Comment

by:gaurav12345
Comment Utility
But why can't my answer i cannot select .. Is there any polcy
0
 

Author Comment

by:gaurav12345
Comment Utility
I think i joined this site by mistake .. I am going to close my account .. Donot have enough time to spend time answering non technical question
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
You can accept your own answer if you figured out the answer yourself without Expert help.  It happens all the time.

In this question, the answer was posted before your 'answer' that pretty much told you what the answer was.
0
 

Author Comment

by:gaurav12345
Comment Utility
I accept what you said now .. Have you said this at first ,, I would have understood it better .. I think you provided the answer first .. I checked it and found you are right .. I am new to this site .. So it will take sometime at me to adjust with the existing pattern and culture .. Thanks !!
0
 

Author Closing Comment

by:gaurav12345
Comment Utility
The expert has provided the correct solution
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
No problem and sorry for the confusion.

This is a great site and I hope you stick around long enough to get used to things.  Once you get the hang of things, it should go a lot smoother than your first few questions have.

The Help link I posted has a lot of great information that will help explain things better than I can.
0
 

Author Comment

by:gaurav12345
Comment Utility
Yeah definitely this is great site .. I think with some more time frame .. I will become comfortable .. Thanks for helping me out with the my question
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.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
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 shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

744 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

11 Experts available now in Live!

Get 1:1 Help Now