I know this is after the fact, but in my daily bkup script i have the
following, just to CYA....
alter database backup controlfile to trace as
'/home/oracle/bobmc/db_build/$ORACLE_SID.ctl';
This creates a full control file daily in the event i need to reference
it. I also have the same
script that fires off anytime i add new tablespaces or files.
bob
On 06/16/2017 04:05 PM, lyallbarbour wrote:
Wish I had the autobackup controlfiles... can't find them. Just found the tracefiles. I'll be checking all the basc when I get home, like what Bob suggested.
Lyall
Sent via the Samsung Galaxy Note® 4, an AT&T 4G LTE smartphone
-------- Original message --------
From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
Date: 6/16/17 2:59 PM (GMT-05:00)
To: Lyall Barbour <lyallbarbour@xxxxxxxxxxxxxxx>
Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject: Re: RE: recover database from scratch
I havent tried this in a long time, but dont you need to set the dbid before you run the catalog command? I think the sequence would be set dbid, create controlfile, mount, catalog start with...
But if you have full database backups, you should have a backup of the control file in there somewhere to restore.
On Fri, Jun 16, 2017 at 1:54 PM, Lyall Barbour <lyallbarbour@xxxxxxxxxxxxxxx <mailto:lyallbarbour@xxxxxxxxxxxxxxx>> wrote:
sorry. i meant NOMOUNT.
i have been just running the create controlfile tracefile script,
which does the startup nomount in it.
any other ideas?
*Sent:* Friday, June 16, 2017 at 2:49 PM
*From:* "Ruel, Chris" <Chris.Ruel@xxxxxxx <mailto:Chris.Ruel@xxxxxxx>>
*To:* "lyallbarbour@xxxxxxxxxxxxxxx
<mailto:lyallbarbour@xxxxxxxxxxxxxxx>"
<lyallbarbour@xxxxxxxxxxxxxxx
<mailto:lyallbarbour@xxxxxxxxxxxxxxx>>, oracle-l
<oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>>
*Subject:* RE: recover database from scratch
You have to create the controlfile in NOMOUNT.
_____________________________________________________________________
Chris Ruel * Oracle Database Administrator * Lincoln Financial Group
cruel@xxxxxxx <mailto:cruel@xxxxxxx>* Desk:317.759.2172
<tel:%28317%29%20759-2172> * Cell 317.523.8482
<tel:%28317%29%20523-8482>
*From:*oracle-l-bounce@xxxxxxxxxxxxx
<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx
<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] *On Behalf Of *Lyall Barbour
*Sent:* Friday, June 16, 2017 2:46 PM
*To:* oracle-l <oracle-l@xxxxxxxxxxxxx
<mailto:oracle-l@xxxxxxxxxxxxx>>
*Subject:* recover database from scratch
***This email is from an external source. Only open links and
attachments from a Trusted Sender.***
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
<//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.**
-- //www.freelists.org/webpage/oracle-l
<//www.freelists.org/webpage/oracle-l>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'