Re: RMAN error: ORA-01031 Insufficient privileges

From: <gnewsgroup_at_gmail.com>
Date: Tue, 4 Dec 2012 06:02:24 -0800 (PST)
Message-ID: <375c17aa-7fd6-4349-b2ad-a10f03d115ad_at_googlegroups.com>

On Tuesday, December 4, 2012 8:01:33 AM UTC-5, gnews..._at_gmail.com wrote:
> I do have a lot of experiences in MS SQL Server, but sorta new to Oracle.
>
>
>
> I have Oracle XE on Windows 7 Enterprise. I am learning how to use RMAN to back up my database.
>
>
>
> So, I issued rman target / and got this:
>
>
>
> Recovery Manager: Release 11.2.0.2.0 - Production on Tue Dec 4 07:55:14 2012
>
>
>
> Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
>
>
>
> RMAN-00571: ===========================================================
>
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>
> RMAN-00571: ===========================================================
>
> RMAN-00554: initialization of internal recovery manager package failed
>
> RMAN-04005: error from target database:
>
> ORA-01031: insufficient privileges
>
>
>
> I searched and found solutions on a Unix based system. But this is Windows, how do I make sure I can successfully launch rman? What do I need to do? Thank you!

I did the following.

Execute rman with 0 arguments, that gets me into the rman prompt.

Then I execute connect target sys

Then I entered the password and got in:

RMAN> connect target sys

target database Password:
connected to target database: XE (DBID=2681755392)

RMAN> So, I am connected to XE as sys. Now I want to back up only tablespace hr, how to do it? All I found online is this simple command: BACKUP DATABASE. That doesn't tell me what it is backing up. I don't want to back up all tablespaces in my XE instance.

Thanks. Received on Tue Dec 04 2012 - 15:02:24 CET