Rman
shenghuiping2001
提供Splunk 安装升级技术支持,Splunk 字段截取,dashboard 报表制作。Splunk 接入各种网络设备和Add-on APP.(毕业于南京航空航天大学,在IBM工作过10年,现在专注splunk架构和数据分析。拥有Oracle: OCP认证, AWS: ASP认证, Azure: admin系统管理员认证。)
展开
-
rman 对数据文件 的恢复test
一下是关于rman 的备份,恢复的测试:database 是mount 状态,其他用户连不了:SQL> select status from v$instance;STATUS------------MOUNTEDSQL> conn scott/oracl原创 2011-10-16 20:27:36 · 503 阅读 · 1 评论 -
ora-00257 默认的 db_recovery_dest 满 用户不能登入 (解决)
This afternoon, customer had faced one problem:The user can not not connect to database,ora-00257 error log occur:Caustion: The achivelog is full 1: Even we delete the archivelog from原创 2012-02-15 18:42:00 · 1529 阅读 · 0 评论 -
为啥 RMAN 不备份redo log?
Please describe why the redo log is not needed to backup in the RMAN backup?Condition: The database must be mounted or open: Online redo log backups are not supported: There are two typ原创 2012-03-17 13:43:45 · 1413 阅读 · 1 评论 -
rman 维护 - ( crosscheck + retention + keep + catalog)
This time ,I will introduce the Rman maintenance:After completing this lession, you should be able to do the following: 1: Perform Cross-checking of backups and copies. 2: Update the repositor原创 2012-02-05 19:20:45 · 659 阅读 · 0 评论 -
maxpiecesize 来限制rman中 piece 的大小
RMAN> run {2> allocate channel t1 type disk3> maxpiecesize = 50M;4> backup as compressed backupset format 'df_%t_%s_%p' database;5> }分配的通道: t1通道 t1: sid=154 devtype=DISK启动 backup 于 17-3月原创 2012-03-17 19:04:20 · 3022 阅读 · 1 评论