ORA-01111: name for data file 9 is unknown – rename to correct file


Dunen Standby database’de archiveloglarin apply olmasini control etdiyimde maraqli hadise ile qarshilashdim. Archiveloglari Standby terefi qebul ede bilmirdi. Alert loga’a baxdigimda ise ashagdaki shekilde hatalar oldugunu gordum.

Errors in file /u01/app/oracle/diag/rdbms/kbazerdr
/KBAZER/trace/KBAZER_pr00_9844.trc:
ORA-01111: name for data file 9 is unknown - rename to correct file
ORA-01110: data file 9: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00009'
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01111: name for data file 9 is unknown - rename to correct file
ORA-01110: data file 9: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00009'

BU problem hell etmek uchun chalishmaya bashladim. Ilk olaraq Oracle metalinkden arashdirma apardim . (OERR: ORA 1111 name for datafile <name> is unknown - rename to correct file (Doc ID 18685.1)
Standby terefde:
/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00009
Primary :
+DATA/kbazer/datafile/data03.dbf
Burdan rahat bi shekilde gore bilrik ki primary terefde datafile elave edilmish ve datafile size boyuk verildiyi uchun Standby terfdede yer olmadigi uchun bele hatalar almish.
Problemi hell etmek uchun Standby terefde:
SQL> alter system set STANDBY_FILE_MANAGEMENT=MANUAL;
SQL> alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00009'as ‘+DATA’ size XXX
SQL> alter system set STANDBY_FILE_MANAGEMENT=AUTO;
En sonda Primary terfden apply olunmayan archiveloglari Standby terefe apply etmek uchun:
SQL> recover standby database;  
Deyirik.
Archiveloglar Standby terefe apply edildikden sonra  MRP ni ishe saliriq.
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: