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 ;}