rman backup script

Analysis on the reason why the RMAN backup file is much larger than the database size When talking with the customer, the customer proposed that the database size is only 40 GB, but the file backed up by RMAN is 80 GB, And the DUMP file exported by expdp is less than 40 GB, I feel a little surprised. Isn't RMAN only ba

This article describes how to use the Rman tool to automatically back up the control file dump and reply to the database when all the control files are lost; This article describes how to use the Rman tool to automatically back up the control file dump and reply to the database when all the control files are lost; This article describes how to use the Rman t

I received an email this morning and saw the failed rman recovery email sent by Master. The content is as follows: The data has been decompressed. Under/orabak/Oracle_bak However, an error is always reported when the backup file is read during restoration. Channel dev1: reading from backup piece/orabak/oracle_bak/fullrac_EPTDB_820_1_20130802 ORA-19870: error rea

In LINUX, you have written a script before using crontab to perform the RMAN backup experiment. You can run it manually. You cannot run it successfully using crontab. This afternoon, we spent two hours experimenting with the following: Note: after the script is complete, run it manually. When using crontab, pay attenti

1. Ranking explanation:Restore: RestoreRecover: RecoveryBackup set: similar to tablespaceBackup slice: a data file can be used across multiple backup slices, but in a backup set2. Principles:A. When a file is restored, the file cannot be used by the database instance.B. Only if the incremental level is 0 or full backup, the image copy can be restored. Other level

Nocatalog Way: Use control file as the catalog, each backup to the control files to write a lot of backup information, control files there will be more and more backup information, that is, Rman backup information written in the local control file.Catalog Mode: You must firs

--and check the%read value For each datafile.----> modifies the WHERE condition of the above script to serve as a common script for querying the datafile scan rate.Solution:Unused block compression is not applicable for version 10.2.0.1.Unused block compression can only be used if the tablespace established after hitting 10.2.0.2patchTherefore, you cannot use the unused block compression feature for table s

As an Oracle backup and recovery tool, RMAN provides us with powerful functions, including physical and logical detection of data files and validity detection of backup files. As an Oracle backup and recovery tool, RMAN provides us with powerful functions, including physical

Description It was meant to be no. The target library creates Dataguard tests from the target library backup set, and discovery is not possible in principle, but it has a very useful feature that enables fast Rman backup and machine recovery. Prior to the Rman backup from

Backup strategy for customer deployment, replacing important information related to customers Database backup Scenario Deployment process: Considering that the system is a high-availability system (7x24), it uses Rman to warm up the DB, and the specific backup steps are deployed as follows: 1. Change DB to archive m

Concurrent execution of Oracle RMAN backup of a single file If a file is a file of several gigabytes or tens of thousands of megabytes, You Need To parallelize the backup of the file. Generally, one channel can only read one file, however, you can use the multi-segment keyword to change this line: Run { Allocate channel t1 type sbt; Allocate channel t2 type s

RMAN backup and recovery-full recovery and Incomplete recoveryGlossary: As the name suggests, full recovery means that the index data has not been lost. Incomplete recovery refers to the loss of some data after recovery. They are two recovery methods for databases.Full recovery: Use the redo log or Incremental backup to restore the data block to a time point clos

Tags: --Backup control file rmantarget/rman>startup rman>configurecontrolfileautobackup on;--Start automatic backup rman>showcontrolfileautobackup;--show whether the control files are automatically backed up RMAN> configurecontro

Oracle-RMAN backup (2) in Oracle RMAN backup (1), the backup of various files in RMAN is described. backup sets are replicated in RMAN backu

The switch of the rman backup recovery command updates the data file name to the data file name specified during image copy under rman, and updates the data file name to the name specified by the setnewname command. The switch of the rman backup recovery command updates the

Oracle Rman Backup Example: Solaris + Oracle 11.2.0.3SHELL:CSH Backup strategy: Sunday Level 0 Backup, Monday ~ Weekly level 61 backup, Backup archive log every 6 hours, clean up the History folder every day.--Level 0

The archivelog file in the Test Library is accidentally deleted, but the file in the control file is still marked as valid (see selectname, sequence #, resetlogs_id, archived, delet The archivelog file in the Test Library is accidentally deleted, but the file in the control file is still marked as valid (see select name, sequence #, resetlogs_id, archived, delet -- The archive log file of the test database has been accidentally deleted. The solution is as follows:

Note: 1 The experiment environment is the same platform, in the same byte order, in the same version. The directory structure of the source and target machines is the same. 2. You only need to install the oracle database software on the target machine. 3. Use backup for the first time to restore the test environment, copy the backup from the source machine to the target machine, and register it in the contr

Command: connecttarget (connecttargetsystemoracle @ ora10g. If the database does not exist, you can directly start it with startup under the rman command. Command: connect target/(connect target system/oracle @ ora10g. If the database does not exist, you can directly start it with startup under the rman command. 1. Check the database mode:Sqlplus/nologConn/as sysdbaArchive log list (check whether the da

has been busy writing shell scripts, ignoring Oracle's basic review, just did an rman recovery, record a deeper impression. Oracle Full-Library backup is ideal for the mount, so there is no need to consider consistency issues. Just an ideal. To open the database in archive mode, complete the script as follows Log_file=/paic/hq/bk/restore/home/op11202/xionglang/in