DataBase Refresh / Cloning

Database Refresh / Cloning / Migration

---------------------------
Non-ASM 10g/11g 
---------------------------
Reference: 

http://oraclegurukul.blogspot.in/2012/12/rman-cloning-10g-11g.html

----------------------------------------------------
DB Refresh DataPump
----------------------------------------------------
Reference:

https://born4dba.wordpress.com/2012/05/19/schema-refresh-using-data-pump/

-----------------------------------------------------------------------
11g ASM DB Refresh With DataPump
-----------------------------------------------------------------------
Reference:

http://select-star-from.blogspot.in/2013/08/schema-refresh-using-asm-diskgroups.html

--------------------------------------------------------------------------------------------------------------
RAC 10g/11g RMAN Cloning/Refresh RAC ASM to ASM & ASM to NON ASM 
--------------------------------------------------------------------------------------------------------------
Reference: 

https://simplyoracle.blogspot.in/2010/04/rac-database-refreshcloning-on-asm.html
https://dbmentors.blogspot.in/2012/04/rman-duplicate-database-from-rac-asm-to.html
https://gavinsoorma.com/2012/04/rman-duplicate-database-rac-to-rac/
https://nikhilappsdba.blogspot.in/2014/01/cloning-11g-rac-asm-to-non-asm.html
https://www.pythian.com/blog/duplicate-from-active-database-using-rman-step-by-step/
https://tsbreddy.blogspot.in/2012/06/rman-refresh-steps.html
https://dbarock.blogspot.in/2012/08/database-refresh-using-rman.html

---------------------------

Migration :

 -----------------------

NON-ASM to ASM in 10g Different host

http://gavinsoorma.com/2010/04/creating-an-asm-duplicate-database-from-a-non-asm-database/

http://oraclegurukul.blogspot.in/2014/04/non-asm-to-asm-with-rman.html

NON-ASM to ASM in 11g (Different host Duplicate Command)

http://dbaworkshop.blogspot.in/2010/10/rman-how-to-duplicate-non-asm-active.html

NON-ASM 10g to ASM 11g (Different host)

https://blogs.oracle.com/RobinAntony/entry/converting_10gr2_non_asm_database

Non-ASM 11g Database To ASM (Same Host)

https://orasteps.wordpress.com/2013/04/23/migration-of-non-asm-11g-database-to-asm/

NON-ASM to ASM in 11g Different host

1- Connect to 11g database and take RMAN full backup.

    #rman target /

    RMAN> backup as backupset database;

2- Copy 10g database backup files and archive files to 11g database server.

Install and Configure Standalone Grid infrastructure and mount the ASM DISK(+DATA)

Install the 11.2.0.3 Software alone.

The steps for 11g database:

3- Create temporary pfile in $ORACLE_HOME/dbs

*.audit_file_dest=’/oracle/admin/orcl/adump’

*.compatible=’11.2.0.0.0’

*.control_files=’+DATA/orcl/controlfile/current.1′,’+DATA/orcl/controlfile/current.2′

*.db_block_size=8192

*.db_create_file_dest=’+DATA’

*.db_create_online_log_dest_1=’+RECO’

*.db_name=’ORCL’

*.diagnostic_dest=’/oracle’

*.job_queue_processes=0

*.open_cursors=300

*.pga_aggregate_target=1G

*.processes=150

*.remote_login_passwordfile=’EXCLUSIVE’

*.sga_target=2G

*.undo_tablespace=’UNDOTBS1′

4- Open the database in NOMOUNT state.

    # rman target /

    RMAN> startup nomount;

5- Restore controlfile from backup.

    RMAN>LIST BACKUP OF CONTROLFILE

    RMAN> restore controlfile from ‘<backup piece name>′;

6- Open the database in MOUNT state.

    RMAN> alter database mount;

7- Catalog RMAN backup files and archive log files.(Ensure you have restored the backup copy)

    RMAN> catalog start with ‘/oracle/ora11g/orcl/backup’;

    RMAN> catalog start with ‘/oracle/ora11g/orcl/archive’;

8- Restore 10g database backup to +DATA diskgroup and perform incomplete recovery.

    RMAN> run

    {

    allocate channel c1 device type disk;

    SET NEWNAME FOR DATAFILE 1 TO ‘+DATA’;

    SET NEWNAME FOR DATAFILE 2 TO ‘+DATA’;

    SET NEWNAME FOR DATAFILE 3 TO ‘+DATA’;

    SET NEWNAME FOR DATAFILE 4 TO ‘+DATA’;

    restore database until sequence 4;

    switch datafile all;

    recover database until sequence 4;

    }

    ###shutdown the  database

    asmcmd>cd DATA/ControlFile