ITPub博客

--恢复整个数据库run {shutdown immediate;startup mount;restore database;recover database;alter database open;}--恢复表空间usersrun {sql 'alter tablespace data offline';restore tablespace users;recover tablespace users;sql 'alter tablespace data online';}--恢复数据文件适用所...

--incarnationstartup mount;reset database to incarnation 3;list archivelog;  (或list archivelog scn between 2044843 and 2045989)recover database until sequence 8;alter database open resetlogs;

run{  allocate channel d1 type disk;  backup database format='/u01/backup/%T_%d_%s.bak';  sql 'alter system archive log current';  backup archivelog all format='/u01/backup/%T_%d_%s.log';  backup current controlfile format='/u01/backup/%T_%d_%s.ctl';  release ch...

1、shell脚本1）vi rman_backup.cmd#rman_backup.cmdconnect target /run{  allocate channel d1 device type disk;  backup database format='/u01/backup/%T_%d_%s.bak' plus archivelog;  sql 'alter system archive log current';  backup current controlfile format='/u01/backup/%T...

--登录rman  rman target /  rman target sys/passwork  rman target sys/passwork nocatalog   (控制文件方式)  rman target sys/passwork catalog     (恢复目录方式)--查看参数  show all--修改保存天数  用sqlplus修改备份信息在控制...

--列出备份信息list backup of database;list backup of archivelog all;list backup of controlfile;list backup of spfile;--检查删除失效的备份crosscheck backup;delete expired backup;--报告删除过期的备份report obsolete;           &...

--查看rman配置的参数：RMAN>show all;可以显示出RMAN配置参数为:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP OFF; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FOR...