Password file errors after RMAN duplication [message #204073] |
Fri, 17 November 2006 12:10 |
clintonf
Messages: 82 Registered: May 2006
|
Member |
|
|
Hi all,
My duplicate database is unable to open after I bounce it because of an invalid password file.
I was able to fully duplicate my target database and I checked by running some simple queries on it.
However, when I bounce the database (or reboot the system) I get the following error when trying to start the instance:
ORA-01991: invalid password file 'C:\<path>\PWDboo.ORA'
Followed by the following errors:
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'C:\<path>\system01.dbf'
ORA-01206: file is not part of this database - wrong database id
To see what was happening I re-duplicated the target, closed RMAN and then connected to RMAN to see what the DBID's of each database were. They were different but evidently become the same after the above errors.
I tried to create a new password file with orapwd but that hasn't helped.
The target and duplicate database both use the same password for SYS (I'm going to change it after I have this all working). Could this be what's causing the error?
Thanks for any help you can provide.
|
|
|
|
Re: Password file errors after RMAN duplication [message #204103 is a reply to message #204077] |
Fri, 17 November 2006 18:14 |
clintonf
Messages: 82 Registered: May 2006
|
Member |
|
|
Hi Mahesh,
I tried your suggestions (ORACLE_SID and parameter) but am not having any luck.
I set the REMOTE_LOGIN_PASSWORDFILE to 'none' in my init.ora file for the duplicate db. I then duplicated the target database. It doesn't look like it is staying 'none'.
The initilization parameters show that the parameter is set to 'EXCLUSIVE'. If I alter the system to set the parameter to 'NONE' and then bounce the database (I get the DBID error and the DB is opened in MOUNT mode) then the remote_login_passwordfile is set to 'NONE' but I still get the DBID error when I try to open with resetlogs:
SQL> ALTER DATABASE open RESETLOGS;
ALTER DATABASE open RESETLOGS
*
ERROR at line 1:
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\SANDBOX\SYSTEM01.DBF'
ORA-01206: file is not part of this database - wrong database id
SQL>
Any ideas of what may be wrong?
Thanks!
|
|
|
Re: Password file errors after RMAN duplication [message #204104 is a reply to message #204103] |
Fri, 17 November 2006 18:51 |
clintonf
Messages: 82 Registered: May 2006
|
Member |
|
|
It looks like sandbox is using the controlfile of the target DB:
If I try to use NID to change the DBID of sandbox I get this:
DOS>nid target=sys/mypasswd@sandbox
DBNEWID: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
Connected to database SANDBOX (DBID=3309219400)
NID-00131: Control file is not current
Change of database ID failed during validation - database is intact.
DBNEWID - Completed with validation errors.
DOS>
So I guess the questions are:
1) Is the sandbox using the target DB's control file?
2) How do I get sandbox to use its own control file?
As always, your assistance is very appreciated.
Thanks.
|
|
|
|
|