next Sunday, perform level 0 backup and a new backup cycle starts.* In the OCP book, the syntax for level 1 differential backup is backup incremental level 1 differential database. During the operationRMAN syntax error: RMAN-01008: the bad identifier was: differentialFalse Incremental
step 2 and Step 3 above.
On the next Sunday, perform level 0 backup and a new backup cycle starts.
* In the OCP book, the syntax for level 1 differential backup is backup incremental Level 1 differential database. During the operation
RMAN syntax error: RMAN-01008: The bad identifier was: Differential
False Increment
use Find.-mtime +180-name "*.sql.gz" |grep-v "1063001.sql.gz"-exec rm-rf {} \; The direct RM was deleted after the retrieval, but since find uses G Rep error does not recognize {}, so the compromise adopted a scheme to save the retrieved file in a temporary file old_backupfile_$d2.csv inside, and then traverse the Old_backupfile_$d2.csv file to MV or RM operation, etc. The find grep exec error is as follows:
[[email protected] ~]# find. -mtime +180-name "*.sql.gz" |grep-v "10630
not need to back up the Data= ' tail-1 $filename ' if[ $data "== "$comparedata" ];then echo "' Date ' rmanbackupsucess" >>/ops/tarlog else echo "' Date ' Rmanbackup Fail "NBSP;AMP;GT;GT;NBSp;/ops/tarlog exit2 fi #tarbackupfileandmoveto Backupserver #将当天的备份集压缩备份出来并move至对应nfs提供的文件夹, my 300GB backup compressed as long as 30 g, compression ratio is still very amazing/usr/bin/find/mnt/rman- name ' oradb1* ' >/ops/tarlist foriin '/bin/cat/ops/tarlist ';d
First, the experimental environment
1 View Existing backup sets
rman> list backup summary; List of Backups =============== Key TY LV S Device Type completion time #Pieces #Copies compressed Tag------------ -----------------------------------------------------411 B 0 A DISK 09-mar-16 1 1 NO Neal_lv0 412 B 0 A disk 09-mar-16 1 1 NO neal_lv0 413 b
Content Introduction:
Two kinds of shell script detailed
Operational actions to verify the validity of Rman backup sets
Rman Backup Recovery experiment Operation Warfare Technique
Often listen to some master said, to do a regular Oracle Database backup recovery experiment, it must wait until the database problem, say
recovery catalog
List of Backup Sets===================
BS Key Type LV Size Device Type Elapsed Time Completion time------- ---- -- ---------- ----------- ------------ ---------------1 full 10.94M DISK 00:00:01 28-jan-15BP key:1 status:available Compressed:no tag:tag20150128t230115Piece Name:/U01/2015_01_28/O1_MF_NNNDF_TAG20150128T230115_BDKYFVLW_.BKPList of Datafiles in
How to encrypt rman backup sets in oracle
Let's take a look at an oracle rman backup set encryption method. I hope this example will help you.
Data security is becoming more and more important. It doesn't mean that your production database is secure and your data is secure. rman backup is also an important part of dat
Navicat sets the execution plan task to facilitate Backup managementToday, the people who did not intend to perform the test proposed a simple task, asking them to create a daily scheduled backup task for the bug library on one of their servers, this library is the BUG patch library for various products used by testers. It is important to avoid data loss issues.
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.