Skip to main content

Step By Step Cloning Oracle Database Using RMAN

~`~` Step By Step Cloning Oracle Database 10g Using RMAN`~`~

  • Delete existing DataFile folder in oradata location. 
  • Login to SQLprompt.
  • SQL> shutdown abort; (target database)
  • Now login to RMAN and set DBID:
  • RMAN> set DBID 123456; (Get it from source database, by connecting RMAN.)
  • Now, if there is no database i.e. you have just installed the target database (software only), then check if the dump destination folders are created at dump destination.Ex. - /app/oracle/admin/ULTIMUS/bdump/.
  • Startup the database in no mount state :
    • SQL> startup nomount;
  • Restore pfile:
    • SQL> restore spfile to pfile '$ORACLE_HOME/dbs/initULTIMUS.ora' from 'BACKUP_DESTINATION/autobackup/2011_06_20/o1_mf_s_744258937_6pofdsx4_.bkp’;
  • (or copy pfile i.e. initULTIMUS.ora from live server then paste it to dbs folder, if the following command is not working).
  • Restart the database with new pfile:
    • SQL> startup force nomount pfile=' $ORACLE_HOME /dbs/initULTIMUS.ora'
  • Restore control file from backup:
    • SQL>restore controlfile from ' BACKUP_DESTINATION /autobackup/2011_02_28/o1_mf_s_744258937_6pofdsx4_.bkp'
  • (Note: if control file redundancy is used check whether the redundant folder exist or not. Ex. /datafile/oracle-backup/multiplexed.)
  • Mount the database:
    • SQL>Alter database mount
  • If necessary Copy the latest archivelog from live server to ‘ BACKUP_DESTINATION /archivelog/2010_06_20/’.
  • Restore the database using until time command:
    • SQL> restore database until time "to_date('20/06/2011:20:00:00','dd/mm/yyyy:hh24:mi:ss')"
  • Recover the database using until time command:
    • SQL> recover database until time "to_date('20/06/2011:20:00:00','dd/mm/yyyy:hh24:mi:ss')"
  • Open the database with resetlogs:
    • SQL> alter database open resetlogs
------------------------------------------------------------------------------------------------------
Hope this will help you. Happy to help.
thanks for reading this article. good day.
Labels:

Comments

Post a Comment

Popular posts from this blog

Starting and Stopping the Oracle Enterprise Manager Console

Starting and Stopping the Oracle Enterprise Manager Console To access the Oracle Enterprise  Manager Console from a client browser, the  dbconsole  process needs to be running on the server. The dbconsole process is automatically started after installation. However, in the event of a system restart,change in IP, or other changes, you can start it manually at the command line. To start the  dbconsole  process from the command line: Navigate into your  ORACLE_HOME/bin  directory. Run the following statement: ./emctl start dbconsole Additionally, you can stop the process and view its status. To stop the  dbconsole  process:          ./emctl stop dbconsole To view the status of the  dbconsole  process:         ./emctl status dbconsole -------------------------------------------------------------------------------------------------------
Post a Comment
Read more

Query to check the OPTIMAL UNDO RETENTION

Query to check the OPTIMAL UNDO RETENTION _____________________________________________________________________________ SELECT d.undo_size / (1024 * 1024) "ACTUAL UNDO SIZE [MByte]",        SUBSTR(e.value, 1, 25) "UNDO RETENTION [Sec]",        ROUND((d.undo_size / (to_number(f.value) * g.undo_block_per_sec))) "OPTIMAL UNDO RETENTION [Sec]"   FROM (SELECT SUM(a.bytes) undo_size           FROM v$datafile a, v$tablespace b, dba_tablespaces c          WHERE c.contents = 'UNDO'            AND c.STATUS = 'ONLINE'            AND b.name = c.tablespace_name            AND a.ts# = b.ts#) d,        v$parameter e,        v$parameter f,        (SELECT MAX(undoblks / ((end_time - begin_time) * 3600 * 24)) undo_block_per_sec  ...
Post a Comment
Read more

Solution of problem: Resultset Exceeds the Maximum Size (100 MB)

Solution of problem: Resultset Exceeds the Maximum Size (100 MB) I was running a select statement in PL/SQL Developer. it was a short query but the data volume that the query was fetching was huge. But when ever i Click the button Fetch Last Page or press 'ALT+End' button a message box comes after a while saying: Then I started looking for the exact reason of this sort of problem in Google. When I realized there was no direct solution in the web, I started looking the PL/SQL Developer Software menu and found the ultimate solution. The reason of this problem is there is a parameter of maximum result set size in PL/SQL Developer Software which is by default set to 100 MB. To change this parameter you have to go to the following location: 1. Goto Edit Menu and click ' PL/SQL Beautifier Options '. A new window will open. 2. Click SQL Window of " Window Types ". 3. Now Change the value of "Maximum Result Set Size( 0 is unlimited)"  ...
6 comments
Read more