Saturday, August 4, 2012

How to restore a NOARCHIVELOG database using a backup controlfile

Let's simulate a different restore scenario for a NOARCHIVELOG database compared with this previous post. Be sure to have set the backup controlfile option in RMAN to ON, before taking your first backup as I did. This approach, using the controlfile coming from the autobackup, is different compared with the copy of an available multiplexed copy of a current controlfile because there you have to perform an incomplete recovery of your database, while using the autobackup controlfile you have already a controlfile with SCN consistent with all your datafiles
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
I shutted down my database...
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
and then removed all my datafiles, redolog and current controlfile
[oracle@localhost orcl]$ ls
APEX_1930613455248703.dbf  example01.dbf  redo02.log  sysaux01.dbf  temp01.dbf
users01.dbf
control01.ctl              redo01.log     redo03.log  system01.dbf
undotbs01.dbf
[oracle@localhost orcl]$ rm *
From rman console I typed the following commands:
[oracle@localhost orcl]$ rman target /
RMAN> startup nomount;
RMAN> restore controlfile from autobackup;

Starting restore at 17-JUL-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK

recovery area destination: /home/oracle/app/oracle/flash_recovery_area
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: AUTOBACKUP
/home/oracle/app/oracle/flash_recovery_area/ORCL/autobackup/2012_07_17/o1_mf_s_788864449_80c39jlo_.bkp
found in the recovery area
AUTOBACKUP search with format "%F" not attempted because DBID was not set
channel ORA_DISK_1: restoring control file from AUTOBACKUP
/home/oracle/app/oracle/flash_recovery_area/ORCL/autobackup/2012_07_17/o1_mf_s_788864449_80c39jlo_.bkp
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=/home/oracle/app/oracle/oradata/orcl/control01.ctl
output file
name=/home/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl
Finished restore at 17-JUL-12
And now I'm able to at least mount my database
RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1
and check that my database is using a backup controlfile
[oracle@localhost orcl]$ sqlplus / as sysdba
SQL> select controlfile_type from V$DATABASE;

CONTROL
-------
BACKUP
From the rman console issue the restore command.
RMAN> restore database;

Starting restore at 17-JUL-12
Starting implicit crosscheck backup at 17-JUL-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
Crosschecked 4 objects
Finished implicit crosscheck backup at 17-JUL-12

Starting implicit crosscheck copy at 17-JUL-12
using channel ORA_DISK_1
Finished implicit crosscheck copy at 17-JUL-12

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name:
/home/oracle/app/oracle/flash_recovery_area/ORCL/autobackup/2012_07_17/o1_mf_s_788864449_80c39jlo_.bkp

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to
/home/oracle/app/oracle/oradata/orcl/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to
/home/oracle/app/oracle/oradata/orcl/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to
/home/oracle/app/oracle/oradata/orcl/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to
/home/oracle/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to
/home/oracle/app/oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to
/home/oracle/app/oracle/oradata/orcl/APEX_1930613455248703.dbf
channel ORA_DISK_1: reading from backup piece
/home/oracle/app/oracle/flash_recovery_area/ORCL/backupset/2012_07_17/o1_mf_nnndf_TAG20120717T090114_80c32cxk_.bkp
channel ORA_DISK_1: piece
handle=/home/oracle/app/oracle/flash_recovery_area/ORCL/backupset/2012_07_17/o1_mf_nnndf_TAG20120717T090114_80c32cxk_.bkp
tag=TAG20120717T090114
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:07
Finished restore at 17-JUL-12
Finally open your database with the resetlogs option
RMAN> alter database open resetlogs;

database opened
Your database is now available again. These two posts are really unusual real world scenario because (I hope) you are not running your database in noarchivelog mode... So in the next posts my database will be set in ARCHIVELOG mode and several recovery scenario will be solved. That's all.

59 comments:

Anonymous said...

I thіnk this іs one of the most ѵital information
for mе. And i'm glad reading your article. But should remark on some general things, The site style is great, the articles is really great : D. Good job, cheers

Here is my web blog; build a healthy brain
My web site brain health supplements

Anonymous said...

Howԁy admіn, I juѕt ωаnted to giѵе you a
brief heads up that yοur current Web lіnk:
http://www.blogger.com/comment.g?blogID=3005934468887687781&postID=5116847707259393298 is bеing
flаggeԁ as a potentіаlly malіcіous blog in my internet browser internet еxplorеr.

I'd highly suggest having somebody look into it. You could very well lose a lot of website visitors due to this problem. Best of Luck.

http://www.dfw-taxicab.com/taxi-cab-service-areas-and-fares/
Check out my website - DFW cab company

Anonymous said...

purchase xanax xanax dosage during pregnancy - xanax generic pictures pills

Anonymous said...

tramadol no prescription tramadol for dogs dosage per pound - can you overdose tramadol hcl

Anonymous said...

I сomment each timе I appreciate a аrticlе οn а blog or if I haѵе somеthing to add to the ԁisсussion.

Usually it's caused by the sincerness displayed in the post I browsed. And on this post "How to restore a NOARCHIVELOG database using a backup controlfile". I was excited enough to post a commenta response :) I do have a couple of questions for you if it's allright.
Could it be simply me or does іt look lіkе lіkе a feω
οf thesе respоnseѕ
look like they aгe сoming from braіn dead folks?
:-P Anԁ, if уоu are poѕting at
other placeѕ, I'd like to keep up with anything new you have to post. Would you list the complete urls of all your social pages like your linkedin profile, Facebook page or twitter feed?

Visit my webpage :: tens machines
my web page > tens machine

Anonymous said...

generic xanax order xanax mail - what does xanax pills do to you

Anonymous said...

buy tramadol online buy tramadol online usa - buy tramadol online cod overnight

Anonymous said...

generic xanax pass drug test with xanax - xanax effects drinking

Anonymous said...

buy tramadol online tramadol withdrawal weight gain - tramadol for dogs interactions

Anonymous said...

order xanax online xanax high fun - xanax withdrawal kidney pain

Anonymous said...

buy tramadol cheap online tramadol good opiate withdrawal - can order tramadol online legally

Anonymous said...

generic xanax online xanax prescription doctors - generic drug name xanax

Anonymous said...

xanax online little white xanax pills - buy xanax online without rx

Anonymous said...

order tramadol online tramadol for dogs dosage - buy generic tramadol

Anonymous said...

buy carisoprodol online no prescription long does carisoprodol take kick - side effects of carisoprodol 350

Anonymous said...

xanax generic xanax withdrawal anxiety - xanax side effects webmd

Anonymous said...

buy tramadol online tramadol 50mg does get you high - tramadol 50 mg street value

Anonymous said...

buy carisoprodol carisoprodol 350 mg withdrawal - 350 mg carisoprodol generic soma

Anonymous said...

buy tramadol online tramadol for dogs in humans - tramadol 100mg dose

Anonymous said...

buy tramadol online tramadol 650 - tramadol yeast infection

Anonymous said...

xanax online pictures of generic xanax pills - xanax under tongue or swallow

Anonymous said...

buy tramadol online buy tramadol for dogs online - buy tramadol online reviews

Anonymous said...

buy cialis 10mg cialis online consultation - cialis online us pharmacy

Anonymous said...

buy tramadol cheap online is tramadol/ultram an opiate - buy tramadol ultram ultracet online

Anonymous said...

buy tramadol tramadol dosage per day - buy tramadol from usa

Anonymous said...

order tramadol tramadol 50 mg drug facts - tramadol dosage and dogs

Anonymous said...

http://landvoicelearning.com/#44827 cheap tramadol no prescription overnight - high on tramadol 50mg

Anonymous said...

tramadol online no prescription is buying tramadol online illegal - tramadol dosage chart for dogs

Anonymous said...

buy tramadol tramadol hcl 50 mg withdrawal - 500mg tramadol overdose

Anonymous said...

tramadol 100 mg ultram er tramadol hcl - legal buy tramadol online us

Anonymous said...

http://buytramadolonlinecool.com/#73892 tramadol no prescription needed - tramadol 50 mg back pain

Anonymous said...

buy tramadol online tramadol hcl oral tablet 50 mg - tramadol addiction forum 2012

Anonymous said...

tramadol 50 tramadol hcl humans - tramadol 50 mg medicine

Anonymous said...

tramadol online canadian online pharmacy tramadol - what is the good dose of tramadol

Anonymous said...

ativan 2mg ativan dosage in children - ativan addiction recovery

Anonymous said...

buy tramadol 001webs com buy tramadol online - tramadol hcl side effects humans

Anonymous said...

ways to buy ativan online ativan withdrawal and seizures - ativan dosage teenager

Anonymous said...

http://bayshorechryslerjeep.com/#rx xanax dosage for dogs by weight - generic xanax 0.25

Anonymous said...

It's remarkable to go to see this web page and reading the views of all friends about this paragraph, while I am also eager of getting knowledge.

Also visit my weblog ... how to buy and sell cars for profit

Anonymous said...

ӏ'm really impressed with your writing skills as well as with the layout on your weblog. Is this a paid theme or did you modify it yourself? Either way keep up the excellent quality writing, it's rare to see a niсe blog like thіs οne today.


Also viѕit my web раge ... best dallas seo company

Anonymous said...

What i dοn't realize is in reality how you are no longer actually a lot more neatly-favored than you might be now. You'гe
ѕo intelligent. Yοu гecognize thus sіgnificantly in
гelation to this topic, produсeԁ me in my viеw belіeve it
fгom a lot of numегous angles.
Its lіκe men anԁ ωomen arеn't involved except it is something to accomplish with Woman gaga! Your individual stuffs excellent. All the time maintain it up!

My web blog :: dallas seo company

Anonymous said...

The repоrt has сonfirmed helρful tο mysеlf.
It’s vеry helpful and уοu reallу
are clearly еxtгеmely knoωledgeable іn
this area. Yοu have got ροppeԁ
mу own face to be аblе to diffeгent thoughts abοut this particulaг subjeсt mattеr with
intrіguing and sounԁ content matеrial.
Also visit my website ... buy viagra online

Anonymous said...

Yоur article offers сonfirmed beneficіal to
me perѕοnally. Ιt’s extгemely
helpful and yоu arе naturally really educatеd of this type.
You have got expоseԁ оur eyes to be able tо dіfferent ѵiews on this ѕρeсifiс subjесt matteг along
wіth intгiquing, notable and strong contеnt.
Have a look at my page ; viagra

Anonymous said...

Intercombase - Business translation text any of more than 140 languages. Technical Translation, Engineering Translation, Marketing Translation - first class affordable.

Norwegian Translation - [url=http://www.intercombase.com]Japanese[/url]

Anonymous said...

Concern Fresh Wind offers a construction investment for different tariff plans. Now , overcame the recent financial crisis, more ponder how invest the money at interest . According to conclusions of many of the leading the best analysts, one of the most investment of money in the construction of . Everyone knows that the construction of less exposed to the risk of falling prices, in addition a given that, construction has always been important and in demand, and will be in demand. Even the economic crisis did not recaptured removed the desire for people to buy their own property. Therefore, investment in construction will always remain relevant and profitable.

Fwit.Biz: [url=https://fwit.biz]where to invest[/url]

oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

oakleyses said...

abercrombie and fitch, instyler, ghd, bottega veneta, ugg boots, jimmy choo outlet, soccer shoes, ugg pas cher, herve leger, beats by dre, birkin bag, abercrombie and fitch, north face jackets, soccer jerseys, mont blanc, rolex watches, lululemon outlet, celine handbags, nike roshe run, nike trainers, giuseppe zanotti, hollister, wedding dresses, nike huarache, mcm handbags, vans shoes, chi flat iron, babyliss pro, north face outlet, nike roshe, ugg australia, ugg, marc jacobs, barbour, nfl jerseys, p90x, new balance shoes, asics running shoes, ferragamo shoes, mac cosmetics, insanity workout, uggs outlet, reebok outlet, longchamp, valentino shoes

oakleyses said...

converse, air max, gucci, canada goose, juicy couture outlet, canada goose, wedding dresses, moncler, ralph lauren, lancel, montre homme, moncler, louboutin, oakley, karen millen, vans, coach outlet store online, air max, canada goose jackets, ugg, hollister clothing store, louis vuitton, baseball bats, hollister, rolex watches, juicy couture outlet, iphone 6 cases, canada goose uk, canada goose outlet, ugg, moncler, moncler outlet, timberland boots, hollister, supra shoes, moncler, canada goose, converse shoes, toms shoes, moncler, moncler, canada goose, ugg boots, ray ban, parajumpers, canada goose

Anonymous said...

smokeless cigarettes, electronic cigarettes reviews, electronic cigarette, smokeless cigarettes, best e cigarette, electronic cigarette starter kit

Unknown said...

Oakley's sports marketing man, Steve Blick, says the company's sponsored pros have taken notice, with around 25 percent of them choosing to go big.Optically, Oakley once again hits it out of the park oakley women with the RadarLock XL lens. It produces no noticeable distortion (compared to some budget models that have given us headaches) and is finished with refreshingly dull edges that we anticipate would be less likely to oakley sunglasses for women cut you in a crash. As usual with Oakley, the selection of lens tints is generous, and includes both polarized and photochromic options. As with any large-format piece of eyewear, though, the RadarLock XL glasses aren't totally immune to fogging, particularly on slower and steeper climbs at higher humidity levels. That said, vents across the top edge help, and the fogging dissipates quickly once the speed picks up again.
Aside from protecting your eyes, you need your glasses to be comfortable and to stay in place. Versatility is army oakley sunglasses important too, which is why some cycling glasses come with different coloured lenses, while others allow you to specify prescription optics. Let’s not forget aesthetics, either. After all, we all like to look good, and it might even save you money if it means you don’t need another pair of glasses for non-riding days. Here’s our pick of this oakley eyeglasses year’s shades so you can choose your perfect pair.Custom bikes and clothing used to be almost exclusively for professional riders. These days, you can buy custom designs – if not custom fabrication – of seemingly everything, from shoes and helmets to frames and saddles. Even nutrition and training plans can be tailored just for you. Here are just a discount oakley sunglasses few of your not-off-the-shelf options.

Ray Bans Outlet said...

If you need more traffic to your website check out the website in my name. It really helped me and i think it.
Ray Ban Outlet,Ray Ban Online,Ray Ban Sunglasses
Cheap Jerseys From China,Cheap NFL Jerseys
Ray Ban Outlet Store,Cheap Ray Ban
Oakley Outlet Online,Oakley Outlet Store
Cheap Ray-Ban Sunglasses,Ray Ban Sunglasses Outlet
Oakley Outlet Store,Cheap Oakley Sunglasses
Oakley Sunglasses
nfl jerseys whosale,nfl jerseys
Ray Ban Outlet

Unknown said...

Flaherty established the council in 2008 during the previous recession. Oliver’s 16-member group is three larger than Flaherty’s most recent council and retains Paul Desmarais Jr., co-chief executive of Power Corp. of Canada, Teck Resources Ltd. CEO Don Lindsay and Nancy Southern, chief executive of Calgary-based Atco Ltd.While most schools offer aid packages that cover tuition for the neediest students, those grants don't free them from every financial constraint. Many of the scattered incidental costs of college can become daunting when one is stretching scholarships, or relying on loans, just to live and study at an elite campus. At Ivy League schools, where enough students wear canada goose toronto high-end Canada Goose jackets to inspire Tumblr accounts about their ubiquity, moments such as graduation can bring class disparity into sharp relief. Plenty of small costs for optional events lead up to commencement: At Columbia, for example, students are invited to attend a senior ball ($95 a ticket), enjoy a cruise ($52 a ticket), and purchase yearbooks ($85 a copy). Other private schools offer similar extras. Yet missing graduation because of its cost is a particularly painful symbol of exclusion.
And Jasmine isn't the only young person in southern Ontario standing up for animals. In Burlington, parka canada goose seven-year-old Vijay Radul is working to break a Guiness World Record by folding 1,000 origami whales to help free the animals at Marineland. And in Oakville, nine-year-old Vienna Del Mastro recently asked friends and family to donate to the Oakville and Milton Humane Society instead of buying her birthday presents, raising more than $500. "I don't want to hurt [animals], eat them or wear their skin," Vienna said. "I used to wear a Canada Goose coat, but now that I know how they're made, I can't ever wear one again."
Canada Goose has a similar strategy: Mackey http://www.canadagoosejacketsoutletonlinesale.com is coming out of retirement to drive a team of dogs in the 2015 Iditarod. He’ll be the one in the coyote-fur hood, looking like so many of Manhattan’s bright young bankers.This collection was decidedly aimed at rakish, 1970s-loving urbanites. My favorite look was one with a fur-trimmed hood, which you may think is an advanced style but is actually becoming really common on urban goose down jackets men. (Those Canada Goose jackets you all have? Many come with fur lining on top.) Look closely at the discreet details here: The shoulder has some nice piping, the blue suede shoes are actually hiking boots, and the nipped-but-floppy proportions are unusual but well thought out.Sears Canada Inc. was sued for trademark infringement by Toronto-based Canada Goose Inc.

Homeabortionpillsrx said...

Very interesting post.
Buy Mtp Kit Online Fast shipping to terminate early pregnancy.

Onlineabortionrx said...

Thanks for the post!
Buy Mtp Kit Online to remove pregnancy tissue from the uterus.

shasheasl said...

over at this website Read More Here here a knockout post review click to read

coasaez said...

read review this hyperlink view it get more look at this web-site page

zopiclone for sale uk said...

The website has also a quality control department of its own which checks the quality of the products before selling them online.

modalert 200mg australia said...

The best place to buy the products online is the website called nootraplus.com.

Best Element Bicycles at Low Prices in India said...

Each bike is built with high-quality components and is rigorously tested to ensure that it meets our standards for performance and durability.