Home » RDBMS Server » Backup & Recovery » problem while restoring cold backup
problem while restoring cold backup [message #62652] Fri, 06 August 2004 01:30 Go to next message
dr alex
Messages: 18
Registered: June 2004
Junior Member
I have taken cold backup of Database, OS was Windows 2000 Server and Oracle 8.1.5.0 (Enterprise Edition).

I wanted to restore this cold backup in another computer with same OS and Oracle Enterprise Edition with same SID. I have replaced the init.ora file also.

While trying to connect as internal, I am getting the following error:

ERROR:
ORA-01031: insufficient privileges

Oracle service is started.

Pls help me.

Anup

(Nepal)
Re: problem while restoring cold backup [message #62654 is a reply to message #62652] Fri, 06 August 2004 03:16 Go to previous messageGo to next message
puneet
Messages: 76
Registered: August 2002
Member
just try connecting with 'sys' user as sysdba.

rgds
PB
Re: problem while restoring cold backup [message #62657 is a reply to message #62652] Fri, 06 August 2004 06:33 Go to previous messageGo to next message
Lisa
Messages: 31
Registered: September 2000
Member
It sound like a 'password file' issue. You might need to recreate your password file.

First check your parameter file to see if "init.ora file" parameter remote_login_passwordfile is set to EXCLUSIVE. If so, password file is required.

Good luck!
Lisa
Re: problem while restoring cold backup [message #62726 is a reply to message #62657] Tue, 10 August 2004 23:41 Go to previous message
dr alex
Messages: 18
Registered: June 2004
Junior Member
You are right, the problem was in password file.
I replaced the password file(backup) and everything is ok.
Thanks.
Anup
(Nepal)
Previous Topic: RMAN PROMPT NOT COMING
Next Topic: RMAN job very slow
Goto Forum:
  


Current Time: Sat Nov 23 20:32:00 CST 2024