Users will see this error when a new Data file is created and it is not part of the backup. An UNNAMED datafile name is added to the control file and file is created under $ORACLE_HOME/dbs
Errors in file /home/oracle/saptrace/diag/rdbms/orac/ORAC/trace/ORAC_pr00_16269.trc:
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 83 is unknown - rename to correct file
ORA-01110: data file 83: '/home/oracle/11.2.0/dbs/UNNAMED00083'
ORA-01157: cannot identify/lock data file 83 - see DBWR trace file
ORA-01111: name for data file 83 is unknown - rename to correct file
ORA-01110: data file 83: '/home/oracle/11.2.0/dbs/UNNAMED00083'
Recovery Slave PR00 previously exited with exception 283
ORA-283 signalled during: ALTER DATABASE RECOVER DATABASE UNTIL TIME '2012-10-02:23:15:00'USING BACKUP CONTROLFILE ...
Solution:
Find the UNNAMED data file using below command.
SQL> SELECT FILE#, NAME FROM V$DATAFILE
FILE# NAME
-------- -----------------------------------------
1 /dbs01/ORAC/system01.dbf
2 /dbs01/ORAC/sysaux01.dbf
4 /dbs01/ORAC/users01.dbf
5 /home/oracle/11.2.0/dbs/UNNAMED00083
....
Rename an UNNAMED Data file using below command.
SQL> alter database create datafile '/home/oracle/11.2.0/dbs/UNNAMED00083' as '/dbs01/ORAC/ /prd_data83.dbf';
Database altered.
Once you create data file proceed with recovery, if needed.
Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com
your solution helped me from very critical solution... so many thanks
ReplyDeleteIt is cool that you describe. sexyescortservice.com
ReplyDeleteI also wrote an article on a similar subject will find it at write what you think. improving conversion rates
ReplyDeleteYou possess lifted an essential offspring..Blesss for using..I would want to study better latest transactions from this blog..preserve posting.. https://www.pageview.com/
ReplyDeleteThe Digital World has recently realized the immense need of Data Scientists to solve problems using Data, and since then this profession is growing with leaps and bounds. data science course in hyderabad
ReplyDeleteWhen we think of Data, we actually tend to think of 0s and 1s and most the Information Technology industries like social media, e-commerce, the block chain, crypto-technology etc. data science course in hyderabad
ReplyDeleteI truly like your interpretation of the issue. I now have an unmistakable thought on what this matter is about.. options financial market scams
ReplyDeleteSome towns round the sector provide bodily bitcoin ATMs. You simply get your bitcoins via them the usage of neighborhood fiat foreign money. Governments adjust the makes use of of those ATMs for protection purposes.Bitcoin ATMs near me
ReplyDeleteEnjoyed every single word of your blog article. Thanks to share it!
ReplyDeletemitsubishi 3 star inverter ac