www.ctrt.net > rmAn list BACkupsEt

rmAn list BACkupsEt

1、创建rman默认表空间 SQL> create tablespace rman datafile '/oracle/oradata/test/rmandata1' size 125M autoextend on next 50M maxsize 500M; SQL> grant recovery_catalog_owner to rman identified by rman; SQL> alter user rman defau...

验证RMAN备份的有效性 1、restore preview命令 此命令用来查看还原需要使用哪个备份集来执行特定的恢复 restore database preview; 2、使用validate和check logical参数的restore命令,检查备份集,以确认数据库是可恢复的 restore database val...

backup as backupset明确将数据库以备份集的形式备份后存放,而backup database是将数据库备份成rman默认的备份配置形式,也可能是copy. list backup和list backupset不一样,是你自己没有搞清楚。

backupset 如果你不指定路径的话数据库是会备份到flash_recovery_area下的。 如: handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2011_05_23/o1_mf_nnndf_TAG20110523T010240_6xljfk3j_.bkp comment=NONE 系统默认情况你使用backu...

查看某个备份集SPFILE SELECT DISTINCT A.SET_STAMP, B.COMPLETION_TIME, HANDLE FROM V$BACKUP_SPFILE B, V$BACKUP_PIECE A WHERE A.SET_STAMP = B.SET_STAMP AND A.DELETED = 'NO' AND B.SET_STAMP = &SET_STAMP; 查看RMAN的配置信息 SELECT N...

把源库rman 备份cp 到当前数据库, 进入当前库,rman恢复 脚本 RUN { SET NEWNAME FOR DATAFILE 1 to '/backup29/ora/datafile/o1_mf_users_7nym3885_.dbf'; SET NEWNAME FOR DATAFILE 2 to '/backup29/ora/datafile/o1_mf_undotbs1_7nym3862_.d...

网站地图

All rights reserved Powered by www.ctrt.net

copyright ©right 2010-2021。
www.ctrt.net内容来自网络,如有侵犯请联系客服。zhit325@qq.com