OraFAQ Forum: Backup & Recovery » how to know SID of database

Home » RDBMS Server » Backup & Recovery » how to know SID of database

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

how to know SID of database [message #155047]

Wed, 11 January 2006 23:14

shekhar_bhadauria
Messages: 12
Registered: June 2005
Location: delhi

Junior Member

how can i get the SID and Global SID of database if i forgotten.

shekhar

Report message to a moderator

Re: how to know SID of database [message #155119 is a reply to message #155047]

Thu, 12 January 2006 08:28

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

This might help:

SQL> SELECT instance_name FROM v$instance;

INSTANCE_NAME
----------------
orcl

SQL> SELECT global_name FROM global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
orcl.REGRESS.RDBMS.DEV.US.ORACLE.COM

Report message to a moderator

Previous Topic:	TableSpace Point In Time Recovery & Extend Management Dictionary
Next Topic:	backup of RMAN database by using RMAN it self

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 01 01:04:03 CDT 2025