Oracle database backup and recovery - Explain how to clone/duplicate a database
with RMAN posted by Babu
Kunwar
Explain how to clone/duplicate a database with RMAN
In order to clone/duplicate a database with RMAN follows the steps below:
-
Create an Oracle password file for the Auxiliary instance
-
Create new init.ora for the database.
-
Configure SQL NET for the new database.
-
Create the required directories as defined in init.ora.
-
Startup nomount the Auxiliary instance on the target node.
-
Check that source database is mounted or open.
-
Check a backup of all the datafiles and archived logs exist in target server.
-
Start RMAN and allocate Auxiliary channels to new database.
-
Execute the duplicate database command.
-
Check the new database.
More links
What are joins? Explain its characteristic features
Types of joins. Define, write syntax and an example for each type.............
|
