Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to solve the problem that catalog start with can not register some backup files in rman". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The / oracle directory is a separately mounted partition and cannot be accessed after corruption. Some rman backups exist and are ready to be restored with backups.

1. / oracle partition problem the related personnel said that the hard disk was damaged and a disk had been replaced. In my impression, raid5 automatically recovers data, and file system access will not be affected. But at present, the partition cannot be mounted, and there is also a problem in parted.

2. Reformat the sdb1 partition, mount it to / oracle, and install Oracle software.

3. Check rman backups. The number of level 0 backups is 96 on November 11th, and the number of level 1 backups on the 12th is also 96, which is consistent with the number of data files. It is basically judged that the backup is successful. This is followed by a level 1 backup or archive backup with a partial date. The backup strategy is to be able to restore to the previous day, and the backup or archive has not been manually deleted, basically confirming that the logs required for recovery are complete.

4. Restore spfile, control files, and start to mount

Restore spfile from 'xxx'

Restore controlfile from 'xxx'

Alter database mount

Catalog start with 'xxxx'

5. Recover the missing files in the restore / oracle partition

Run {

Restore datafile 1,2,4

Recover datafile 1,2,4

Alter database open

}

Questions in the log:

1. Datafile 2 is generated by create statements (not noticed here at the time, because list backup of datafile 2 can see level 0 backups before restore)

2. Because controlfile is also backed up, the final error is reported, and you must use the recover database statement

6. Restore the control file again, and then make a list backup of dataifle 2 invisible level 0 backup. Using catalog start with, it was found that the level 0 backup of datafile 2 was not properly recognized.

7. Use catalog backuppiece 'xxx' to register the backup file successfully. Restore was successful. Later found a file io error to restore the same situation, find a level 0 backup and manually register, and then restore successfully.

8. Resetlogs opens the library

Recover database

Alter database open resetlogs

"how to solve the problem of catalog start with unable to register some backup files in rman" is introduced here. Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.