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

In a DG environment, manual synchronization is temporarily used because of insufficient network bandwidth, that is, every day, archived log files are copied from the main database to the standby database for application, but today it is found that several archived log files are missing, and the archived log files in the main database have been deleted automatically. Finally, fortunately, I found that the backup files were saved on a server for 15 days. I really like it. I suddenly remembered that Boss Gai had said, "backup is more important than anything else."

So I first used the catalog start with command to load the archive log file set, although the load was successful, but the library could not use its contents for data recovery. After searching the Internet, I found that Oracle also had a restore archivelog command to recover the archive log. I was surprised and lamented that Oracle was really a mature commercial software, and everything the customer wanted could be satisfied. finally, all my problems were solved. Here is a simple record of the usage of this command, which comes from the network.

Recover all archive log files

RMAN > restore archivelog all

Restore only the four archive log files from 5 to 8

RMAN > restore archivelog from logseq 5 until logseq 8

Recovery starts from the fifth archive log

RMAN > restore archivelog from logseq 5

Restore archived logs within 7 days

RMAN > restore archivelog from time 'sysdate-7'

Sequence between writing method

RMAN > restore archivelog sequence between 1 and 3

Which log file to restore to?

RMAN > restore archivelog low logseq 5

To the fifth log.

RMAN > restore archivelog high logseq 5

If you want to change and restore to another path, you can use the following statement

RMAN > run {

Set archivelog destination to'd:\ backup'

Allocate channel ci type disk; set archivelog destination to'd:\ backup'; restore archivelog all; release channel ci;}

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.