[Veritas-bu] Oracle Database Restore Problem
adrian.soetanto at bentoel.co.id
Thu Dec 17 08:47:23 CST 2009
I have a problem when restoring the Oracle Database on AIX & Linux
The problem is related to privilege issue.
I used NetBackup client (Backup, Archive, and Restore), by running this
command on AIX (using Xmanager) & Linux:
I used the 'Oracle' restore type and the database to be restored has
been shown at the 'Directory Structure' of jbpSA, but I was unable to
drill-down/expand the database's tree.
When it asked for username (SYSDBA privilege), password & Net service
name (TNS Alias), I've tried to use the correct 'sys' userID & password
and TNS alias (I've double checked those entries with my system
administrator), but it's failed with this error message:
ERR - Unable to connect to elodev. Error code = 12560
I've tried to run the jbpSA using root & oracle users, both resulted the
Since I got those error when I expanded the database tree, I can't run
the restore as well.
I've tried to test the 'sys' user within sqlplus command (logged on as a
root user), and it's failed with this error message:
ORA-01031: insufficient privileges
But, when I tried to logon using the oracle user, it was successful but
it's still failed when I run the restore using jbpSA.
Could you please help me solve this problem?
Since I'm a novice in Oracle DB, is there any guidance which I can refer
If possible, please give me the step by step information about restoring
an Oracle Database to AIX & Linux platform.
FYI, both the NetBackup master & client (agent) use the same NetBackup
version, which is 6.5.4.
Thank you in advance.
PT. Bentoel Prima - Infrastructure Staff
Jl. Raya Karanglo - Singosari, Malang
Tel. (+62-341) 298 774
More information about the Veritas-bu