-
编辑 删除
RMAN
In incomplete recovery, also known as point-in-time recovery, thegoal is to restore the database to its state at some previous target SCN or time.Point-in-time recovery is one possible response to a data loss caused by, for instance, a user error or logical corruption that goes unnoticed for some time.Point-in-time recovery is also your only option if you have to perform a recovery and discover that you are missing an archived log。Your only choice is to recover the database from the point in ti
-
编辑 删除
闪回查询
Automatic Undo Management[@more@]闪回查询（Flashback Query）功能对于误删除或者误更新并且已经commit 了的情况，提供了简便快捷的恢复方法:前提条件数据库必须处于 Automatic Undo Management 状态。SQL> show parameter undo_management最大可以闪回查询的时间段由 UNDO_RETENTION 初始化参数（单位为秒）指定SQL> show parameter undo_retention可以通过 ALTER SYSTEM SET UNDO_RETENTION = <seconds>;来修改参数值使用AS OF 关键字来对表，视图，或者物化视图进行Flashback Query，如果指定了SCN，那么expr 部分必须是
-
编辑 删除
Control Files
When to Create New Control FilesIt is necessary for you to create new control files in the following situations:All control files for the database have been permanently damaged and you do not have a control file backup.You want to change the database name.For example, you would change a database name if it conflicted with another database name in a distributed environment.[@more@]The CREATE CONTROLFILE StatementYou can create a new control file for a database using the CREATE CONTROLFILE stateme
-
编辑 删除
terminate Session
SELECT SID,SERIAL#,STATUS,SERVER FROM V$SESSION WHERE USERNAME = 'JWARD'; ALTER SYSTEM KILL SESSION 'SID ,SERIAL#';[@more@]
-
编辑 删除
ORACLE数据库初始化参数
SGA ,PROCESS [@more@]SGA:If you decide not to use automatic shared memory management by not setting the SGA_TARGET parameter, you must manually configure each component of the sga.PROCESS :The PROCESSES initialization parameter determines the maximum number of operating system processes that can be connected to Oracle Database concurrently. The value of this parameter must be a minimum of one for each background process plus one for each user process.
