25 04, 2006
刚才在论坛里看到 lovexueer做了个试验http://www.itpub.net/533872.html，用这个隐含参数不能恢复！试了半天，发现情况一样，于是就查了下，发现他说的这种情况根本就不能用这个参数恢复成功！原文参见1013221.6（metalink）。
这个主要针对8i，对于9i有些涉及到rollback 色光segment的地方注意下，但大体不变！
一、当由于undo的原因数据库down了后，当你试图启动的时候遇到了ora-1157和ora-1110，在这种情况下依赖数据库down的时候，是否在undo里留下了未提交的事务！
1、如果没有遗留的事务在undo内，那么最简单的恢复办法就是offline drop这个文件，然后以restricted模式打开数据库，删除这个undo表空间，下面是步骤：
a、在alert.log中查看数据库是否干净的关闭。
b、注释掉(8i)rollback_segments或则加(9i)_corrupted_rollback_segments = ( <rollback1>,...., <rollbackN> ) 同时把undo_management改为manual
c、startup restrict mount
d、alter database datafile 'file_name' offline drop;
e、recover database until cancel;(这步可能用到redo，多试几次）
f、alter database open resetlogs;
ｇ、导出全库
ｈ、重建数据库
ｉ、导入新库
２、如果数据库并不是干净的关闭，也就是说undo内留有未提交的事务，那么这时候不能够简单的利用offline drop这个回滚文件，你必须从一个备份中恢复这个文件，并进行介质恢复！如果是在非归档模式下，仅当在线日志包含恢复过程中需要的日志信息，以下是步骤：
a、从备份中恢复丢失的文件
b、mount数据库
c、查看文件状态，如果为offline，那么你必须online它
select file#,name,status from v$datfile;
alter database datafile 'full_name' online;
d、查看日志文件信息
select v1.group#,member,sequence#,first_change#
from v$log v1,v$logfile v2
where v1.group#=v2.group#;
e、如果是在非归档模式下
select file#,change# from v$recover_file;
如果change#大于在线日志文件的最小的first_change#，那么这个数据文件将能恢复。如果chage#小于最小的first_chage#，那么不能恢复
f、recover datafile 'full_name'
g、确认所有在线日志文件都被应用
h、打开数据库
二、如果数据库是打开状态
如果在数据库处于运行状态，你发现了丢失会滚数据文件，那么有两种办法：
1、offline drop,并从备份中恢复
a、alter database datafile 'full_name' offline ;
b、恢复丢失的文件
c、select v1.group#,member,sequence# from v$log v1,v$logfile v2where v1.group#=v2.group#;
e、recover datafile 'full_name';
f、alter database datafile 'full_name' online';
2、重新创建会滚表空间
a、alter rollback segment <roll name> offline;
b、查看所有回滚段是否都已offline
select segment_name,status from dba_rollback_segswhere tablespace_name='<tablespace_name>';
c、删除offline的回滚段
drop rollback segment <roll name>;
e、查看所有剩余仍为online的会滚段
SELECT SEGMENT_NAME, XACTS ACTIVE_TX, V.STATUS
FROM V$ROLLSTAT V, DBA_ROLLBACK_SEGS
WHERE TABLESPACE_NAME = '<TABLESPACE_NAME>' AND SEGMENT_ID = USN;
如果没有返回行，说明所有的已经offline；如果返回行，状态显示为pending offline，那么查看active_tx,如果为0，那么没有悬挂的事务，很快就会变为offline，如果大于0，那么看下一步
f、SELECT S.SID, S.SERIAL#, S.USERNAME, R.NAME "ROLLBACK"
FROM V$SESSION S, V$TRANSACTION T, V$ROLLNAME R
WHERE R.NAME IN ('<PENDING_ROLLBACK_1>', ... , '<PENDING_ROLLBACK_N>')
AND S.TADDR = T.ADDR AND T.XIDUSN = R.USN;
杀死上面发现的这些会话：
alter system kill session 'sid,serial#';
g、drop tablespace ... including contents;
h、重新创建表空间和回滚段！
to: Admin - If You want to delete your site from my spam list, please sent url of your domain to my e-mail: stop.spam.today@gmail.com
And I will remove your site from my base within 24 hours
webmastegz
I very much love summer :)
Someone very much loves winter :(
I Wish to know whom more :)
For what you love winter?
For what you love summer? Let's argue :)
Hi all, it's a job offer. (Sorry if I post it in wrong place)
Cyprus company is looking for a Campaign Executive to assist with fundraising, presentations, various administrative and sales management duties. If you have fundraising and sales experience, plus intermediate computer knowledge, this job is for you! Apply with us today!
All applicants applying for U.S. job openings must be authorized to work in the United States. All applicants applying for European job openings must be authorized to work in European Union.
We are growing advertising and consulting company offering job opportunities ranging from executive and administrative assistants to customer service representatives, receptionists and general support.
NOTICE: we do not provide relocation, this position is online based, we are using progressive online administrative system. You will have to use a special online training program for free.
Requirements and skills:
1. Higher Education/College
2. 1 + Sales/Management (desired but optional)
3. Strong communicative skills
4. Must have MS Office installed (MS Word)
5. Must have citizenship or Work Permit
6. Adult age
Education and Experience:
1. Internet/MS Office/Outlook
2. Sales/Management/Marketing courses (desired)
Hours:
Mon-Fri; 9:30am - 12:30pm
Apply for this job now or contact our online branch support for additional information:
CV to e-mail manager@mygogreens.com
作者 jobbercypr 07 02 2009, 06:04Hey... sorry for my english, where I can [b]download XRumer 5.0 Palladium FOR FREE[/b]??? Thanks!!!
It's perfect software for promo and SEO, but cant find any crack for it((
cracked XRumer 2.9 and XRumer 3.0 are too old, Im need FRESH!
SMS Trap is something that never fails to help you get your partner off guard
作者 tesulcell 01 03 2009, 16:58Hallo! Is there anybody here to tell me how much time have we got left till the end of the lesson?
作者 kevindagnycu 04 03 2009, 21:54Hi everyone
Do you want to lose weight quickly,please check this site,
and you will find a lot of valuable information.
It will teach you how to lose weight go right.
Good luck.
Hi everyone
I just became a part of this site here and I would love to be a part of it.
The world's largest online poker room, with more poker games at every level,
bigger tournaments and more players than any other site.
Good luck.
Good day!
Methamphetamine is one of the actionable drugs and it is a actual able addictive substance.
It is a psycho analeptic drug. It is acclimated to amusement attention-deficit-
hyperactivity disorder. It is a clear anatomy of hydrochloride which can activate the afraid
system. Sometimes it is acclimated as a medication decree for obesity. It is contrarily
alleged as meth, ice, clear or glass. It is acclimated illegally to abate the weight and to
maintain, actuate the medical accuracy and for recreation. Comparing added drugs it is
actual adverse to the afraid arrangement and it affects some of the academician systems. It
will accessible alone as a decree but it is refilled. It is awful accessible to abusage and
it can be able in the baby class but it pollutes the ambiance while producing.
Methamphetamine can be acclimated in the anatomy of syringe, smoke and it can additionally
be taken orally. The being who misuses this biologic will anon become aficionado by acute
added dosage than the accustomed dosage. This addiction can be advised by the behavioral
therapy. The use of meth can be aloof by sleeping and bistro at appropriate time. Sometimes
this may accredit to acceleration but it is amphetamines. The meth inhaled and smoked will
drop on the academician and affect the beef bind over the brain. The blush of the meth can
alter by their manufacturers and they are accessible in the anatomy of pills or tablets. The
analysis for meth is actual circuitous back the absorbed being is afflicted by any
affliction and some brainy depression.
Effects of Methamphetamine
The furnishings of methamphetamine are disconnected into concise and abiding effect. The
concise aftereffect may accommodate added attention, action and decreased fatigue, appetence
and it access the amount of respiratory arrangement and the claret pressure. Some of the
abiding or abiding furnishings includes the accident of weight, changes the ascendancy of
academician and afraid system, accident of above organs such as heart, lung etc, agitated
behavior, amoral active of vehicle, affection agitation and anxiety. The abusage of meth may
additionally address the infection of HIV and hepatitis b and c.
Symptoms of Meth Addiction
If the being withdraws the acceptance of meth again the afterward affection such as
depression, anxiety, accident of weight, acute biologic abstraction etc will occur. It
increases the akin of neurotransmitter which stimulates the academician beef and it changes
the affection of the being who takes meth. Methamphetamine additionally amercement the
corpuscle of animals back they access into their body. The dopamine and serotonin which
contains neuron does not die afterwards the use of meth. Instead they abolish the action of
analysis and accord acceleration to advance of new cells. The being who uses meth undergoes
affecting problems and anamnesis loss.
作者 meceengintema 08 03 2009, 05:30Never underestimate the power of the internet. An increasing number of people use the internet
to search for a business or service so having a web presence is an important media for promoting
your company. Web design is a real skill and if your website is to not only look good but work well,
it should be constructed by a professional web designer.
If you are interested, you can contact me: hqwebdesign (AT) gmail (DOT) com
作者 DaveCahonne 11 03 2009, 01:42Millions are currently adverse the blackmail of foreclosure or are absolutely activity
through foreclosure affairs appropriate now. Despite the actuality that this has abominably
become article of a trend lately, alive that others are activity through it as able-bodied
does not abate the affliction and annoyance of foreclosure.
The acumen for accepting to go through a foreclosure usually has to do with not
actuality able to accomplish ends accommodated - not alone with mortgage payments, but with
all banking obligations. In added words: it's a money thing. If you are activity through a
foreclosure, you are apparently adverse a cardinal of abundant banking worries that alone
add to your problems: car payments, ascent acclaim agenda bills, and alike aggravating to
appear up with hire so you can acquisition a abode to alive afterwards you leave your home.
Loans for bodies in foreclosure can be aloof what are bare to get through a boxy time in
their lives. If you are in charge of a claimed loan, new acclaim card, or a new mortgage
accommodation appropriate now, actuality are 4 tips for accepting a loan:
1. A foreclosure saps your already-strained banking resources
If you are currently in foreclosure, you are already beggared for cash. Now, you face
affective out of your home and award about new to live. This can force you to acquire a
cardinal of accompanying costs, such as the amount of analytic for a new abode to live, the
amount of demography time off of assignment to accomplish the move, affairs some new
furnishings, and alike advantageous for movers and gas. All of these added costs aloof add
to the accountability of what is already a actual boxy banking bearings for you.
2. You can get a mortgage or auto accommodation alike if you accept bad credit
The acceptable account is that there is an absolute cottage industry of appropriate
lenders who are committed to extending auto and new mortgage loans to bodies adverse
foreclosure. This is alike accurate if your acclaim account is currently dismal, accustomed
that it has been aged by this accomplished process.
3. You can still get acclaim cards alike if you accept bad credit Having addition acclaim
agenda appropriate now may be the aftermost affair you anticipate you need, but anticipate
again. A new acclaim agenda can accommodate you with the adeptness to accomplish concise
purchases to advice you through this alteration time, afterwards which you can set up a
abbreviate time aeon to pay it down.
Trouble is, with accepted acclaim agenda companies it can be adamantine to get accustomed
for a new acclaim agenda aback you are activity through a foreclosure or accept bad credit.
Fortunately, there are assorted acclaim agenda companies who are added than accommodating
to accessible a agenda for bodies in your situation. Of course, you may accept to pay a
college absorption amount than if you had arch credit. But, if you attending at this as a
concise accommodation to get you through this boxy time and you pay it aback bottomward
quickly, the college absorption ante will not amount you abundant extra.
4. You can alike get an apart claimed loan
Even for bodies activity through foreclosure, it is alike absolutely accessible to
defended an apart claimed loan. "Unsecured" artlessly agency that you do not accept to put
up any accessory for the loan. You aloof get the loan, no questions about accessory asked.
You can use a claimed accommodation for annihilation you like, including advantageous added
costs during your accepted alteration aeon or alike demography a vacation with your
ancestors while you array out what you are activity to do next.
Loans for bodies in foreclosure are a reality. Today, there are dedicated, absolutely
accepted lenders in the banking bazaar who apperceive that times are tough, and they are
accommodating to advice you get through this asperous patch.
作者 Patotadia 09 04 2009, 08:07[b]VeriSupport has launched the world's first SUPPORT RANKING PROGRAM[/b]
And it is available now! You can choose to buy from stores which are VeriSupport certified and ranked ensuring that you are protected from online breeches and fraudulent organizations. Look for the VeriSupport seal when you buy from an online store, as VeriSupport seal in a website tells you, the organizations ability to provide support like live customer service, technical support and other helpdesk functions [b]before, during and after the sale[/b]; the ability to handle customer feedback and their reliability as a company.
VeriSupport's Support Ranking Program provides a number of benefits to you including:
1. You can be confident that there is a support channel for addressing your issues and concerns,
2. You have the power to comment and rate in real-time about your experience.
3. You can be confident that you are dealing with a reliable business
4. Assurance that transactions are secure
VeriSupport helps your visualize support levels of the organization that you could deal with! and now its your decision choose VeriSupport certified organization for a hassle free experience!
Look for the VeriSupport seal provided by [u][b]VeriSupport.Com[/b][/u], every time!
To determine which anti-aging cream is conquer in the service of you, you have to essential check up on what is your main problem. Is it unilluminated under-eye circles? Or crow's feet? Or worse, both? After determining your unmanageable, your next step is to search as a service to the spin-off that will-power work unsurpassed in place of you.The greatest fetish to do is to ask around for recommendations, and it is even-tempered think twice to catch a guidance from a dermatologist. During your search, recall to scrutinize the ingredients. Always recognize to manipulate joined that has been dermatologically tested to arrest any allergy break-outs. The anti-aging cream which has not been tested puissance be cheaper, but value should not be an urgent factor. After all, if you sample adverse side effects from the anti-aging cream, you wish end up spending more.Choose an anti-aging cream which is chock-full of anti-oxidants as well as vitamins to nurse your shell while treating it. Retinol, an anti-oxidant, is a important ingredient which is usually organize in these anti-aging creams. Another ingredient to look after an view out for is Kinetin which irons in view your fleece wrinkles aside supplying more collagen to the skin. This constituent also helps to victual your coating conglomerate in time to come moisturized.Meanwhile, alpha hydroxyl acids which should be for the present in most anti-aging creams exfoliate the skin. Tired out veneer cells are removed to ball smoother, newer outside cells underneath.Natural innate ingredients such as grape issue, grassland tea and aloe vera are exclude additions to anti-aging creams. They complement the anti-aging cream's act and wishes allow you well-advised results. If you are unsure of the ingredients stated at the labels, manage efficient supporter from a pharmacist or a dermatologist.When you entertain initiate an anti-aging cream that suits your fleece needs the most suitable, you should supplementation your sustenance repayment for exemplar results. In this way, your veneer will not only look younger but healthier too. Keeping away from buttery, oily eatables and trash eatables will better create tonic film cells.Finding the just or best anti-aging cream for you and your epidermis doesn't drink to be difficult. Due be modelled after the steps mentioned in the sky and you will procure the shape, youthful visage you want.To influence rid of anti aging logotype, try Lifecell Anti-Wrinkle Cream. You can seascape the to come and after photo here after using Lifecell, Anti Aging Cream.Article Source:
作者 QLDonaldac 02 05 2009, 13:31Hello, everyone! Nice forum, nice discussions!
Can you, guys, tell me how i can upload an avatar so that it could be displayed with all my posts? i'm just newbe in using forums and can't find this feature here.
P.S. i'm sorry, may be i'm posting to the wrong category, but i just want to use all features of the board.
作者 greatterrakomp 24 05 2009, 18:13Greetings,
What is the cheapest web hosting company?
I'm want to build a web site for my new business.
Thank you,
-Wendy
作者 Hosypeapsenly 12 06 2009, 01:12Tired of a competitor's site? Hinder the enemy? Fed pioneers or copywriters?
Kill their sites! How? We will help you in this!
Obstructions of any site, portal, shop!
Different types of attacks: Date-attack, Trash, Attack, Attack, etc. Intellectual
You can work on schedule, as well as the simultaneous attack of several sites.
On average the data, ordered the site falls within 5 minutes after the start. As a demonstration of our capabilities, allows screening.
Our prices
24 hours of attack - $ 70
12 hours of the attack - $ 50
1 hour attack - $ 25
Contact via ICQ: 588 666 582
作者 Roaphy 14 06 2009, 01:54I saw that Casey Fronczek is offering fishing trips now down in south Florida. Does anybody have any input on these trips or has anyone been on one of these trips before?
作者 CaseyFronczek 22 06 2009, 02:39He put his eye to the hole. He just managed to spy some people sitting in deckchairs chanting, before a finger came out of nowhere and poked him in the eye. As he staggered back, the people started chanting, "Fourteen, fourteen, fourteen..."
作者 odolvevulse 11 07 2009, 14:24Tuesday, August 11, 2009
WEARABLE TOWEL: Infomercial Review
The other day my wife asked me if I had seen the infomercial yet for the Wearable Towel. You heard right: The WEARABLE Towel. And probably your response was much the same as mine: Isn't every towel pretty much wearable? I know my wife wears one around her hair every time she gets out of the shower. I've never figured out why. Guys don't do that. Are women bashful about us seeing their naked hair?
But I digress....My wife said this is different because, whereas most towels have trouble staying on when you try to cover up桰MPORTANT areas梩he Wearable Towel stays on just fine. So I saw the infomercial and now I see why.
It turns out the Wearable Towel has strap-arm-sleeve thingies for that extra little bit of support. Wear it one way and it looks for all the world like you're wearing a toga. Or put both arms through it and it appears to be a woman's night gown.
揟here are two reasons I won't wear that,
作者 nfomercial Review 15 08 2009, 19:43Who knows where to download XRumer 5.0 Palladium?
Help, please. All recommend this program to effectively advertise on the Internet, this is the best program!
free porn demo videos free amateur porno p cs free preview lesbian sex videos free live video sex list free hand job porn videos funny sexy videos cell phine free manga sex video free horse videos xxx free home movies sloppy blowjobs free sex video posting college amateur cams sex free arab sex video free full hd porn movies short lesbian porn videos house sex video wife
作者 meegulfileake 28 11 2009, 00:09well hey there guys, i've been looking all over the internet for a GOOD black hat SEO forum.. I was looking for some suggestions
from you guys to point me in the right direction.
Thanks a bunch, this place is great btw.
作者 eixaldaSnowxie 05 02 2010, 18:53Hello, as you can see this is my first post here.
Hope to get any help from you if I will have any quesitons.
Thanks in advance and good luck! :)
abbif Generic cialis gss Buy Generic Cialis dt zxud Generic Cialis online [url=http://create.ull.edu/]Buy Cialis Online kaeksu[/url] adfgser343 unjaiyw vyygv pt cialis with no prescription md zixj qgkym.
作者 sretyhvrstvdtm 21 05 2010, 00:58hot skinny ebony babe with huge tits hardcore fucked on desk hardcore gallery sex twilight blowjobs hardcore free hardcore porn pix free hardcore cartoon porn pictures
作者 RobertNasarros 22 05 2010, 19:10hardcore viberator orgy hardcore asian anal star wars hardcore hentai hardcore party sex hardcore hentai fucking
作者 RobertNasarros 28 05 2010, 18:51hardcore porn free movies hardcore fuck cum hardcore shemale porn free hardcore medical bondage videos hardcore party teenager
作者 RobertNasarros 31 05 2010, 04:27free hardcore fuck pics sexy ebony gang bang hardcore hardcore gay hunk threesome 1st time at party hardcore free hardcore alana leigh sex scene video
作者 RobertNasarros 02 06 2010, 18:21Did not notice and hair loss improvement but had bad impact on sex drive, erection and semen.
Finasteride can be absorbed through the skin, and women or children should not be permitted to handle Propecia tablets.
You may need to discuss other treatment options.
medication Propecia
I started suffering from hair loss just recently.
My doctor prescribed me this medicine.
After 1 month of using it, my hair doesn't fall any more. Buying Propecia here
I've been using Propecia for about 10 years and it seems to be working very well. However, I'm still losing hair in the crown area but at a very slow rate.
Overall, I'm very happy with Propecia.
I wish I could find it a little cheaper. It's expensive! go to source
After 1 month of using it, my hair doesn't fall any more.
Until now I continue using it and there's no other side effects.
This medicine is so amazing! [url=http://www.oswd.org/user/profile/id/73199]
buy cheap online flomax[/url]
Admin or Moder!
WARNING!
If you will not delete this topic within 5 days - Spam will be here, I promise!
Goot Lak! God Fak!
作者 checkmoderator 06 06 2010, 11:15Admin or Moder!
WARNING!
If you will not delete this topic within 5 days - Spam will be here, I promise!
Goot Lak! God Fak!
作者 checkdmin 12 06 2010, 14:17People from all over the world have acne or skin blemishes. This affects men, women, and adolescents. The article offers tips, natural solutions, and a great performing product Proactive Solution.
It's true that having pimples and blemishes on your face can be embarrassing. Acne lowers your confidence level and this can affect your school, home, and work life.
You feel like everyone is looking at your pimple or blemish.
You feel just like staying home!
Acne is known as pimples, lumps, and plugged pores that appear on the face, neck, face, shoulders and chest areas.
There is not one main factor that causes acne and it is stimulated by hormones, stress, puberty, food, and other factors.
The sun can also dry out the outer layer of your skin encouraging your sebaceous glands to start producing more oil.
No one is immune to skin blemishes when the conditions are there.
Medicine has produced many products to help relieve your acne. They are also quite a few natural remedies.
Here are some practical natural solutions that may reduce your acne.
First you need to start eating better and stop eating foods loaded with sugars, fats, and oils.
Fried food will not only put on the pounds but also may make your acne worse.
Drinking a lot of water will also help. The water will flush the toxins that are causing the acne out of your body. You
You should drink at least 24 ounces per day.
Another solution is to rub apricot juice on your face for at least 10 minutes a day. This natural product will help clear your skin of pimples.
Toothpaste is also a great way to get rid of skin blemishes. You should rub the toothpaste into the effected areas and leave it over night. Then wash is off in the morning.
If the natural solution does not work there are a ton of products on the market.
One product that seems to stand above the rest is Proactiv.
The Proactive skin care products offer a three step system to clear your skin.
It is available online or at your local retail store. There are many celebrities who swear by the product.
Proactive Solution is also relatively inexpensive compared to other less productive products.
There are simple things your can do to prevent your acne from occurring in the first place.
Always be gentle with your face. Water that is too hot or cold can trigger your sebaceous glands to over produce oil and clog up your skin.
You should wash your face at least twice a day to keep the bacteria levels to a minimum.
Do not touch your face. The hands carry the most bacteria and you do not to place the bacteria here.
You should also wash your hands many times a day. This will help keep the bacteria levels low in case you touch your face.
For women who use makeup wear oil free or hypo-allergenic makeup for sensitive skin.
Men should use antiseptic products for razor burn that are designed to clear the pores and moisturize the skin.
To conclude men, women, and adolescents can suffer from confidence destroying acne and skin blemishes. There are natural remedies and a great product called Proactive Solution that can really help keep your acne to a minimum. There are also things you can do to prevent acne. Defeat your acne and face the world again!
作者 Twelloche 12 07 2010, 00:16pcos and glucophage buy glucophage online false alcohol test readign and glucophage glucophage dira polycystic ovarian disease glucophage glucophage interaction mechanism of action of metformin glucophage lawsuit fortamet glucophage death
buy glucophage online
order glucophage xl booty growing glucophage phentermine and glucophage glucophage hair loss glucophage online pharmacy glucophage coumadin interaction glucophage 500 mg p o glucophage powered by vbulletin version 3.6.5 mechanism of action of metformin glucophage emphysematous gallbladder and glucophage glucophage lunesta
作者 tinarryLisa 17 07 2010, 06:14