ITPub博客

恢复脚本如下：恢复过程如下：此时，数据库处于mounted状态，查看控制文件中文件的路径信息如下：从以上操作中可以看出，控制文件中的信息与实际的文件路径不一致，翻看官方文档发现如下图中一段话：可以看出，恢复脚本中没有执行switch datafile all命令，导致控制文件的信息没有改...

delete archivelog from sequence 1029289 until sequence 1029290 thread 1;

You can use the VALIDATE command to manually check for physical and logical corruptions in database files. This command performs the same types of checks as BACKUP VALIDATE, but VALIDATE can check a larger selection of objects. For example, you can validate individual blocks with t...

RMAN> backup database include currentcontrolfile plus archivelog; Starting backup at 09-APR-14current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive logbackupsetchannel ORA_DISK_1: spec...

RMAN> crosscheck archivelog all; released channel: ORA_DISK_1released channel: ORA_DISK_2released channel: ORA_DISK_3allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=138 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=135 devtype=DISKal...

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPEDISK clear; old RMAN configuration parameters:CONFIGURE CHANNEL 2 DEVICE TYPE DISKFORMAT  '/u02/backup/rman/BJDB/disk2_1/BJDB_%U.bak',   '/u02/backup/rman/BJDB/disk2_2/BJDB_%U.bak';old RMAN configuration parameters ar...

 delete noprompt archivelog until time "to_date('2014-09-26 00:00:00','yyyy-mm-dd hh24:mi:ss')-7" backed up 1 times to device type disk;