iSelfSchooling.com - Community of Sharing

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

from www.iSelfSchooling.com

November 18, 2017, 12:27:19 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 38384 times)
AllanDBA
AllanDBA
Newbie
Newbie
*
Posts: 0


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

ORA-16839: one or more user data files are missing
Cause:
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.

Action:
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
r
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/reco_1879012159.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!
Logged
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!