02-12-2011 06:22 PM
Hi all,
I want to link netbackup client to Oracle in Solaris. But I don't understand this step "Set the ORACLE_SID environment variable to the first SID". Would you show me example about that.
Thanks
02-12-2011 07:59 PM
The Oracle System ID (SID) is used to uniquely identify a particular database on a system. For this reason, one cannot have more than one database with the same SID on a computer system.
ORACLE_HOME=/oramis_db/DB
export ORACLE_HOME
# ---------------------------------------------------------------------------
# Replace ora81, below, with the Oracle SID of the target database.
# ---------------------------------------------------------------------------
ORACLE_SID=MISDB1
export ORACLE_SID
# ---------------------------------------------------------------------------
# Replace ora81, below, with the Oracle DBA user id (account).
# ---------------------------------------------------------------------------
# (This is Oracle(OS) User)
ORACLE_USER=oracle
You have to get ORACLE_HOME, ORACLE_SID, ORACLE_USER details from Database team.
02-12-2011 09:51 PM
I Totally agree - do not try to set up Oracle backups without your database team. They will know how to set Env Variables as they are doing it on a daily basis. Once they log in as the Oracle user, there should be a default ORACLE_SID set as part of the user's logon parameters.
Once the linking is done, the Oracle dba needs to provide a backup script or modify the sample scripts supplied by NBU.