recover database from scratch
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Fri, 16 Jun 2017 20:45:54 +0200
Message-ID: <trinity-3c1d4068-a28c-4af7-b80a-ccfc560e26be-1497638754085_at_3capp-mailcom-lxa12>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 16 2017 - 20:45:54 CEST
Date: Fri, 16 Jun 2017 20:45:54 +0200
Message-ID: <trinity-3c1d4068-a28c-4af7-b80a-ccfc560e26be-1497638754085_at_3capp-mailcom-lxa12>
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
*
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