[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Oracle 9i RMAN Parameters

Posted on 2014-04-29
28
Medium Priority
?
504 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
[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
  • 15
  • 12
28 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 40029784
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
ID: 40029790
yes you are right .. let me recheck my query ..
0
 

Author Comment

by:gaurav12345
ID: 40030098
Compression is not supported in Oracle 9i .. I was using wrong command
0
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!

 

Author Comment

by:gaurav12345
ID: 40030111
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
ID: 40030105
Whats the basic objective to this portal .. To earn points or to resolve issue
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40030112
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 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40030126
>>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 77

Expert Comment

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

Specifically the New User Guide.
0
 

Author Comment

by:gaurav12345
ID: 40030151
Thanks a lot !!
0
 

Author Comment

by:gaurav12345
ID: 40030161
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 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40030183
>> 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
ID: 40030187
Sounds good !!
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40030371
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
 
LVL 77

Expert Comment

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

Author Comment

by:gaurav12345
ID: 40034826
What you want ..
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40034964
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
ID: 40035133
That's Perfect thank you ..let me choose that !!
0
 

Author Comment

by:gaurav12345
ID: 40035146
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 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40035147
>>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 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40035156
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
ID: 40035158
But why can't my answer i cannot select .. Is there any polcy
0
 

Author Comment

by:gaurav12345
ID: 40035161
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 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40035162
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
ID: 40035178
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
ID: 40035181
The expert has provided the correct solution
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40035194
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
ID: 40035199
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
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 set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

649 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