rman backup script for linux

Environment:CentOS 6.5 X64Oracle 11g Enterprise Edition Release 11.2.0.2.0Failure phenomena:Rman Automatic backup script failed, error phenomenon:Starting backup at 30-jul-15Current log ArchivedReleased Channel:disk1Released Channel:disk2Released Channel:disk3Released Channel:disk4RMAN-00571: ===========================================================

Rman backup method-Incremental backup and rman backup method incremental Usage type: the system load is concentrated in a certain period of time, such as 8 hours during the day, and is usually idle at night. Therefore, data can be backed up at night. It corresponds to full-D

A Some advantages of RMAN backup 1. RMAN detects and reports corrupted blocks of data. 2. RMAN can connect to the backup database without having to put the table space into hot backup mode. Additional build redo logs are generat

How to handle archived log files and RMAN log files when using rman backupI went to a customer yesterday to deploy RMAN backup. when I ran the shell script, I was prompted that I could not find the archive log, because the customer only performed EXPDP logical export

: Specific data file number: select file_name, file_id, tablespace_name from dba_data_files ;) Control File: RMAN> backup current controlfile; Or RMAN> backup database include current controlfile; Log File: RMAN> backup archivelog

file: Rman>backup spfile;9. RestoreA. Full recoveryMethod One: Restore the entire database from the most recent backup set, and the database will automatically run the Redo and archive logs (Full recovery):Sql>shutdown ImmediateSql>startup MountRman>restore database;Rman>recover database;

(except data files for the tablespace), control files, and online redo log files of auxiliary instances. If the tablespace is successfully transferred, these files will be deleted.Note: Setting the secondary directory is optional. However, if the secondary directory is not set, you must ensure that all the secondary instance files, including all data files, are, the auxiliary instance parameters are used to specify the storage directory for online redo log files. Oracle recommends that you use

global_inc1 Rman-03015:error occurred in stored script Global_arch Rman-03002:failure of Backup command at 06/02/2011 01:20:45 rman-06059:expected archived log not found, lost of archived log compromises recoverability Ora-19625:error Identifying FILE/U01/RMAN2_5585_697

used:Controls OS resources used by RMANAffect degree of ParallelismSpecify the I/O bandwidth limit (set the limit read rate parameter)Specify the size limit of the backup slice (set limit Kbytes)Specify the limit of the currently opened file (set limit maxopenfiles) ============================================ Typical one-week backup solution for RMAN = ========

: bakwww.sh file must have the permission to execute!LINUX Automatic backup script filesFirst I set up a folder under the/root/backup directory,#mkdir/root/backup/mysqlbackupLater at five o'clock every day, there will be a file saved here.Then create a new file#vim/root/mysq

encountered ORA-17627 ORA-12154 Oracle cold backup Oracle Hot Backup Concept of Oracle backup recovery Oracle instance recovery Oracle recovery based on user management System tablespace management and Backup Recovery Sysaux tablespace management and recovery Oracle backup

; backup datafile n; (n: Specific data file number: select file_name, file_id, tablespace_name from dba_data_files ;) Control File: RMAN> backup current controlfile; Or RMAN> backup database include current controlfile; Log File: RMAN