Rman (I), rman (

Rman (I), rman (
CHANGE command to CHANGE the backup and copy status
1. change backupset 100 unavailable
 
The CATALOG command is used to add backup fragments and copies to the RMAN database.
1. Add the data file copy information to the RMAN Database
Catalog datafilecopy 'e: \ back \ p2.ora'
2. Add the archived log file information to the RMAN database.
Catalog archivelig 'C: \ temp \ p1.dbf'
3. Add the control file information to the RMAN Database
Catalog controlfilecopy 'C: \ temp \ p1.ctl'
 
The CROSSCHECK command is used for the RMAN database to check the backup and copy status on the disk.
1. Check the status of all backups.
Crosscheck backup
2. Check the status of all copies
Crosscheck copy
3. Check the status of all archived log files
Crosscheck archivelog all;
4. Check the backup status of the Control File
Crosscheck backup of controlfile;
Run the following script to back up the entire database
Run {
Allocate channel c1 type disk;
Backup
Full
Database
Format 'd: \ temp \ bk0 _ % s _ % p _ % T ';
Release channel c1;
}
 
% S specifies the backup set
% P indicates the part number.
% T specified Timestamp
 
Run the following script to back up a data file.
Run {
Allocate channel c1 type disk;
Set backup copies = 2;
Backup
Datafile 'd: \ oradata \ user01.dbf'
Format 'e: \ temp \ bkdatafile _ % U', 'e: \ temp \ bkdatafile _ % U ';
Release channel c1;
}
 
Set backup copies = 2 indicates that dual backup is to be generated
 
% U generate a unique file name
 
Run the following script to back up the tablespace.
Run {
Allocate channel c1 type disk;
Backup
Tablespace users
Format 'd: \ temp \ bk0 _ % s _ % p _ % T ';
Release channel c1;
}
 
Run the following script to back up archive log files.
Run {
Allocate channel c1 type disk;
Backup
Archivelog all
Format 'd: \ temp \ bkdatafile _ % U ';
Release channel c1;
}
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

How to Use rman commands on PLSQL Developer

You need to execute this in the command line.