Re: [Veritas-bu] Oracle Database Restore Problem

2009-12-22 Thread Wayne T Smith
Do your Oracle DB restore from Oracle (RMAN), not NetBackup.

Cheers, Wayne
___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu


[Veritas-bu] Oracle Database Restore Problem

2009-12-17 Thread Adrian Soetanto
Dear all,

I have a problem when restoring the Oracle Database on AIX  Linux
clients.
The problem is related to privilege issue.

I used NetBackup client (Backup, Archive, and Restore), by running this
command on AIX (using Xmanager)  Linux: 
/usr/openv/netbackup/jbpSA 

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:
Oracle Connection:
ERR - Unable to connect to elodev. Error code = 12560

I've tried to run the jbpSA using root  oracle users, both resulted the
same error.
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:
ERROR:
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
to?
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.


--
Best Regards, 
  Adrian Soetanto
  PT. Bentoel Prima - Infrastructure Staff 
  Jl. Raya Karanglo - Singosari, Malang 
  Tel. (+62-341) 298 774 

___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu