易截截图软件、单文件、免安装、纯绿色、仅160KB

Oracle Flashback Technology


Oracle Flashback Technology
Oracle Flashback Technology reduces recovery time from hours to minutes.
from: http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
According to many studies, 40% of application outages are caused by operator or user errors. Part of being human is making mistakes. But these errors are extremely difficult to avoid and can be particularly difficult to recover from without advance planning and the right technology. Such errors can result in "logical" data corruption, or cause downtime of one or more components of the IT infrastructure. While it is relatively simple to rectify the failure of an individual component, detection and repair of logical data corruption, such as accidental deletion of valuable data, is a time consuming operation that causes enormous loss of business productivity. Typical user-errors may include accidental deletion of valuable data, deleting the wrong data, and dropping the wrong table.
Guarding Against Human Errors
The Oracle Database architecture leverages the unique technological advances in the area of database recovery due to human errors. Oracle Flashback Technology provides a set of new features to view and rewind data back and forth in time. The Flashback features offer the capability to query historical data, perform change analysis, and perform self-service repair to recover from logical corruptions while the database is online. With Oracle Flashback Technology, you can indeed undo the past!
Oracle9i introduced Flashback Query to provide a simple, powerful and completely non-disruptive mechanism for recovering from human errors. It allows users to view the state of data at a point in time in the past without requiring any structural changes to the database.
Oracle Database 10g extended the Flashback Technology to provide fast and easy recovery at the database, table, row, and transaction level. Flashback Technology revolutionizes recovery by operating just on the ch


相关文档:

Oracle的tnsnames.ora文件 以便plsql/developer 访问

####################################
# TNSNAMES.ORA Configuration File:D:\Oracle_now\NETWORK\ADMIN\tnsnames.ora 文件位置
# Generated by Oracle Enterprise Manager V2
# Date..........: Tue Jan 26 20:05:00 CST 2010
####################################
TEST1.TCSGEGDC.COM =
  (DESCRIPTION =
& ......

Fedora10 上的 Oracle 10.2.0.1 手工建库全过程

Fedora10 上的 Oracle 10.2.0.1 手工建库全过程
NOTE:
    (1)记着要在oracle用户下而不是root下执行这些操作,否则因为权限的问题会带来无穷无尽的麻烦
    (2)要检查过程中所有出现的目录名都是对应正确且有效的,否则几乎没有可用的错误信息来查找这种错误
    (3)要 ......

Oracle + Sun: Java Strategy

Oracle and Sun
http://www.oracle.com/events/productstrategy/index.html
Oracle + Sun: Java Strategy
   http://oracle.com.edgesuite.net/ivt/4000/8104/9236/12630/lobby_external_flash_clean_480x360/default.htm 
Oracle + Sun: Java Strategy
  ......

Oracle Drop命令

--删除空的表空间,但是不包含物理文件
drop tablespace tablespace_name;
--删除非空表空间,但是不包含物理文件
drop tablespace tablespace_name including contents;
--删除空表空间,包含物理文件
drop tablespace tablespace_name including datafiles;
--删除非空表空间,包含物理文件
drop tablespace table ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号