Friday, August 29, 2014

ora-1111 , ora-1110 RMAN Recovery

-- RMAN  recovery terminated on test server as new file was added on prod  and RMAN fails to create the new datafile  on test server

ora-1111
ora-1110

Metalink doc id 739618.1

alter database create datafile 
       '/ora01/oracle/product/11.2.0.4/db/dbs/UNNAMED00068'
as  
      '/oradata01/oracle/oradata/DEMO/SCOTT_DATA10.dbf';