Link netbackup to Oracle in Solaris

[khanhb]

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

[Twinkle_Sapra]

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.

[Marianne]

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.