Re: recover database from scratch

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_at_gmail.com>
> Date: 6/16/17 2:59 PM (GMT-05:00)
> To: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
> Cc: oracle-l <oracle-l_at_freelists.org>
> 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_at_sanfranmail.com <mailto:lyallbarbour_at_sanfranmail.com>>
> 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_at_lfg.com <mailto:Chris.Ruel_at_lfg.com>>
> *To:* "lyallbarbour_at_sanfranmail.com
> <mailto:lyallbarbour_at_sanfranmail.com>"
> <lyallbarbour_at_sanfranmail.com
> <mailto:lyallbarbour_at_sanfranmail.com>>, oracle-l
> <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>>
> *Subject:* RE: recover database from scratch
>
> 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
> <tel:%28317%29%20759-2172> * Cell 317.523.8482
> <tel:%28317%29%20523-8482>
>
> *From:*oracle-l-bounce_at_freelists.org
> <mailto:oracle-l-bounce_at_freelists.org>
> [mailto: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
> <mailto: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.***
>
> 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>
>
> 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-l
> <http://www.freelists.org/webpage/oracle-l>
>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'

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