Home » RDBMS Server » Backup & Recovery » RMAN and SYSOPER
RMAN and SYSOPER [message #264857] Tue, 04 September 2007 17:08 Go to next message
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
Re: RMAN and SYSOPER [message #264859 is a reply to message #264857] Tue, 04 September 2007 17:39 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: RMAN and SYSOPER [message #264931 is a reply to message #264859] Wed, 05 September 2007 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: RMAN and SYSOPER [message #265158 is a reply to message #264931] Wed, 05 September 2007 10:03 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thanks Thumbs Up
caught it.
Previous Topic: RMAN - delete expired archivelog
Next Topic: restoring rman backup to test database from live db (merged)
Goto Forum:
  


Current Time: Wed Dec 07 12:47:02 CST 2016

Total time taken to generate the page: 0.13677 seconds