ORACLE RMAN DATABASE DUPLICATION PDF
The focus of this book is database duplication using RMAN. main purpose is the backup and recovery of Oracle databases, there are other features that. Oracle 11g has introduced active database duplication, we can create a duplicate of the .. LOSS OF FULL DATABASE & RECOVERY - RMAN BACKUP. pdf. Oracle RMAN Database Duplication – PDF Books. Oracle Oracle Database Workspace Manager Developers Guide · Oracle Database JDBC Developers.
|Language:||English, Spanish, Dutch|
|ePub File Size:||22.79 MB|
|PDF File Size:||20.40 MB|
|Distribution:||Free* [*Regsitration Required]|
Protected Databases. Cloud @ Customer. File syste m. RMAN: Built-in backup & recovery engine for the Oracle database which provides performant, efficient. PDF · Mobi · ePub In active database duplication, RMAN connects as TARGET to the source database instance and as RMAN connects to the auxiliary instance of the duplicate database on the destination host. The DUPLICATE entry in Oracle Database Backup and Recovery Reference for a complete list of which. Database Cloning Procedure using Oracle RMAN and the Sun ZFS Storage. Appliance. . appliance are then used to duplicate or clone the Oracle RMAN backup. The cloning procedure explained in pdf. The solution described in.
Make all necessary changes the new init. Start the auxiliary database instance using the init. Execute the duplicate command to perform database duplication. Version Listening Endpoints Summary Service "hrms" has 1 instance s. The command completed successfully. All rights reserved. Service "crms" has 1 instance s.
Used parameter files: Release Connected to an idle instance. It is must and should. From 11g we can clone databases using the from active database option.
In this case we do NOT require an existing backup, the active datafiles will be used as the source for the clone. Shuts down the instance and restarts it with the new spfile.
Do backups of the source database exist? The principal advantage of active database duplication is that it does not require source database backups.
Active duplication copies mounted or online database files over a network to the auxiliary instance. One disadvantage of this technique is the negative performance effect on the network.
Another disadvantage is that the source database is running processes required to transfer the files to the auxiliary host, thereby affecting the source database and production workload. If the source database backups exist, and if the effect on the network is unacceptable, then backup-based duplication may be a better option.
Duplicate a Database Using RMAN in Oracle Database 11g Release 2
You can copy backups to temporary storage and transfer them manually to the destination host. If duplication is made with a connection to the target or the recovery catalog, then the backup files on the destination host must have the same file specification as they had on the source host.
Otherwise, this is not a requirement. Is a recovery catalog available?
This technique is advantageous where network connections from the auxiliary host to the source database are restricted or prone to intermittent disruptions.
Mount the directory created in the previous step on the other host, ensuring that the directory and the mount point names are the same. Make the backups available in the new location on the destination host.
In this case, RMAN automatically catalogs the backups in the new location. Use an operating system utility to transfer the backups to the new location. Step 4: Preparing Remote Access to Databases When a database must be accessed from another host, you must set up a password file and Oracle Net connectivity.
Be aware of the potential security consequences of this type of setup. Establishing Connectivity in Required Cases To create a password file manually: Follow the instructions in Oracle Database Administrator's Guide to create a password file.
The types of file names allowed for password files and the location of the password file are both platform specific and operating system-specific.
See Also: Oracle Database Advanced Security Administrator's Guide To establish Oracle Net connectivity and set up a static listener: Follow the instructions in Oracle Database Net Services Administrator's Guide to configure a client for connection to a database and add static service information for the listener.
Creating a Password File for the Auxiliary Instance You have the following options for creating a password file for the auxiliary instance on the destination host: Create the password file manually. You may want to create the password file with a single password so that you can start the auxiliary instance and enable the source database to connect to it.
Active (Network-Based) Database Duplication - Oracle 11g
In this case, RMAN copies the source database password file to the destination host and overwrites any existing password file for the auxiliary instance. This technique is useful if the source database password file has multiple passwords that you want to make available on the duplicate database. This section makes the following assumptions: You choose the recommended technique of using the same naming strategy for the source and destination hosts.
You create a text-based initialization parameter file for the auxiliary instance.
Duplicate using RMAN
SPFILE technique is easiest because during duplication RMAN automatically copies the server parameter file from the source database to the auxiliary instance or restores it from backup. If a server parameter file exists on the auxiliary instance, then RMAN overwrites it. To create an initialization parameter file and start the auxiliary instance: Using a text editor, create an empty file for use as a text-based initialization parameter file. Do not create a control file or try to mount or open the auxiliary instance.
To ensure that the source database is in the proper state: If the source database instance is not mounted or open, then mount or open it. If you are performing active database duplication, then ensure that the following additional requirements are met: If the source database is open, then archiving must be enabled.
If the source database is not open, then the database does not require instance recovery. The RMAN client can be located on any host so long as it can connect to the necessary databases over the network. A recovery catalog connection is optional. A recovery catalog is optional.
The channel configuration depends on your duplication technique. However, you may want to increase the parallelism setting of your source database disk channels so that RMAN copies files over the network in parallel.
Note the following additional considerations: The channel type DISK or sbt of the auxiliary channel must match the backup media.
Task 1: Create an Oracle Password File for the Auxiliary Instance
In general, the more channels you allocate for disk backups, the faster the duplication. For tape backups, limit the number of channels to the number of devices available. When you perform duplication without a target connection and without a recovery catalog, only disk channels can be used.
If no user-allocated channels are used, then only one channel initially restores the control file. After the control file is mounted, the number of allocated channels depends on the configuration in the restored control file. Duplicating a Database This section describes the most basic procedure to duplicate a database. This section makes the following assumptions: You are duplicating the database to a remote host.
The duplicate database files use the same names as the source database files.Atul Mahajan.
As part of the duplicating operation, RMAN automates the following steps: RMAN obtains metadata about backups from the target database control file or from the recovery catalog. Duplication without a target database connection and without a recovery catalog.
Active (Network-Based) Database Duplication - Oracle 11g
Omitting this clause instructs RMAN to perform backup-based duplication. Otherwise, this is not a requirement.
This technique of duplication uses one of the following mutually exclusive subtechniques:. Typically, you do one of the following: Physically move the tapes to a drive attached to the remote host. Uses the RMAN repository to select the backups for restoring the data files to the auxiliary instance.
How RMAN Duplicates a Database For backup-based duplication, the principal work of the duplication is performed by the auxiliary channel s.