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 .

• Cơ sở dữ liệu
• thủ thuật Mysql
• quản trị cơ sở dữ liệu
• Mysql căn bản
• tài liệu căn bản Oracle
• hệ thống cơ sở dữ liệu
• từ Java vào MySQL
• thủ thuật máy tính
• mẹo vặt máy tính
• tin học căn bản
• thủ thuật tin học
• tự học tin học
• thủ thuật lập trình
• ứng dụng quản lý trên web
• kỹ thuật lập trình ứng dụng
• lập trình mã nguồn mở
• cơ sở dữ liệu MYSQL
• kết nối cơ sở dữ liệu
• Cơ sở dữ liệu
• An ninh – Bảo mật
• Công nghệ thông tin
• Quản trị mạng
• lập trình dữ liệu
• database
• MySQL
• quản trị dữ liệu
• lập trình web
• dữ liệu MySQL
• câu lệnh SQL
• mẹo lập trình
• ngôn ngữ lập trình
• kỹ năng máy tính
• hệ thống dữ liệu
• tài liệu về SQL
• tài liệu về PROFILING