RMAN BACKUP AND RECOVER TEST

最新推荐文章于 2024-02-07 22:09:49 发布
最新推荐文章于 2024-02-07 22:09:49 发布
阅读量583 收藏
点赞数
文章标签： disk database validation archive system delete
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zhangtian0913/article/details/3850367
版权

RMAN> run {
2>    allocate channel dev1 type disk;
3>    allocate channel dev2 type disk;
4>    crosscheck archivelog all;
5>    delete expired archivelog all;
6>    backup incremental level=2  database
7>            format 'D:/backup/full_%d_%T_%s'
8>            tag 'database_incr2';
9>    release channel dev1;
10>    release channel dev2;
11>  }

allocated channel: dev1
channel dev1: sid=142 devtype=DISK

allocated channel: dev2
channel dev2: sid=138 devtype=DISK

validation succeeded for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_21/O1_MF_1_3_4QFOWPOM_.ARC recid=44 stamp=676742807
validation succeeded for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_1_4QHGV1OZ_.ARC recid=45 stamp=676801126
validation succeeded for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_2_4QHKLXM1_.ARC recid=46 stamp=676803935
validation succeeded for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_3_4QHPHY7Z_.ARC recid=47 stamp=676808962
validation succeeded for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_4_4QHR09CW_.ARC recid=48 stamp=676810509
Crosschecked 5 objects


specification does not match any archive log in the recovery catalog

Starting backup at 22-JAN-09
channel dev1: starting incremental level 2 datafile backupset
channel dev1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_M
F_SYSTEM_4MZ4R7MM_.DBF
input datafile fno=00006 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/RMAN
.DBF
input datafile fno=00002 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_M
F_UNDOTBS1_4MZ4R7SY_.DBF
channel dev1: starting piece 1 at 22-JAN-09
channel dev2: starting incremental level 2 datafile backupset
channel dev2: specifying datafile(s) in backupset
input datafile fno=00004 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_M
F_USERS_4MZ4R7TG_.DBF
input datafile fno=00003 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_M
F_SYSAUX_4MZ4R7O2_.DBF
input datafile fno=00005 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/ZPS.
DBF
channel dev2: starting piece 1 at 22-JAN-09
channel dev1: finished piece 1 at 22-JAN-09
piece handle=D:/BACKUP/FULL_ZPS_20090122_37 tag=DATABASE_INCR2 comment=NONE
channel dev1: backup set complete, elapsed time: 00:00:30
channel dev2: finished piece 1 at 22-JAN-09
piece handle=D:/BACKUP/FULL_ZPS_20090122_38 tag=DATABASE_INCR2 comment=NONE
channel dev2: backup set complete, elapsed time: 00:00:44
Finished backup at 22-JAN-09

Starting Control File Autobackup at 22-JAN-09
piece handle=D:/BACKUP/22_FULL_01_22_C-304402041-20090122-02 comment=NONE
Finished Control File Autobackup at 22-JAN-09

released channel: dev1

released channel: dev2
RMAN> shutdown immediate;

database closed
database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     612368384 bytes

Fixed Size                     1250428 bytes
Variable Size                163580804 bytes
Database Buffers             440401920 bytes
Redo Buffers                   7135232 bytes

RMAN> restore database;

Starting restore at 22-JAN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_MF_
SYSAUX_4MZ4R7O2_.DBF
restoring datafile 00004 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_MF_
USERS_4MZ4R7TG_.DBF
restoring datafile 00006 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/RMAN.D
BF
channel ORA_DISK_1: reading from backup piece D:/BACKUP/FULL_ZPS_20090122_32
channel ORA_DISK_1: restored backup piece 1
piece handle=D:/BACKUP/FULL_ZPS_20090122_32 tag=DATABASE_FULL
channel ORA_DISK_1: restore complete, elapsed time: 00:00:37
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_MF_
SYSTEM_4MZ4R7MM_.DBF
restoring datafile 00002 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_MF_
UNDOTBS1_4MZ4R7SY_.DBF
restoring datafile 00005 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/ZPS.DB
F
channel ORA_DISK_1: reading from backup piece D:/BACKUP/FULL_ZPS_20090122_31
channel ORA_DISK_1: restored backup piece 1
piece handle=D:/BACKUP/FULL_ZPS_20090122_31 tag=DATABASE_FULL
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 22-JAN-09

RMAN> recover database;

Starting recover at 22-JAN-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_SYSTEM_4QHTQP8Z_.DBF
destination for restore of datafile 00005: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/ZPS.DBF
destination for restore of datafile 00006: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/RMAN.DBF
channel ORA_DISK_1: reading from backup piece D:/BACKUP/FULL_ZPS_20090122_34
channel ORA_DISK_1: restored backup piece 1
piece handle=D:/BACKUP/FULL_ZPS_20090122_34 tag=DATABASE_INCR1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_UNDOTBS1_4MZ4R7SY_.DBF
destination for restore of datafile 00003: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_SYSAUX_4MZ4R7O2_.DBF
destination for restore of datafile 00004: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_USERS_4QHTPLN6_.DBF
channel ORA_DISK_1: reading from backup piece D:/BACKUP/FULL_ZPS_20090122_35
channel ORA_DISK_1: restored backup piece 1
piece handle=D:/BACKUP/FULL_ZPS_20090122_35 tag=DATABASE_INCR1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_SYSTEM_4QHTQP8Z_.DBF
destination for restore of datafile 00002: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_UNDOTBS1_4MZ4R7SY_.DBF
destination for restore of datafile 00006: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/RMAN.DBF
channel ORA_DISK_1: reading from backup piece D:/BACKUP/FULL_ZPS_20090122_37
channel ORA_DISK_1: restored backup piece 1
piece handle=D:/BACKUP/FULL_ZPS_20090122_37 tag=DATABASE_INCR2
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_SYSAUX_4MZ4R7O2_.DBF
destination for restore of datafile 00004: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_USERS_4QHTPLN6_.DBF
destination for restore of datafile 00005: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/ZPS.DBF
channel ORA_DISK_1: reading from backup piece D:/BACKUP/FULL_ZPS_20090122_38
channel ORA_DISK_1: restored backup piece 1
piece handle=D:/BACKUP/FULL_ZPS_20090122_38 tag=DATABASE_INCR2
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15

starting media recovery
media recovery complete, elapsed time: 00:00:05

Finished recover at 22-JAN-09

 

RMAN> alter database open;

database opened

RMAN> shutdown immediate;

database closed
database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     612368384 bytes

Fixed Size                     1250428 bytes
Variable Size                163580804 bytes
Database Buffers             440401920 bytes
Redo Buffers                   7135232 bytes

RMAN> restore database;

Starting restore at 22-JAN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_MF_
SYSAUX_4MZ4R7O2_.DBF
restoring datafile 00004 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_MF_
USERS_4QHTPLN6_.DBF
restoring datafile 00006 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/RMAN.D
BF
channel ORA_DISK_1: reading from backup piece D:/BACKUP/FULL_ZPS_20090122_32
channel ORA_DISK_1: restored backup piece 1
piece handle=D:/BACKUP/FULL_ZPS_20090122_32 tag=DATABASE_FULL
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_MF_
SYSTEM_4QHTQP8Z_.DBF
restoring datafile 00002 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_MF_
UNDOTBS1_4MZ4R7SY_.DBF
restoring datafile 00005 to E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/ZPS.DB
F
channel ORA_DISK_1: reading from backup piece D:/BACKUP/FULL_ZPS_20090122_31
channel ORA_DISK_1: restored backup piece 1
piece handle=D:/BACKUP/FULL_ZPS_20090122_31 tag=DATABASE_FULL
channel ORA_DISK_1: restore complete, elapsed time: 00:00:36
Finished restore at 22-JAN-09

RMAN> recover database until  time "to_date('20090122 11:20:00','yyyymmdd hh24:m
i:ss')";

Starting recover at 22-JAN-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_SYSTEM_4QHTQP8Z_.DBF
destination for restore of datafile 00005: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/ZPS.DBF
destination for restore of datafile 00006: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/RMAN.DBF
channel ORA_DISK_1: reading from backup piece D:/BACKUP/FULL_ZPS_20090122_34
channel ORA_DISK_1: restored backup piece 1
piece handle=D:/BACKUP/FULL_ZPS_20090122_34 tag=DATABASE_INCR1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_UNDOTBS1_4MZ4R7SY_.DBF
destination for restore of datafile 00003: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_SYSAUX_4MZ4R7O2_.DBF
destination for restore of datafile 00004: E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/
DATAFILE/O1_MF_USERS_4QHTPLN6_.DBF
channel ORA_DISK_1: reading from backup piece D:/BACKUP/FULL_ZPS_20090122_35
channel ORA_DISK_1: restored backup piece 1
piece handle=D:/BACKUP/FULL_ZPS_20090122_35 tag=DATABASE_INCR1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15

starting media recovery
media recovery complete, elapsed time: 00:00:26

Finished recover at 22-JAN-09

 

RMAN> alter database open resetlogs;

database opened

RMAN> run {
2>    allocate channel dev1 type disk;
3>    allocate channel dev2 type disk;
4>    crosscheck archivelog all;
5>    delete expired archivelog all;
6>    backup incremental level=0  database
7>            format 'D:/backup/full_%d_%T_%s'
8>            tag 'database_full';
9>    release channel dev1;
10>    release channel dev2;
11>  }

released channel: ORA_DISK_1
allocated channel: dev1
channel dev1: sid=156 devtype=DISK

allocated channel: dev2
channel dev2: sid=144 devtype=DISK

validation succeeded for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_5_4QJ7KS1N_.ARC recid=49 stamp=676826427
Crosschecked 1 objects

validation failed for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_21/O1_MF_1_3_4QFOWPOM_.ARC recid=44 stamp=676742807
validation failed for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_1_4QHGV1OZ_.ARC recid=45 stamp=676801126
validation failed for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_2_4QHKLXM1_.ARC recid=46 stamp=676803935
validation failed for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_3_4QHPHY7Z_.ARC recid=47 stamp=676808962
validation failed for archived log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_4_4QHR09CW_.ARC recid=48 stamp=676810509
Crosschecked 5 objects

 

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
44      1    3       X 21-JAN-09 E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZP
S/ARCHIVELOG/2009_01_21/O1_MF_1_3_4QFOWPOM_.ARC
45      1    1       X 21-JAN-09 E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZP
S/ARCHIVELOG/2009_01_22/O1_MF_1_1_4QHGV1OZ_.ARC
46      1    2       X 22-JAN-09 E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZP
S/ARCHIVELOG/2009_01_22/O1_MF_1_2_4QHKLXM1_.ARC
47      1    3       X 22-JAN-09 E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZP
S/ARCHIVELOG/2009_01_22/O1_MF_1_3_4QHPHY7Z_.ARC
48      1    4       X 22-JAN-09 E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZP
S/ARCHIVELOG/2009_01_22/O1_MF_1_4_4QHR09CW_.ARC

Do you really want to delete the above objects (enter YES or NO)? y
deleted archive log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_21/O1_MF_1_3_4QFOWPOM_.ARC recid=44 stamp=676742807
deleted archive log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_1_4QHGV1OZ_.ARC recid=45 stamp=676801126
deleted archive log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_2_4QHKLXM1_.ARC recid=46 stamp=676803935
deleted archive log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_3_4QHPHY7Z_.ARC recid=47 stamp=676808962
deleted archive log
archive log filename=E:/ORACLE/PRODUCT/10.2.0/FLASH_RECOVERY_AREA/ZPS/ARCHIVELOG
/2009_01_22/O1_MF_1_4_4QHR09CW_.ARC recid=48 stamp=676810509
Deleted 5 EXPIRED objects


Starting backup at 22-JAN-09
channel dev1: starting incremental level 0 datafile backupset
channel dev1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_M
F_SYSTEM_4QHTQP8Z_.DBF
input datafile fno=00006 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/RMAN
.DBF
input datafile fno=00002 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_M
F_UNDOTBS1_4MZ4R7SY_.DBF
channel dev1: starting piece 1 at 22-JAN-09
channel dev2: starting incremental level 0 datafile backupset
channel dev2: specifying datafile(s) in backupset
input datafile fno=00004 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_M
F_USERS_4QHTPLN6_.DBF
input datafile fno=00003 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/O1_M
F_SYSAUX_4MZ4R7O2_.DBF
input datafile fno=00005 name=E:/ORACLE/PRODUCT/10.2.0/ORADATA/ZPS/DATAFILE/ZPS.
DBF
channel dev2: starting piece 1 at 22-JAN-09
channel dev1: finished piece 1 at 22-JAN-09
piece handle=D:/BACKUP/FULL_ZPS_20090122_41 tag=DATABASE_FULL comment=NONE
channel dev1: backup set complete, elapsed time: 00:03:00
channel dev2: finished piece 1 at 22-JAN-09
piece handle=D:/BACKUP/FULL_ZPS_20090122_42 tag=DATABASE_FULL comment=NONE
channel dev2: backup set complete, elapsed time: 00:03:00
Finished backup at 22-JAN-09

Starting Control File Autobackup at 22-JAN-09
piece handle=D:/BACKUP/22_FULL_01_22_C-304402041-20090122-04 comment=NONE
Finished Control File Autobackup at 22-JAN-09

released channel: dev1

released channel: dev2

RMAN>

 

 

zhangtian0913
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle 12c Rman Backup and Recovery
11-09
详细的介绍了oracle 12c中的Oracle 12c Rman Backup and Recovery
Oracle RMAN 11g Backup and Recovery
05-21
18 Performance Tuning RMAN Backup and Recovery Operations . . . . . . . . . . . . . . 445 PART IV RMAN in the Oracle Ecosystem 19 Duplication: Cloning the Target Database . . . . . . . . . . . . . . ....
关于RMAN recover 过程的讨论
tianshibaijia
09-30 107
群里苏州-孤星问了一个问题： 先用RMAN backup database，然后做一些操作，在用backup archvivelog all delete input备份归档日志并删除备份过的归档日志。那么RMAN在进行recover的时候，怎么应用备份的归档文件。 我的回答： 在进行recover的时候，会先将备份的归档文件还原到归档目录，然后从这个目录应用归档文件，完成恢复的过程。我们看...
RMAN Backup and Recover
crhwkrhpunow61910的博客
09-21 57
Oracle RMAN Backup and Recover test after creating database , the catalog.sql , catproc.sql must be executed in sq...
oracle backup and restore,oracle11gr1 RMAN bakcup and restore
weixin_29589469的博客
04-03 75
rman target /RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;backupscript.:run{Crosscheck backup;Crosscheck archivelog all;delete NOPROMPT expired backup;delete NOPROMPT OBSOLETE;allocate channel c1 type ...
oracle recover 详解,Oracle 12c 新特性：RMAN Recover Table 详解
weixin_42393829的博客
04-04 640
1.Recover Table 和 Table Partitions概述RMAN的表级和表分区级恢复可以使用在如下场景：1. 恢复小表时。也可以使用TSPITR 的方法，但该方法效率很低,因为需要移动表空间中的所有对象。2. 恢复有逻辑损坏或者被删除的表。3. Flashback Table 不可用，比如undo 数据已经被覆盖。4. DDL 操作后需要恢复数据。Flashback Table 不...
rman backup
zxx2403的专栏
11-21 747
 Oracle RMAN 的 show,list,crosscheck,delete命令整理 1、SHOW命令：      显示rman配置： RMAN> show all; 2、REPORT命令： 2.1、RMAN> report schema 报告目标数据库的物理结构; 2.2、RMAN>report need backup days=3; 报告最近3天没有被备份的数据文件；
oracle rac rman backup,recover(archive log-share storage)
爱肯的专栏
08-15 1065
oracle rac rman backup,recover(archive log-share storage)
Hot backup and Rman backup
crh198108021的博客
01-13 98
Some friends asked if the hot backup and rman backup can exist at the same system at same time .I ...
Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore
weiwang的专栏
06-24 878
Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore  In this Document Goal Solution References APPLIES TO:   Oracle Database - Enterprise Edition - Version 9.
oracle rman 全量备份,rman全量备份+archivelog 数据迁移
weixin_39868959的博客
04-15 529
旧数据库1、全备vi /tmp/rman.sqlrun {Allocate channel rman_1 type disk;Allocate channel rman_2 type disk;backup as compressed backupset database format '/backup/full_%d_%T_%s_%p';--备份数据文件全备sql 'alter system ...
rman backup and restore
10-30
3. Oracle Secure Backup (OSB) 或其他第三方备份软件：集成更高级的备份管理功能。 七、RMAN验证与删除 1. 验证备份：检查备份的完整性和一致性，确保可恢复性。 2. 删除策略：设置保留策略，自动删除过期或不再...
MetaLink-RMAN RAC Backup and Recovery using RMAN
03-17
MetaLink-RMAN RAC Backup and Recovery using RMAN 希望对ORACLE使用者有点作用
常用的文件系统、存储类型小整理
Hehuyi_In的博客
02-07 3317
最近接触到了五花八门的文件系统、存储类型，名词听得头大，趁假期整理学习一番~
xxxxdfgfdgfdgd
07-14
xxxxdfgfdgfdgd
SQL语句基础教程.pdf
最新发布
07-14
SQL语句基础教程.pdf
站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用
07-14
站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断路器保护灵敏度校验整改及剩余电流监测试点应用站用交流系统断
rman 基于scn recover
05-23
RMAN是Oracle数据库自带的备份与恢复工具，它可以在备份数据时生成备份集，并且在需要恢复数据时可以使用备份集来还原数据。而基于SCN的恢复则是一种针对Oracle数据库的恢复方法，它可以根据SCN（System Change ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值