Re: datafile_problem

Posted by Arsalan on Mar 07, 2017; 12:42pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/datafile-problem-tp2282p2285.html


RMAN> connect target /

connected to target database: DWHSIG (DBID=1978044831, not open)

RMAN> recover datafile 1;

Starting recover at 07-MAR-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=189 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=221 device type=DISK

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/07/2017 17:16:43
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 datafile 1
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
-----------------------------------------------------------------------------------------------------


SQL> startup
ORACLE instance started.

Total System Global Area 6847938560 bytes
Fixed Size                  2188768 bytes
Variable Size            3120564768 bytes
Database Buffers         3707764736 bytes
Redo Buffers               17420288 bytes
Database mounted.
ORA-01190: control file or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: 'C:\APP\SIGTAS\ORADATA\DWHSIG\SYSTEM01.DBF'