Incremental Merge Backup
Incremental Merge Backup
rman.args
############################################################################# # # # FILENAME: rman.args # # # # Purpose: Supplies the RMAN scripts with the necessary parameters. # # # ############################################################################# # # # Revision History: # # # # REV DATE BY DESCRIPTION # # — —— ————– ——————————————- # # 1.0 053105 INFRASTRUCTURE Initial Release # # 1.2 081605 Fix bug […]
RMAN Master Note
RMAN Scripts RMAN Full backup script with compression
Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c
Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c Introduction For versions of Oracle 11gR2, Oracle Recovery Manager (RMAN) replicates a database to a different Oracle home and opens it with NORESET LOGS option. From Oracle 12cR1, database RMAN introduced an option called ‘NO OPEN’, which duplicates your database to a new […]
Backup / Restore Scripts
[code language=”SQL”] #!/bin/ksh ############################################################################ # Script Name..: 01 backup_copy_lvl0.ksh # Description..: # Author…….: M. Culp # Date………: 07/09/2013 # Version……: # Modified By..: # Date Modified: # Comments…..: # Schema owner.: # alter session set current # Login User…: # Run Order….: # Dependent on.: # Script type..: ############################################################################# rman << EOF connect target / […]
Backup Options 12c
Making Compressed Backups For any use of the BACKUP command that creates backup sets, you can take advantage of RMAN support for binary compression of backup sets. Specify the AS COMPRESSED BACKUPSET option to the BACKUP command. RMAN compresses the backup set contents before writing them to disk. The details of which binary compression level […]
Transportable Tablespaces from RMAN backup
Transportable Tablespaces from RMAN backup http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmttbsb.htm#BRADV05141 Creating Transportable Tablespace Sets This chapter explains how to use RMAN to create transportable tablespace sets by restoring backups. This discussion assumes that you are familiar with the transportable tablespace procedure described in Oracle Database Administrator’s Guide. The procedure in this chapter is an alternative technique for generating […]