"Rman Backup" database backup

Source: Internet
Author: User

Reprint please specify the address.

Backup slice file name wildcard character:
Number of copies of%c backup slices

%d The day ordinal (DD) in the month

%M in the month of the year (MM)

%F a unique name based on dbid, which is in the form of C-IIIIIIIIII-YYYYMMDD-QQ,

%d database name where IIIIIIIIII is the date of the database DBID,YYYYMMDD, QQ is a sequence of 1-256

%n database name, fill to the right up to a maximum of eight characters

%u a eight-character name represents the backup set and the creation time

%p The backup piece number in the backup set, starting from 1 to the number of files created

%u a unique file name that represents%u_%p_%c

%s The number of the backup set

%t Backup set Timestamp

%T date Format (YYYYMMDD)

Full database backup: Backs up all data files and control files with backup.

Cold backup (Consistent backup): Close database fallback all data files and control files.
Operation:

Shutdown immediate; startup Mount;backup database format= '/home/oracle_11/backup1/whole_%d_%u.bak '; Removing format will follow the formats and paths set in the channel SQL ' alter system archive log current ';//manual archive log forced log conversion is archived to archive log in backup as compressed backupset --Compress backup format '/home/oracle_11/backup1/whole_%d_%u ' filesperset=3--set the number of backup slices allowed in the backup set database;

Hot Backup (non-conforming backup): Backs up all data files and control files in the database open state.

Backup Database format= '/home/oracle_11/backup1/whole_%d_%u.bak ';//Remove format will follow the formats and paths set in the channel SQL ' ALTER system archive Log current ';//Manually archive logs

To exempt a table space:

Configure exclude for Tablespace user1;backup database format= '/home/oracle_11/backup1/whole_%d_%u.bak ';// Removing format will follow the formats and paths set in the channel SQL ' alter system archive log current ';//manually archive the log

  

"Rman Backup" database backup

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.