Step By Step Creating Oracle Duplicate Database 10g on Same Server Using RMAN Auxiliary Instance and RMAN Backup

By -

Duplicating Target Database Using RMAN Auxiliary Instance on Oracle 10g

                                                  or

Creating Duplicate Database on the Same Server Using RMAN Backup.

We have Target Database name as ORCL

And we are creating a Auxiliary database with name as AUXDB 



Fig :- Backup-Based Duplication with a Target Connection
Image Source - docs.oracle.com

1.Take Whole Hot/Cold Backup of Target Database

RMAN> backup database plus archivelog;

2.Create Pfile from Target Database Spfile

SQL> create pfile='C:\ORACLE\PRODUCT\10.2.0\DB_1\Database\initauxdb.ora' from spfile;

3.Open pfile with notepad and replace (Ctrl + H) all orcl to auxdb

SQL> host notepad C:\ORACLE\PRODUCT\10.2.0\DB_1\Database\initauxdb.ora

4.On Windows Platform You need to Create a new Instance for auxdb which also creates an
password file for the same.

SQL> host oradim -new -sid auxdb -syspwd admin

5.Create All the folders in Oracle Folder Structures.

SQL> host mkdir C:\oracle\product\10.2.0\oradata\auxdb
SQL> host mkdir C:\oracle\product\10.2.0\flash_recovery_area\AUXDB
SQL> host mkdir C:\oracle\product\10.2.0\admin\auxdb
SQL> host mkdir C:\oracle\product\10.2.0\admin\auxdb\adump
SQL> host mkdir C:\oracle\product\10.2.0\admin\auxdb\bdump
SQL> host mkdir C:\oracle\product\10.2.0\admin\auxdb\cdump
SQL> host mkdir C:\oracle\product\10.2.0\admin\auxdb\dpdump
SQL> host mkdir C:\oracle\product\10.2.0\admin\auxdb\pfile
SQL> host mkdir C:\oracle\product\10.2.0\admin\auxdb\udump

6.Connect to auxdb and startup instance at nomount stage.

C:\set ORACLE_SID=auxdb
C:\sqlplus / as sysdba
SQL> startup nomount //Instance started with pfile
SQL> create spfile from pfile;
SQL> shut immediate
SQL> startup nomount //Instance started with spfile now

7.Now set these two parameters to convert your datafiles and logfile names.

SQL> show parameter convert
SQL> alter system set db_file_name_convert = 'orcl','auxdb' scope=spfile;
SQL> alter system set log_file_name_convert = 'orcl','auxdb' scope=spfile;
SQL> shut immediate
SQL> startup nomount

8.Now you need to connect Recovery Manager to start the duplicating (cloning) process.

C:\set ORACLE_SID=auxdb
C:\>rman auxiliary /
RMAN> connect target sys/admin@orcl
RMAN> run
{
allocate auxiliary channel ch1 device type disk;
allocate channel ch2 device type disk;
duplicate target database to auxdb;
}

9.If all steps are done correctly you will have a new database clone created successfully.

Thanks You - Saurabh Joshi

Comments

Post a Comment

Popular posts from this blog

Oracle Architecture - Explained In Detailed - Administration I

By -
Image
Figures shown in these notes are from Oracle® Database Concepts 11 g Release 2 Objectives These notes introduce the Oracle server architecture.   The architecture includes physical components, memory components, processes, and logical structures. Primary Architecture Components The figure shown above details the Oracle architecture. Oracle server :   An Oracle server includes an Oracle Instance and an Oracle database .   ·         An Oracle database includes several different types of files:   datafiles, control files, redo log files and archive redo log files.   The Oracle server also accesses parameter files and password files.   ·         This set of files has several purposes.   o    One is to enable system users to process SQL statements.   o    Another is to improve system performance.   o    Still another is to ensure the database can be recovered if there is a software/hardware failure. ·         The database server must manage large amo
Read more

Oracle Database SQL - Practise - Question - Scott Schema Examples

By -
Image
Oracle SQL Practice Questions for Students All Question are Based on Scott Schema Exhibits EMP TABLE Exhibits DEPT TABLE Exhibits SALGRADE TABLE Question 1) Display all the records in emp table? 2) Display all the records in emp table where employee belongs to deptno 10? 3) Display all the records in emp table where employee does not belong to deptno 30? 4) Display total number of records in Emp table? 5) Display emp table with salary descending order? 6) Display first five records in employee table? 7) Display all the records in emp table order by ascending deptno, descending salary? 8) Display all employees those who were joined in year 1981? 9) Display COMM in emp table. Display zero in place of null. 10) Display the records in emp table where MGR in 7698,7566 and sal should be greater then 1500 11) Display all employees where employees hired before 01-JAN-1981 12) Display all employees with
Read more

Step by Step - How to resolve redo log file corruption using ALTER DATABASE CLEAR UNARCHIVED LOGFILE command

By -
Image
Connect to sys using sqlplus in admin command prompt Check whether your database is in archive log mode or not. Run command ARCHIVE LOG LIST. It will show you the following details: It is always preferable to have your database in archive log mode. The reason being if your database is in archive log mode you can recover from all committed changes in the event of an OS or disk failure. This query will display the path of redo log files, their group and their status. It is always recommended to have a minimum of two members in one group. As you can see I have only 1 member in group 6 whose current status is INACTIVE. I intentionally have 1 member to generate a scenario for the sake of this practical. Now go to the specified path where the redo log member of group 6 is located and open it in a notepad. It will show some symbolic data. Delete couple of lines and save it the original location which is the one we got as a result of query. Why did we do the above step i.
Read more