- Community of Sharing

Click here for Online Oracle 8i, 9i, 10g, 11g and 12c Training


January 22, 2018, 06:50:56 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
   Home   Help Search Login Register  
Pages: [1] |   Go Down
  Send this topic  |  Print  
Author Topic: ORA-16839: one or more user data files are missing  (Read 38461 times)
Posts: 0

« on: July 28, 2015, 09:20:07 AM »

ORA-16839: one or more user data files are missing
It could be a false alarm. You may have to refresh againg if not recover the datafile from standby.
The broker detected that one or more user data files were missing.

Use Data Repair Advisor to determine which user data files are missing and how the files can be restored.

rman> advise failure all;

Database Role: PRIMARY
List of Database Failures
Failure ID Priority Status    Time Detected Summary
---------- -------- --------- ------------- -------
104088     HIGH     OPEN      28-JUL-15     One or more non-system datafiles are missing

analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=420 device type=DISK
analyzing automatic repair options complete
Mandatory Manual Actions
no manual actions available

Optional Manual Actions
1. If file /oradata/hcmprd/table_data/stwork.dbf was unintentionally renamed or moved, restore it
2. Shut down, mount the database and try flush redo using ALTER SYSTEM FLUSH REDO TO 'standby name' command.  Then perform a Data Guard role change (failover).  Available standbys: hcmcpy_pcf.

Automated Repair Options
Option Repair Description
------ ------------------
1      Restore from standby and recover datafile 117 
  Strategy: The repair includes complete media recovery with no data loss
  Repair script: /app/oracle/diag/rdbms/hcmcpy_acf/hcmcpy_acf/hm/

Check the script and run it at priamry database;
   # restore from standby and recover datafile
   rman> alter database datafile 117 offline;
   rman> restore ( datafile 117 from service "hcmcpy_pcf" );
   rman> recover datafile 117;
   rman> alter database datafile 117 online;

Good luck!
Pages: [1] |   Go Up
  Send this topic  |  Print  
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!