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@xxxxxxxxxxxxxxx
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
-- //www.freelists.org/webpage/oracle-l