dba-tony.com dba-tony.com

dba-tony.com

focus on oracle----------------- by oracle dba Tony | tony dba oracle

Focus on oracle—————– by oracle dba Tony. 概括一下故障处理应该叫 数据库datafile offline drop后的恢复. 操作系统linux redhat Oracle 11.2.0.2单节点. SQL alter database datafile ‘/oradata1/* *LOG02.dbf’ offline drop;. Rm rf /oradata1/* * LOG02.dbf. Select file name file id, tablespace name status from dba data files where file id=24;/oradata1/* * *LOG02.dbf 24 WEBINTAKE RECOVE. Dba在删除数据文件的时候用的命令是错误的,offline drop offline drop并不会删除数据文件,只会讲数据文件置为一种离线状态,如果数据没有归档的话,这是一种风险很大的操作。 Thu Mar 13 14:06:21 2014. Oracle rac在安装过程中可能会遇到各种问题,有一些是能提前准...

http://www.dba-tony.com/

WEBSITE DETAILS
SEO
PAGES
SIMILAR SITES

TRAFFIC RANK FOR DBA-TONY.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

May

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

CUSTOMER REVIEWS

Average Rating: 4.0 out of 5 with 6 reviews
5 star
3
4 star
0
3 star
3
2 star
0
1 star
0

Hey there! Start your review of dba-tony.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

Desktop Preview Tablet Preview Mobile Preview

LOAD TIME

CONTACTS AT DBA-TONY.COM

DOMAIN WHOIS PROTECTION SERVICE

WHOIS AGENT

3/F.,HiChina Mansion,No.27 ●●●●●●●●●●●●●●●●●●●●●●●●●●●strict,Beijing 100120,China

Be●●ng , Beijing, 100120

CN

8610●●●●2266
8610●●●●8796
do●●●●●●●@hichina.com

View this contact

DOMAIN WHOIS PROTECTION SERVICE

WHOIS AGENT

3/F.,HiChina Mansion,No.27 ●●●●●●●●●●●●●●●●●●●●●●●●●●●strict,Beijing 100120,China

Be●●ng , Beijing, 100120

CN

8610●●●●2266
8610●●●●8796
do●●●●●●●@hichina.com

View this contact

DOMAIN WHOIS PROTECTION SERVICE

WHOIS AGENT

3/F.,HiChina Mansion,No.27 ●●●●●●●●●●●●●●●●●●●●●●●●●●●strict,Beijing 100120,China

Be●●ng , Beijing, 100120

CN

8610●●●●2266
8610●●●●8796
do●●●●●●●@hichina.com

View this contact

DOMAIN WHOIS PROTECTION SERVICE

WHOIS AGENT

3/F.,HiChina Mansion,No.27 ●●●●●●●●●●●●●●●●●●●●●●●●●●●strict,Beijing 100120,China

Be●●ng , Beijing, 100120

CN

8610●●●●2266
8610●●●●8796
do●●●●●●●@hichina.com

View this contact

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

DOMAIN REGISTRATION INFORMATION

REGISTERED
2014 April 30
UPDATED
2014 April 30
EXPIRATION
EXPIRED REGISTER THIS DOMAIN

BUY YOUR DOMAIN

Network Solutions®

DOMAIN AGE

  • 10

    YEARS

  • 11

    MONTHS

  • 27

    DAYS

NAME SERVERS

1
dns13.hichina.com
2
dns14.hichina.com

REGISTRAR

HICHINA ZHICHENG TECHNOLOGY LTD.

HICHINA ZHICHENG TECHNOLOGY LTD.

WHOIS : grs-whois.hichina.com

REFERRED : http://www.net.cn

CONTENT

SCORE

6.2

PAGE TITLE
focus on oracle----------------- by oracle dba Tony | tony dba oracle | dba-tony.com Reviews
<META>
DESCRIPTION
Focus on oracle—————– by oracle dba Tony. 概括一下故障处理应该叫 数据库datafile offline drop后的恢复. 操作系统linux redhat Oracle 11.2.0.2单节点. SQL alter database datafile ‘/oradata1/* *LOG02.dbf’ offline drop;. Rm rf /oradata1/* * LOG02.dbf. Select file name file id, tablespace name status from dba data files where file id=24;/oradata1/* * *LOG02.dbf 24 WEBINTAKE RECOVE. Dba在删除数据文件的时候用的命令是错误的,offline drop offline drop并不会删除数据文件,只会讲数据文件置为一种离线状态,如果数据没有归档的话,这是一种风险很大的操作。 Thu Mar 13 14:06:21 2014. Oracle rac在安装过程中可能会遇到各种问题,有一些是能提前准...
<META>
KEYWORDS
1 toggle navigation
2 数据库datafile异常删除故障处理案例
3 tony
4 1 comment
5 这是一个很有趣的真实案例,客户的操作很有趣,恢复的步骤也很有意思
6 环境描述
7 客户的dba看表空间不足,于是想采用加一个数据文件的方式来对表空间进行扩容
8 可是加完以后发现表空间的名字写错了,加到了其他的表空间中
9 这时,他想删掉这个数据文件,让数据库吻痕删除
10 接下来的错误操作来了 他在确认了没数据之后使用了也下命令来进行删除数据文件
CONTENT
Page content here
KEYWORDS ON
PAGE
toggle navigation,数据库datafile异常删除故障处理案例,tony,1 comment,这是一个很有趣的真实案例,客户的操作很有趣,恢复的步骤也很有意思,环境描述,客户的dba看表空间不足,于是想采用加一个数据文件的方式来对表空间进行扩容,可是加完以后发现表空间的名字写错了,加到了其他的表空间中,这时,他想删掉这个数据文件,让数据库吻痕删除,接下来的错误操作来了 他在确认了没数据之后使用了也下命令来进行删除数据文件,然后他发现数据文件在操作系统中还存在,索性在操作系统中来个彻底删除
CONTENT-TYPE
utf-8
GOOGLE PREVIEW

focus on oracle----------------- by oracle dba Tony | tony dba oracle | dba-tony.com Reviews

https://dba-tony.com

Focus on oracle—————– by oracle dba Tony. 概括一下故障处理应该叫 数据库datafile offline drop后的恢复. 操作系统linux redhat Oracle 11.2.0.2单节点. SQL alter database datafile ‘/oradata1/* *LOG02.dbf’ offline drop;. Rm rf /oradata1/* * LOG02.dbf. Select file name file id, tablespace name status from dba data files where file id=24;/oradata1/* * *LOG02.dbf 24 WEBINTAKE RECOVE. Dba在删除数据文件的时候用的命令是错误的,offline drop offline drop并不会删除数据文件,只会讲数据文件置为一种离线状态,如果数据没有归档的话,这是一种风险很大的操作。 Thu Mar 13 14:06:21 2014. Oracle rac在安装过程中可能会遇到各种问题,有一些是能提前准...

OTHER SITES

dba-thoughts.blogspot.com dba-thoughts.blogspot.com

Thoughts Of A DBA

Thoughts Of A DBA. Monday, 25 August 2014. Recover Data from Damaged/Corrupted/Inconsistent/Offline/Truncated/Dropped Table While the Database is Offline. In this post I'll discuss one of these tools, Oracle Database Unloader (ODU). Http:/ www.oracleodu.com/en/download. Full version: It restores all data only if you got the license file from the support [Not Free]. Upload the downloaded file to the server and then extract it:. Gunzip odu 433 linux x86.tar.gz. Tar xvf odu 433 linux x86.tar. Chown u x odu.

dba-tip-trick.blogspot.com dba-tip-trick.blogspot.com

Oracle DBA Tip and Trick

Oracle DBA Tip and Trick. Database Administrator Tips and Tricks applying with every version of Oracle (i.e. Oracle 8i/9i/10g/11g) including PL/SQL, Trigger, Store Procedure. Also provide how to install Oracle on Linux platform and MS Windows platform and Oracle Error and The Solution to solve them. This is default featured slide 1 title. Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions. This is default featured slide 2 title. Wednesday, April 8, 2015.

dba-tips.blogspot.com dba-tips.blogspot.com

Database Administration Tips

If you can't explain it simply, you don't understand it well enough." Albert Einstein. Wednesday, February 28, 2018. DBA Bundle V4.1 Released. DBA Bundle V4.1 is now released with the following new scripts. Backup ctrl spf AWR.sh. Backup Controlfile as (Trace/RMAN BKP), Backup SPFILE and Generate AWR for full day This script can be scheduled in the crontab to run once a day. Script options/variables must be modified to match your environment. New Starting from V4.1. Kill long running queries.sh. It will ...

dba-tony.com dba-tony.com

focus on oracle----------------- by oracle dba Tony | tony dba oracle

Focus on oracle—————– by oracle dba Tony. 概括一下故障处理应该叫 数据库datafile offline drop后的恢复. 操作系统linux redhat Oracle 11.2.0.2单节点. SQL alter database datafile ‘/oradata1/* *LOG02.dbf’ offline drop;. Rm rf /oradata1/* * LOG02.dbf. Select file name file id, tablespace name status from dba data files where file id=24;/oradata1/* * *LOG02.dbf 24 WEBINTAKE RECOVE. Dba在删除数据文件的时候用的命令是错误的,offline drop offline drop并不会删除数据文件,只会讲数据文件置为一种离线状态,如果数据没有归档的话,这是一种风险很大的操作。 Thu Mar 13 14:06:21 2014. Oracle rac在安装过程中可能会遇到各种问题,有一些是能提前准...

dba-trade.com dba-trade.com

Index of /

Proudly Served by LiteSpeed Web Server at www.dba-trade.com Port 80.

dba-trading.com dba-trading.com

DBA Trading

Press enter to begin your search. We are a Miami based company with more than 30 years of experience in video, photography, audio, and projection technologies. We count with the technical and professional support from worldwide leading manufactures. To offer high technology solutions and quality products efficiently while providing the best brand support and world class customer service. 8475 NW 29 TH Street Doral, FL, 33122. Telephone: 1.305.702.7985.

dba-treuhand.at dba-treuhand.at

Wirtschaftsprüfer, Steuerberater Wels

PARTNER TREUHAND Salzburg GmbH. Springe direkt zum Inhalt. Springe direkt zum Menü. PARTNER TREUHAND Salzburg GmbH Steuerberatungsgesellschaft. Spenden- / Sponsoring- / Inseratanfragen. Für Vermieter / Immobilien. Für Banken and Versicherungen. Rechts- u. Steuerinfos. Entscheidend am Start - Information und Beratung. Seit vielen Jahren begleiten wir innovative Menschen auf ihrem erfolgreichen Weg. Rechnen Sie mit uns. Profitieren Sie von unserem Serviceangebot. Was Sie wissen sollten. Was wir unseren Kun...

dba-tricks.blogspot.com dba-tricks.blogspot.com

Tricks for Oracle DBA's

Tricks for Oracle DBA's. In this blog I will publish short tips that can make life easier to the crowd of Oracle DBA's around the world (at least in my intention). Wednesday, March 14, 2012. How to recover a database with missing archived redo logs. Have you ever faced the situation where you need to recover a database with missing archives, and because of that Oracle won't let you open the database? Here is an excelent article. Explaining what to do. Sunday, March 11, 2012. ASM has two diskgroups: FLASH.

dba-tuerkei.com dba-tuerkei.com

Steuerberater Gülec & Gschwendtner in Landshut

Steuerberater Güleç and Gschwendtner in Landshut. Steuerberater Güleç and Gschwendtner in Landshut. Wir beraten Sie gerne in allen Baulohnabrechnungs Fragen. Erfahren Sie mehr über Selbstanzeige. Wir beraten Sie gerne in allen rechtlichen Fragen. Wir beraten Sie gerne. Zusammenstellung wichtiger Unterlagen und Informationen. Ihre Steuerberater Güleҫ and Gschwendtner in Landshut. Wir freuen uns über Ihren Besuch und heißen Sie im Namen unseres gesamten Teams herzlichst willkommen…. Tel: 0871 / 953538 00.