Re: RMAN error: ORA-01031 Insufficient privileges

From: Mladen Gogala <>
Date: Tue, 4 Dec 2012 15:29:31 +0000 (UTC)
Message-ID: <k9l4sq$u58$>

On Tue, 04 Dec 2012 06:02:24 -0800, gnewsgroup wrote:

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

Have you tried "BACKUP TABLESPACE"?

Also, make sure that you are launching rman from the account which is a member of ORA_DBA group. You need that group to be able to connect as SYSDBA which is what RMAN does when connecting to the database. Also, I can wholeheartedly recommend Rob Freeman's RMAN books as well as Sam Alapati's and Arup Nanda's "RMAN recipes". In addition to all that, Oracle documentation is accessible freely on the internet. The addresses are:

Received on Tue Dec 04 2012 - 16:29:31 CET

Original text of this message