大橙子网站建设,新征程启航
为企业提供网站建设、域名注册、服务器等服务
1.list 显示命令 RMAN> list backup; --显示备份 # lists backup sets, p_w_picpath copies, and proxy copies RMAN> list backupset; --显示备份集 # lists only backup sets and proxy copies RMAN> list copy; --显示(镜像拷贝的备份) # lists only disk copies RMAN> list backupset of tablespace newtbs; ----------------------------------------------------------------------------------------------------------------- RMAN> show device type; --查看rman配置信息 RMAN configuration parameters for database with db_unique_name PROD are: CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> configure device type disk parallelism 1 backup type to copy; --修改默认属性 ----------------------------------------------------------------------------------------------------------------- 2.report 报告命令 RMAN> report schema; --显示可备份的目标; 策略, RMAN> report obsolete; --显示那些不再需要的备份文件; 3.delete 删除命令 RMAN> delete obsolete; 4.backup RMAN> backup tablespace newtbs; RMAN> backup datafile 10; RMAN> backup database; 5.resotre 备份还原 RMAN> restore tablespace newtbs; --将数据文件 cp 到原来的地方并覆盖源文件 6.recover 修复 RMAN> recover tablespace newtbs; --跑日志,修复scn