-
编辑 删除
RMAN系列-基于scn恢复
RMAN> list backup;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ---...
-
编辑 删除
RMAN系列-基于sequence 恢复
run{startup mount;restore database until sequence 4 thread 1'；recover database until sequence 4 thread 1'；alter database open resetlogs;}
-
编辑 删除
RMAN系列-基于时间点的恢复
run{set until time "to_date('07/01/02 15:00:00','mm/dd/yy hh24:mi:ss')";restore database;recover database;alter database open resetlogs;}
-
编辑 删除
RMAN系列-catalog数据库
oracle@server ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 16 14:22:35 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g E...
-
编辑 删除
oracle基于时间点恢复
Oracle基于时间点的恢复能够精确到什么样的精度?这是一个需要关心的问题。以下测试用于进行一点说明。1.首先做好冷备份2.创建测试数据D:\>sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.6.0 - Production o...
