OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN and SYSOPER

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN and SYSOPER [message #264857]

Tue, 04 September 2007 17:08

owensmith99
Messages: 11
Registered: September 2007
Location: Dallas

Junior Member

Hi There,

Can any of you give me some tips on running RMAN
via SYSOPER rather than SYSDBA?

Currently, when I run RMAN, I use an RMAN command line similar to this:

rman TARGET / CMDFILE crosscheck10.rcv LOG crosscheck10.txt

I don't see that it specifies SYSOPER or SYSDBA.

How do I write an RMAN command line which connects as SYSOPER?

-Owen

Report message to a moderator

Re: RMAN and SYSOPER [message #264859 is a reply to message #264857]

Tue, 04 September 2007 17:39

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

SQL>  create user dreamz identified by dreamz default tablespace qlink_user_ts;

User created.

SQL> grant create session to dreamz;

Grant succeeded.

SQL> !rman target dreamz/dreamz

Recovery Manager: Release 10.2.0.3.0 - Production on Tue Sep 4 22:38:44 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: QLINK (DBID=3204298531)

RMAN>
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
.
.
RMAN>

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta13.htm

[Updated on: Tue, 04 September 2007 17:41]

Report message to a moderator

Re: RMAN and SYSOPER [message #264875 is a reply to message #264857]

Tue, 04 September 2007 21:54

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

-bash-3.00$ rman target sysman/arju

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Sep 4 22:49:45 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: SOURCE (DBID=2748307709)

You can use cmdfile appeneded with the command.

Report message to a moderator

Re: RMAN and SYSOPER [message #264931 is a reply to message #264859]

Wed, 05 September 2007 01:14

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

DreamzZ,

This does prove anything.
If you are in osdba group you can use rman with any connection string, it is ignored.

ADBU11> select username from dba_users where username='T';

no rows selected

ADBU11> !rman target t/yyy

Recovery Manager: Release 10.2.0.2.0 - Production on Wed Sep 5 08:10:12 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ADBU11 (DBID=2765200434)

RMAN>

RMAN requires SYSDBA privilege, it can't be used with SYSOPER.

Database Backup and Recovery Basics
Chapter 3 Setting Up and Configuring Backup and Recovery
Section 3.3 Connecting the RMAN Client to Databases

Quote:

When connecting to a target or auxiliary database, you must have the SYSDBA privilege.

Regards
Michel

Report message to a moderator

Re: RMAN and SYSOPER [message #265158 is a reply to message #264931]

Wed, 05 September 2007 10:03

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Thanks

caught it.

Report message to a moderator

Previous Topic:	RMAN - delete expired archivelog
Next Topic:	restoring rman backup to test database from live db (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 06:02:26 CST 2025