Home » RDBMS Server » Backup & Recovery » Regarding RMAN catalog database with different OS user. (10.2.0.2.0)
Regarding RMAN catalog database with different OS user. [message #347554] Fri, 12 September 2008 02:11 Go to next message
lm_suresh
Messages: 24
Registered: September 2007
Location: Chennai,India
Junior Member
I have created three database pr1, prd2 and rct1.

prd1 and rct1 are sharing the same oracle home and started with user "oracle1".

prd2 has separate oracle home and started with the user "oracle2".

I want to connect the rct1 database ie rman database using the user "oracle2" and i should able to startup and shutdown the rc1 instance.

I can directly connect the rman using oracle2 user.

rman catalog=rman/rman@RC1 target= /

but is it possible to shutdown/startup the rc1 instance.

Please Clarify or provide me the solution.

Basically i have two instance with diffrenet oracle home and diffrerent oracle user and i want use single recovery database and register both the instance and should able to start and shutdown the recovery database using both the user ie oracle1 and oracle2.

Thank you.

Re: Regarding RMAN catalog database with different OS user. [message #347560 is a reply to message #347554] Fri, 12 September 2008 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you want to shutdown/startup the catalog database via rman?
As for all databases, you need sysdba or sysoper os roles to be able to do that.

Regards
Michel
Re: Regarding RMAN catalog database with different OS user. [message #347561 is a reply to message #347554] Fri, 12 September 2008 02:50 Go to previous messageGo to next message
lm_suresh
Messages: 24
Registered: September 2007
Location: Chennai,India
Junior Member
I want to startup/shutdown because we dont want to run the catalog database all the time.Only it required we will startup and once the backup is over, we will shutdown the catalog database.

Re: Regarding RMAN catalog database with different OS user. [message #347572 is a reply to message #347561] Fri, 12 September 2008 03:44 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Anyway you have to connect as sysdba and not as rman catalog owner but rman is NOT the correct tool to do it use sqlplus.

Regards
Michel
Previous Topic: ORA-00600: internal error code, arguments: [12700], [5897],
Next Topic: spfile recovery
Goto Forum:
  


Current Time: Tue Dec 06 04:30:44 CST 2016

Total time taken to generate the page: 0.32061 seconds