RMAN preview function

During RMAN backup, preview is often used to verify the recoverability of the current database, as well as the backup piece, archivelog, and whether the corresponding file exists during restoration.

-------------------------------------- Split line --------------------------------------

Recommended reading:

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

-------------------------------------- Split line --------------------------------------

Oracle 11g

RMAN> backup database;

Starting backup at 24-APR-14

..................................

RMAN> delete noprompt archivelog all;

..................

RMAN> restore database preview;

Starting restore at 24-APR-14
Using channel ORA_DISK_1

List of Backup Sets
==============================

BS Key Type LV Size Device Type Elapsed Time Completion Time
-------------------------------------------------------------
7 Full 6.76g disk 00:04:14 24-APR-14
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20140424T131155
Piece Name:/usr/test/08p6hksr_1_1
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---------------------------------
1 Full 591225164 24-APR-14/u01/app/oracle/oradata/t/system01.dbf
2 Full 591225164 24-APR-14/u01/app/oracle/oradata/t/sysaux01.dbf
3 Full 591225164 24-APR-14/u01/app/oracle/oradata/t/undotbs01.dbf
4 Full 591225164 24-APR-14/u01/app/oracle/oradata/t/users01.dbf
5 Full 591225164 24-APR-14/u01/app/oracle/oradata/t/users02.dbf

Archived logs generated after SCN 591224897 not found in repository
Media recovery start SCN is 591224897
Recovery must be done beyond SCN 591225164 to clear datafile fuzziness
Finished restore at 24-APR-14

You can see that if you need the backuppiece and archivelog required by the resotre database, but some archivelog files have been deleted manually, so they cannot be completely restored.

Restore validate database can also be used for verification, but more work will be done to read the corresponding file information, perform encryption, decryption, decompression, and so on.

RMAN> restore validate database
2>;

Starting restore at 24-APR-14
Using channel ORA_DISK_1

Channel ORA_DISK_1: starting validation of datafile backup set
Channel ORA_DISK_1: reading from backup piece/usr/test/08p6hksr_1 _

......................................

This article permanently updates the link address: