Home » RDBMS Server » Backup & Recovery » how to know SID of database
how to know SID of database [message #155047] Wed, 11 January 2006 23:14 Go to next message
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
Re: how to know SID of database [message #155119 is a reply to message #155047] Thu, 12 January 2006 08:28 Go to previous message
Frank Naude
Messages: 4587
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

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


Current Time: Mon Dec 23 04:10:29 CST 2024