rman backup script

######################################################################## # # Kfc_incremental_hot_database_ backup.sh # # # Created by NBU TEMP # # # 2012-3-8 # # ############ ############################################################# #!/bin/ksh export Lang=en_us BACKUP_DATE= ' DATE +%d ' Rman_log_file=/home/oracle/1028/log/backupinfo.out today= ' date ' user= ' id|cut-d ' ("-f2|cut-d") "-f1 ' echo"---------- -------$TODAY-------------------"> $RMAN

Oracle 11g R2 rac rman backup script example 1. Switch RAC to archive Mode 1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have configured archive. SQL> alter system set cluster_database = false scope = spfile sid = '*'; 2. Shut down all instanc

The rman backup script in the Oracle database is very practical. The rman backup script in the Oracle database is very practical. Query character sets SQL> select * from nls_database_parameters; NLS_CHARACTERSETAL32UTF8 Character

The rman backup script in the Oracle database is very useful for querying the character set SQLgt; select * fromnls_database_parameters; NLS_CHARACTERSETAL32UTF8 The rman backup script in the Oracle database is very useful for que

RMAN backup is easy to use for Oracle database backup and recovery, with low costs. For non-catalog mode, it is undoubtedly the first choice to embed the RMAN script into the shell script and then use crontab to back up small and

One. Task SchedulerWindows-Control Panel-Administrative Tools-Schedule task programs, right-click Task Scheduler Library, create taskSecond: The contents of the relevant script:Content in 2.1 Back_rman.bat:Set Oracle_sid=fsf:\oracle\product\10.2.0\db_1\bin\rman target/ cmdfile=h:\worksql\windows_backupscript\ BACKUP.RCV log=h:\worksql\windows_backupscript\backup_%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~ 3,2%.logContent in 2.2 BACKUP.RCV

This backup script is organized from the network, and some comments are added. This script is clear and can be applied to the production machine with slight changes. 1 #! /Bin/ Bash 2 ######################################## ############################### 3 # 4 # Backup policy: 5 # Grade 0 backups every

Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix platform using shell implementation is very simple, But ran to win inside, became vexed, not because of the trouble, but because the use of less people, do not know how to deal with the matter, I wrote a sim

Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix platform using shell implementation is very simple, But ran to win inside, became vexed, not because of the trouble, but because the use of less people, do not know how to deal with the matter, I wrote a sim

Label:With 0112111 incremental backup strategy, 7 days a cycle that is, Sunday level 0 backup, Week 1 2 4 5 6 with 2-level incremental backup, week 3 with 1-level incremental backupConfigure control file backup path RMAN > CONFIGURE controlfile autobackup FORMAT fo

Rman backup script rman shell script editing is first tested in rman to check whether the backup is normal. The statement is being judged. Backup