RE: recover database from scratch
Date: Fri, 16 Jun 2017 18:49:55 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F136F9D247C_at_NC2PWEX504.us.ad.lfg.com>
You have to create the controlfile in NOMOUNT.
Chris Ruel * Oracle Database Administrator * Lincoln Financial Group cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lyall Barbour
Sent: Friday, June 16, 2017 2:46 PM
To: oracle-l <oracle-l_at_freelists.org>
Subject: recover database from scratch
***This email is from an external source. Only open links and attachments from a Trusted Sender.***
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
Hi,
I feel like this is not as complicated as i'm making it.
*
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 Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 16 2017 - 20:49:55 CEST