Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00205: error in identifying control file, check alert log for more info

689479Nov 30 2009 — edited Nov 30 2009
Hello!

Oracle 11.1.0.6. After having successfully duplicated a database from host x to host y I do a "shutdown immediate" followed by a "startup". Then I get "ORA-00205: error in identifying control file, check alert log for more info" with the following related lines in the alert log:

ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.1.0/db_1/dbs/cntrlbadkar.dbf'

Before I started rman duplicate, I've copied and edited the pfile from host x. The copied version is as follows

*.compatible='11.1.0.0.0'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='badkar'
*.db_recovery_file_dest='+DATA'
*.db_recovery_file_dest_size=21474836480
*.db_create_file_dest='+DATA'
*.diagnostic_dest='/u01/app/oracle'
*.log_archive_dest_10='LOCATION=USE_DB_RECOVERY_FILE_DEST OPTIONAL REOPEN=300'
*.nls_territory='SWEDEN'
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
SGA_TARGET=6144M

rman commands as folllows:

RMAN> run {
2> SET UNTIL SEQUENCE 41228 thread 1;
3> allocate auxiliary channel ch1 type disk;
4> duplicate target database to badkar nofilenamecheck;
5> }

Why could I not shutdown and startup a successful rman duplicate? Why does Oracle look for the controlfile at the non ASM:ish location: /u01/app/oracle/product/11.1.0/db_1/dbs/cntrlbadkar.dbf? When I edited the pfile from host x I filtered out the control_files line, is that the root to my problem? Please advice, BR Niklas.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2009
Added on Nov 30 2009
6 comments
4,762 views