viernes, 31 de mayo de 2019

restore database validate

RMAN> restore database validate;

Starting restore at 31-MAY-19
using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece +FRA/ACME/BACKUPSET/2019_05_31/nnndf0_tag20190531t200530_0.260.1009742731
channel ORA_DISK_1: piece handle=+FRA/ACME/BACKUPSET/2019_05_31/nnndf0_tag20190531t200530_0.260.1009742731 tag=TAG20190531T200530
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:17
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece +FRA/ACME/BACKUPSET/2019_05_31/nnndf0_tag20190531t204246_0.264.1009744967
channel ORA_DISK_1: piece handle=+FRA/ACME/BACKUPSET/2019_05_31/nnndf0_tag20190531t204246_0.264.1009744967 tag=TAG20190531T204246
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece +FRA/ACME/BACKUPSET/2019_05_31/nnndf0_tag20190531t204820_0.266.1009745301
channel ORA_DISK_1: piece handle=+FRA/ACME/BACKUPSET/2019_05_31/nnndf0_tag20190531t204820_0.266.1009745301 tag=TAG20190531T204820
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece +FRA/ACME/BACKUPSET/2019_05_31/nnndf0_tag20190531t205058_0.267.1009745459
channel ORA_DISK_1: piece handle=+FRA/ACME/BACKUPSET/2019_05_31/nnndf0_tag20190531t205058_0.267.1009745459 tag=TAG20190531T205058
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:07
Finished restore at 31-MAY-19

RMAN>

RMAN> restore archivelog from time 'sysdate-1' validate;

No hay comentarios: