Oracle rman backup tutorial, mongolerman backup

Source: Internet
Author: User

Oracle rman backup tutorial, mongolerman backup

Oracle rman backup tutorial

Rman must be in oracle archive mode to check whether the database is in archive state. Enter archive log list in the command line of the oracle database. First, close the database shutdown immediate; startup mount; (mount status is different from open) alter database archivelog; change to archive mode alter database open; start the database to execute archive log list again; now Start rman operation rman target/show all; see parameter configure controlfile autobackup on; Enable automatic backup of control files show controlfile autobackup; check whether automatic backup database is backed up; simple full-database backup list backup; view the backup information. At this time, you can return to the shell terminal to check the remaining space in the system, so as to estimate the number of Backup redundancy (that is, the number of backups can be automatically backed up several times) and then rman target/configure retention policy to redundancy 10; level 0 backup script (full database backup) rman target/<EOF_RMANrun {allocate channel c1 type disk; backup incremental level 0 tag 'db0' format'/u01/app/oracle/RmanBackup/db0 _ % d _ % T _ % s' database include current controlfile; # When I run this script, an error will be reported. If I change % T _ % s to % U, the delete noprompt obsolete; release channel c1;} level 1 backup script (Incremental Backup) will be restored) rman target/<EOF_RMANrun {allocate channel c1 type disk; backup incremental level 1 tag 'db1' format'/u01/app/oracle/RmanBackup/db0 _ % d _ % T _ % s' database include current controlfile; delete noprompt obsolete; release channel c1 ;}

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.