ORA-00205: error in identifying control file, check alert log for more info
689479Nov 30 2009 — edited Nov 30 2009Hello!
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.