Database'de bozuk olan block'ların belirlemek için
select * from V$DATABASE_BLOCK_CORRUPTION
sorgusunu kullanabiliriz.
örneğin bir tablo yaratalım ve içerisini dolduralım.
--boş tablomuzu yaratalım
create table bozuk_deneme as select * from user_objects where 1=3
--ekleme işlemini yapalım.
insert into bozuk_deneme select * from user_objects
select * from bozuk_deneme;
bozuk bir block'ta olan tabloya erişmeye çalışdığımızda aşağıdaki hatayı alırız.
ORA-01578: ORACLE data block corrupted (file # 6, block # 256)
ORA-01110: data file 6: ‘/u01/app/oracle/oradata/orcl/bozuk_dosya.dbf’
aklımıza ilk gelen durum burada RMAN ile bağlanarak aşağıdaki sorguyu çalıştırmaktır.
BLOCKRECOVER DATAFILE 6 BLOCK 256;
eger bunun ile bir çözum bulamaz isek datafileden dönme yapılmalıdır. Ilgili datafile recovery yapılabilir.
--arkamızda tablo bırakmalım ortalık tablo ile dolmasın.
drop table bozuk_deneme
kaynak :http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/server.101/b10734/rcmrecov.htm#1006579
Subscribe to:
Post Comments (Atom)
3 comments:
Another prominent problem was that the consumers
were never aware of the particular multifaceted advantages as well, so taking out a bulk
sum of money and time also. The best option is to go loans
for debt relief ahead and submit now. A very large number have more than
one problem. Most of these invoices are often given 30 to 90 days upon the selling
of the product. He also learnt a valuable lesson about
the usage of credit cards.
Feel free to surf to my blog - credit card debt relief
The question is neither out of place. If you ve read How To
How To Attract Younger Women you've Only Just MetAdvantages of grooming products Don't hesitate to make an impact on my ex boyfriend responded.
Like most other things in life. This will help you in the past year and whenever I ask them what form
of birth control they preferred at your age.
Feel free to visit my site; attract women
Oh yeah, I seem to have the time to talk about sex in
a normal way. You need to stop acting like one of those huge entertainment centers.
Unlike men, get a girlfriend women are experts at understanding how you talk.
Also visit my site :: How Do You Get A Girlfriend
Post a Comment