Re: RMAN restore

Posted by ErmanArslansOracleBlog on Nov 17, 2016; 6:01pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-restore-tp1563p1568.html

It seems, there are some missing database file. (some file cannot be accessed)

1)Send me the restore log.

2)When was this Backup taken?

17 Kas 2016 19:41 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <
[e-mail]> yazdı:

> I took a fresh backup of the control file. I then restored it on the test
> instance and started mount. When I ran the restored, it managed to proceed.
>
> I am now getting the error below in alert log file
>
>
> ORA-01122: database file 4659 failed verification check
> ORA-01110: data file 4659: '/ORADATA7/WINSRATDB/TSRATFAILURECDRJUN16_ROD.dbf'
>
> ORA-01565: error in identifying file '/ORADATA7/WINSRATDB/TSRATFAILURECDRJUN16_ROD.dbf'
>
> ORA-27037: unable to obtain file status
> Linux-x86_64 Error: 2: No such file or directory
> Additional information: 3
> Thu Nov 17 16:18:08 2016
> Errors in file /opt/app/oracle/diag/rdbms/winsdb/WINSDB2/trace/WINSDB2_m002_1569.trc:
>
> ORA-51106: check failed to complete due to an error.  See error below
> ORA-48223: Interrupt Requested - Fetch Aborted - Return Code [12751]
> [HM_INFO]
> ORA-27037: unable to obtain file status
> Linux-x86_64 Error: 2: No such file or directory
> Additional information: 3
> ORA-01122: database file 4778 failed verification check
> ORA-01110: data file 4778: '/ORADATA8/WINSMEDDB/TSMEDCDR28SEP16.dbf'
> ORA-01565: error in identifying file '/ORADATA8/WINSMEDDB/TSMEDCDR28SEP16.dbf'
>
> ORA-27037: unable to obtain file status
> Linux-x86_64 Error: 2: No such file or directory
> Additional information: 3
>
> my rman script is :
>
> connect target /
>
> connect auxiliary /
>
>
> run {
> ALLOCATE  CHANNEL CH1 TYPE 'SBT_TAPE';
> ALLOCATE  CHANNEL CH2 TYPE 'SBT_TAPE';
> ALLOCATE  CHANNEL CH3 TYPE 'SBT_TAPE';
> ALLOCATE  CHANNEL CH4 TYPE 'SBT_TAPE';
> ALLOCATE  CHANNEL CH5 TYPE 'SBT_TAPE';
> ALLOCATE  CHANNEL CH6 TYPE 'SBT_TAPE';
> ALLOCATE  CHANNEL CH7 TYPE 'SBT_TAPE';
>
>
> SEND 'NSR_ENV=(NSR_SERVER=rhis-nwdd-1202, NSR_DATA_VOLUME_POOL=004,
>           NSR_CLIENT=10.178.1.67)';
> SET NEWNAME FOR DATABASE TO '/data/WINSDB/%U';
>
> restore database;
> #crosscheck backup;
>
>
> }
>
> Thanks,
> ROshan
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
> http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/
> RMAN-restore-tp1563p1567.html
> To start a new topic under Database, email ml-node+s2340467n4h8@n4.
> nabble.com
> To unsubscribe from Erman Arslan's Oracle Forum, click here
> <http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=ZWFyc2xhbkBwYXJ0bmVyYS5jb20udHJ8MXwxODQ5OTg2NjU2>
> .
> NAML
> <http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>