Re: recover database from scratch

Hi,

Regarding restoring datafiles in nomount and without a controlfile, have you tried with dbms_backup_restore.RestoreDatafileTo ? There are some examples on the web or on MOS: "How to restore database when controlfile backup missing (Doc ID 1438776.1)"

Regards,
Jure Bratina

On Fri, Jun 16, 2017 at 8:45 PM, Lyall Barbour <lyallbarbour_at_sanfranmail.com
> wrote:

> Hi,
> I feel like this is not as complicated as i'm making it.
>
> Oracle 12.1.0.2
>
> WHat i have: RMAN backup(s) of my database. I have the init.ora file.
> trace file backup of the controlfiles
>
> what i don't have: any datafiles, controlfiles, redo logs, etc.
>
> I can mount the database, but when i try to create the controfiles from
> the trace file, i get
>
> CREATE CONTROLFILE SET DATABASE "BLAH" RESETLOGS FORCE LOGGING ARCHIVELOG
> *
> ERROR at line 1:
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01565: error in identifying file '/oradata01/SFINA021/SYSTEM.01.dbf'
> ORA-27037: unable to obtain file status
> Linux-x86_64 Error: 2: No such file or directory
> Additional information: 3
>
> which is very true. after i created the controlfiles and mounted the
> database, i was going to RMAN and do a CATALOG START WITH, etc. and
> restore...
>
> Help? lol isn't this just a database cloning i'm essentially doing?
>
> Lyall Barbour
>
> -- http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l