Shulou(Shulou.com)06/01 Report--

1. Transfer the database full backup set and archive log backup set to the Oracle server that performs the recovery

# transfer to the transit server

Scp-P 2222 database.20181030.5* 218.17.56.50:/tmp/backupscp-P 2222 archivelog.20181029.5ltgrqir_1_1.rman 218.17.56.50:/tmp/backupscp-P 2222 archivelog.20181030.* 218.17.56.50:/tmp/backup

# transfer to Oracle server

Scp-r backup/ oracle@188.188.1.120:~/

2. Register backup set to control file

Catalog backuppiece'/ home/oracle/backup/archivelog.20181029.5ltgrqir_1_1.rman';catalog backuppiece'/ home/oracle/backup/archivelog.20181030.5stguer0_1_1.rman';catalog backuppiece'/ home/oracle/backup/archivelog.20181030.5ttguer0_1_1.rman';catalog backuppiece'/ home/oracle/backup/archivelog.20181030.5utguesp_1_1.rman';catalog backuppiece'/ home/oracle/backup/archivelog.20181030.5vtguesr_1_1.rman' Catalog backuppiece'/ home/oracle/backup/archivelog.20181030.60tgueuk_1_1.rman';catalog backuppiece'/ home/oracle/backup/database.20181030.5otgue2k_1_1.rman';catalog backuppiece'/ home/oracle/backup/database.20181030.5ptgue2k_1_1.rman';catalog backuppiece'/ home/oracle/backup/database.20181030.5qtgueid_1_1.rman'

3. Deal with incarnation (execute if necessary)

Shutdown immediate;startup mount;list incarnation;reset database to incarnation 1

4. Perform incomplete recovery

# rman script

Cat restore.rman run {shutdown immediate; startup mount; set until time = "to_date ('30-10-18 12 hh34:mi:ss')"; restore database; recover database; alter database open resetlogs;} # restore rman target / @ restore.rman

Note: if the restore reports an error, check that the backup set Status is AVAILABLE. If the backup set is valid and the data file cannot be created, the problem can be resolved by installing the system and database from.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.