If you have any full backups it should have backed up the control file as part
of a full backup.
Sent from my iPad
On Jun 17, 2017, at 12:58 PM, Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:
Do you have a backup? Where is the backup? If the backup is complete and
contains a control file, you can do "duplicate database" with "BACKUP
LOCATION" argument.
On 06/17/2017 01:31 PM, Lyall Barbour wrote:
Hi Everyone,
So from reading around, the only way the CREATE CONTROLFILE statement
works is by having the datafiles (maybe everything else in the statement) in
place.
Since that's not my case, and i don't have the autobackup'ed controlfiles
(i think they were backedup but to a location that has been deleted), how
the heck do i restore my database...?
Lyall
Sent: Saturday, June 17, 2017 at 12:57 PM
From: "Lyall Barbour" <lyallbarbour@xxxxxxxxxxxxxxx>
To: gogala.mladen@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: recover database from scratch
ya, we don't have an rman catalog database. we do it in the controlfiles of
each database.
Obviously something we need to look at in the future (near)
Sent: Saturday, June 17, 2017 at 12:46 PM
From: "Mladen Gogala" <gogala.mladen@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: recover database from scratch
Lyall, if autobackup is set to on, then the backup media contains the auto
backup of the control file. Also, the X that marks the spot should be
available in the RMAN configuration. Do you have catalog? If you do, the
configuration should be visible, regardless of a non-existing control file.
Regards
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> 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>
To: "lyallbarbour@xxxxxxxxxxxxxxx" <lyallbarbour@xxxxxxxxxxxxxxx>, oracle-l
<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 * Desk:317.759.2172 * Cell 317.523.8482
From: 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>
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
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
and any printout. Thank You.**
-- //www.freelists.org/webpage/oracle-l
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
-- //www.freelists.org/webpage/oracle-l
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217