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