Home » RDBMS Server » Backup & Recovery » Password file errors after RMAN duplication
Password file errors after RMAN duplication [message #204073] Fri, 17 November 2006 12:10 Go to next message
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 #204077 is a reply to message #204073] Fri, 17 November 2006 12:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This has nothing to do with RMAN.
Seems your REMOTE_LOGIN_PASSWORDFILE is set to exclusive.
You can disable it by setting it to NONE.
>> The target and duplicate database both use the same password for SYS
Passwordfile is same. but ORACLE_SID is different. right?
That is the issue.
Recreating the passwordfile in clone environment should fix it.
Now in clone environment make sure you have the correct ORACLE_SID defined.
Re: Password file errors after RMAN duplication [message #204103 is a reply to message #204077] Fri, 17 November 2006 18:14 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: Password file errors after RMAN duplication [message #204114 is a reply to message #204104] Fri, 17 November 2006 22:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
how can you create ur database using rman duplicate features if yes. then go through below link and check you did right or you missed some step...
http://www.oracle-base.com/articles/9i/DuplicateDatabaseUsingRMAN9i.php

hope this helps
M.taj
Re: Password file errors after RMAN duplication [message #204167 is a reply to message #204104] Sat, 18 November 2006 08:58 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>1) Is the sandbox using the target DB's control file?
Kind of. The controlfile information and instance information does not match.
first shutdown the database, mount and then open it with resetlogs.
Previous Topic: RMAN.exe file path
Next Topic: Problems while Restoring Hot Backup
Goto Forum:
  


Current Time: Wed Dec 07 08:24:44 CST 2016

Total time taken to generate the page: 0.09994 seconds