Rman and rman backup

Source: Internet
Author: User

Rman and rman backup

Rman target/nocatalog

The list command is used to LIST the backup information of data.
1. List backup sets of data files
List backupset of datafile 'data file name'
2. List the tablespace backup information
List backup of tablespace 'table space name'
3. List the backup information of the entire database
List backup of database
4. List the backup set information of all archived log files in the database
List backupset of archivelog all
5. list all copies
List copy
6. List the archive log files generated by the database
List archivelog all
7. List backup set statistics
List backup of database summary
 
The REPORT command is used to generate an analysis REPORT.
1. display all current data files of the target database
Report schema
2. Whether report file 13 can be recovered
Report unrecoverable datafile 13
3. List the databases with at least two incremental backups that require a full backup
Report need backup incremental 2 database
4. List tablespaces that have not been backed up for five days
Report need backup days 5 tablespace tablespace_name
5. Report outdated documents
Report obsolete
The DELETE command is used to DELETE the backup files and their records in the control files and recovery directories.
1. Delete expired backups
Delete expired backup
2. Delete expired copies
Delete expired copy
3. Delete expired backup control files
Delete expired backup of controlfile
4. Delete expired backup fragments
Delete expired backuppiece 11
5. Delete expired backup Sets
Delete expired backupset 8


What is oracle's rman?

Recovery Manager (RMAN) is a type)
The Oracle tool of the database. RMAN can only be used in ORACLE8 or later versions. It can back up the entire data
Database or database components, such as tablespaces, data files, control files, archive files, and Spfile parameter files. RMAN
You can also perform incremental data block-level backup. incremental RMAN backup is effective in time and space because they only backup
Copies of the data blocks that have changed since the last backup. Third-party backup and recovery through the interfaces provided by RMAN
Complex software such as veritas will provide more powerful backup and recovery management functions.
RMAN also provides other functions, such as database cloning, using RMAN to create a backup database,
Using RMAN backups and files on mobile bare devices (RAW) makes it easier. 9i RMAN passed
Enhanced automatic configuration and management functions and unique block-level recovery make backup and recovery work faster.
And perfection. 9i RMAN has the following features:
· Automatic backup and recovery
· Convenient backup and archiving logs
· Automatic Detection of new data files
· Support Incremental Backup
· Minimize backup and recovery errors
· Reduce recovery time
· No additional redo logs are generated during hot backup.
· Automatic Detection of rotten data blocks
· Parallel backup and recovery operations
· During online backup, The tablespace is not in the backup mode.
We can see that some of the above features show the powerful features and benefits of RMAN, the implementation of the above features,
Because RMAN is block-level backup and recovery, backup and recovery occur at the database block level, you can compare the data
To obtain consistent data blocks, you can avoid blocks that have not been used in backup, and check whether blocks are rotten or not.

This is too long. For details, refer to the post on this BLOG. For more details, see blog.sina.com.cn/s/blog_4cbd76e50100097z.html.
Reference: blog.sina.com.cn/s/blog_4cbd76e50100097z.html

What is oracle's rman?

Recovery Manager (RMAN) is a type)
The Oracle tool of the database. RMAN can only be used in ORACLE8 or later versions. It can back up the entire data
Database or database components, such as tablespaces, data files, control files, archive files, and Spfile parameter files. RMAN
You can also perform incremental data block-level backup. incremental RMAN backup is effective in time and space because they only backup
Copies of the data blocks that have changed since the last backup. Third-party backup and recovery through the interfaces provided by RMAN
Complex software such as veritas will provide more powerful backup and recovery management functions.
RMAN also provides other functions, such as database cloning, using RMAN to create a backup database,
Using RMAN backups and files on mobile bare devices (RAW) makes it easier. 9i RMAN passed
Enhanced automatic configuration and management functions and unique block-level recovery make backup and recovery work faster.
And perfection. 9i RMAN has the following features:
· Automatic backup and recovery
· Convenient backup and archiving logs
· Automatic Detection of new data files
· Support Incremental Backup
· Minimize backup and recovery errors
· Reduce recovery time
· No additional redo logs are generated during hot backup.
· Automatic Detection of rotten data blocks
· Parallel backup and recovery operations
· During online backup, The tablespace is not in the backup mode.
We can see that some of the above features show the powerful features and benefits of RMAN, the implementation of the above features,
Because RMAN is block-level backup and recovery, backup and recovery occur at the database block level, you can compare the data
To obtain consistent data blocks, you can avoid blocks that have not been used in backup, and check whether blocks are rotten or not.

This is too long. For details, refer to the post on this BLOG. For more details, see blog.sina.com.cn/s/blog_4cbd76e50100097z.html.
Reference: blog.sina.com.cn/s/blog_4cbd76e50100097z.html

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.