Re: recover database from scratch
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sat, 17 Jun 2017 14:55:04 -0500
Message-Id: <5A0DC76E-76FD-4B1F-9412-75A3DD395722_at_gmail.com>
>>> On Fri, Jun 16, 2017 at 1:54 PM, Lyall Barbour <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>
>>> To: "lyallbarbour_at_sanfranmail.com" <lyallbarbour_at_sanfranmail.com>, oracle-l <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 * 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.***
>>>
>>> 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
>>>
>>>
>>>
>>>
>>>
>>> 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
Date: Sat, 17 Jun 2017 14:55:04 -0500
Message-Id: <5A0DC76E-76FD-4B1F-9412-75A3DD395722_at_gmail.com>
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_at_gmail.com> 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_at_sanfranmail.com> >> To: gogala.mladen_at_gmail.com >> Cc: oracle-l_at_freelists.org >> 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_at_gmail.com> >> To: oracle-l_at_freelists.org >> 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_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> 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>
>>> To: "lyallbarbour_at_sanfranmail.com" <lyallbarbour_at_sanfranmail.com>, oracle-l <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 * 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.***
>>>
>>> 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
>>>
>>>
>>>
>>>
>>>
>>> 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
>> >> >> >> -- >> Andrew W. Kerber >> >> 'If at first you dont succeed, dont take up skydiving.' >> >> >> -- >> Mladen Gogala >> Oracle DBA >> Tel: (347) 321-1217 >> -- http://www.freelists.org/webpage/oracle-l > > -- > Mladen Gogala > Oracle DBA > Tel: (347) 321-1217
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jun 17 2017 - 21:55:04 CEST