TAILIEUCHUNG - Oracle RMAN 11g Backup and Recovery- P6

Oracle RMAN 11g Backup and Recovery- P6: Oracle, yet another edition of our RMAN backup and recovery book has hit the shelves! Oracle Database 11g has proven to be quite the release to be sure. RMAN has new functionality and whizbang new features that improve an already awesome product. RMAN has certainly evolved over the years, as anyone who started working with it in Oracle version 8 can attest to. | 218 Part II Setup Principles and Practices RC_BACKUP_CONTROLFILE V BACKUP_DATAFILE This view provides information about backups you have taken of your control file. This does not include control file copies there is a different view for copies that have been made with the copy command or cataloged with the catalog command. This view is an excellent source to reference if control file restore operations are behaving strangely particularly if you are trying to duplicate for standby database creation. To review control file copies in V BACKUP_DATAFILE you would look at records with a file number of 0 this represents the control file select file creation time resetlogs time blocks block size controlfile type from v backup datafile where file 0 The following query would give you information about all the control file backups for the database V102 with the completion time the status the type of control file B for a normal backup and S for a standby control file backup and the date of the autobackup this will be null if you do not have the control file autobackup configured column completion time format a25 column autobackup date format a25 alter session set nls date format DD-MON-YYYY HH24 MI SS select db name status completion time controlfile type autobackup date from rc backup controlfile where db name V102 RC_BACKUP_CORRUPTION V BACKUP_CORRUPTION This view lists the corruption that exists in datafile backups. To tolerate corruption the value of MAXCORRUPT must be set to a non-zero value which indicates how many corrupt blocks RMAN will back up before it throws an error and aborts. The corrupt blocks are not discarded but rather are backed up as is. Do not confuse this view with RC_DATABASE_BLOCK_CORRUPTION described later in this chapter which lists blocks that are corrupt in the database based on the last backup operation or backup validate . RC_BACKUP_CORRUPTION lists blocks that are corrupt in the backup not in the database itself. The following code provides a .

TÀI LIỆU MỚI ĐĂNG
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.