Creating and updating duplicate databases with rman 11g

->>>> Click Here to Download <<<<<<<-

The article assumes the duplicate database is being created on a separate server, using the same SID DB11G and the same file structure as the source database. Explanations of several other scenarios are available here. Add the appropriate entries into the "tnsnames. Since we are duplicating the database onto a separate server with the same filesystem as the original, we don't need to convert the file names.

Make the backup files from the source database available to the destination server. That can be done by either copying them to the matching location on the destination server, or placing them on a shared drive. If you are copying the files, you may want to use the following type of commands. With the duplicate database started we can now connect to it from RMAN. Create the database service only for windows and password file.

Rest other steps are same. Start the Auxiliary instance. All rights reserved. Connected to an idle instance. Create the necessary oracle NET connectivity in the listener. Look at the example : Listener. In this example we are creating the duplicate database from the Auxiliary server.

You can start the RMAN client on any host so long as it can connect to all of the database instances. If the auxiliary instance requires a text-based initialization parameter file, then this file must exist on the same host that runs the RMAN client application.

In this bulletin we are doing duplicate database from the auxiliary server. Optional connected to recovery catalog database 3. Check Summary : Verify that the compatible parameter value is valid Fixup.

Summary :. Recovery Manager : Release Copyright c , , Oracle. All rights reserved. Starting backup at 12 - JUN - Finished backup at 12 - JUN - File created. Connected to an idle instance. Leaving database unopened , as requested. Cannot remove created server parameter file. Analyzing file catupgrd. Parallelism 4 is used. Subscribe for more articles Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.

Simple Talk. Rate this article.