ITPub博客

装载地址:http://www.xifenfei.com/2619.html

---SHOW SHOW RETENTION POLICY;SHOW DEVICE TYPE;SHOW DEFAULT DEVICE TYPE;SHOW CHANNEL;SHOW MAXSETSIZE;SHOW ALL;---LISTRMAN> LIST ARCHIVELOG ALL;RMAN> LIST BACKUP OF ARCHIVELOG ALL;RMAN> L...

   Oracle 10G可以配置一些参数如通道，备份保持策略等信息，通过一次设定可以多次使用，而且，设置中的信息不影响脚本中的重新设置。RMAN 默认的配置参数，通过show all 就可以看出来。RMAN> show all;RM...

转载 http://blog.csdn.net/tianlesoftware/article/details/6307985

设置参数 DB_FILE_NAME_CONVERT          LOG_FILE_NAME_CONVERT1 主库 startup 2 备库 startup nomount3 主库rman 连接rman target / auxiliary sys/oracle@st180 listbac...

CATALOG ARCHIVELOG '?/oradata/archive1_30.dbf', '?/oradata/archive1_31.dbf',                  '?/oradata/archive1_32.dbf';CATALOG DATAFILECOPY '?/oradata/u...

1alter system set utl_file_dir='D:\archivelog' scope=spfile;2 重启数据库3BEGINdbms_logmnr_d.build(dictionary_filename=>'dict.ora',dictionary_location=>'D:\archivelog');END;4 增加要分析的文件&...

sql 'alter tablespace users offline for recover';--可选set newname for datafile 4 to '$ORACLE_BASE/product/10.2.0/oradata/oralife/user01.dbf'; restore tablespace users;recover tablespace users;sq...

FLASHBACK TABLE sys_action_info TO BEFORE DROP;select * from  sys_action_info as of timestamp to_timestamp('2009-11-12 15:10:20','yyyy-mm-dd hh24:mi:ss');FLASHBACK TABLE sys_action_info TO to_tim...

backup validate datafile 1;backup validate check logical database;--全库检测select * from v$database_block_corruption where file#=4;blockrecover datafile 4 block 35 from backupset;如需要恢复v$...

-- 1. 检查损坏的对象 SELECT tablespace_name, segment_type, owner, segment_name             FROM dba_extents            WH...

backup validate datafile 1;select * from v$database_block_corruption where file#=4;blockrecover datafile 4 block 35 from backupset;

-- 1. 检查损坏的对象 SELECT tablespace_name, segment_type, owner, segment_name             FROM dba_extents       &...