CREATE DTABASE USING COLD BACKUP

DEVELOPMENT SERVER(SWO1143) :

Step1: Copy the backup files from source server to target server.

                -source server = ( sw00888,sw00889,sw00891 )

                -target server = ( sw01143 Development server)

Step2: we need to install only oracle software in this server (sw01143).

                -oracle database version =11.2.0.3

Step3: Copy all the datafiles,Redolog files, controlfiles from backup location to              

original location.

 -install oracle binaries on ORACLE_HOME=E:\Oracle\Product\11.2.0\dbhome_1.

 -Backup location = F:\oradata\copy ( sw00888 server)

  in development server :

             -Datafiles location: E:\oradata\instance_name\*.dbf

             -Controlfiles location E:\oradata\instance_name\*.ctl

             -Redologfiles location E:\oradata\instance_name\*.rdo

Step4: Copy the pfile “initsw01143.ora”  in “ORACLE_HOME\database” location.

               -Pfile Having the bellow parameters  (Example)

               dousna01._db_cache_size=557842432

                             dousna01._java.pool_size=20971520

                        'E:\ORADATA\DOUSNA01\CONTROL01.CTL'

dousna01._large_pool_size=4194304

dousna01._shared_pool_size=243269632

dousna01._streams_pool_size=4194304

compatible='10.2.0.3'

control_files='E:\ORADATA\DOUSNA01\CONTROL01.CTL'

          'E:\ORADATA\DOUSNA01\CONTROL01.CTL'

db_block_size=8192

db_domain='se.hvwan.net'

db_file_multiblock_read_count=16

db_name='dousna01

db_recovery_file_dest_size=2147483648

dispatchers='(protocal=tcp)  (service=dosehvo4xdb)

java_pool_size=2000000

job_queue_processess=0

nls_language='AMERICAN'

nls_territory='AMERICA'

open_cursors=300

open_links=24

pga_aggregate_target=314572800

processess=150

recyclebin='OFF'

remote_login_passwordfile='EXCLUSIVE';

replication_dependency_tracking=TRUE

sga_target=838860800

……

Step5: Make a directories as mension in the pfile like dumps, and change the

 Open the command prompt and perform those commands

--sql prompt will open

 Set ORACLE_SID=Sw01143

 Check “echo %ORACLE_SID%

 ORADIM –new –sid sidname(dousju01)( it will create instance in winds)

 Set ORACLE_HOME=Oracle_home path

 Run Sqlplus “/as sysdba”

 Fire the “startup” command

 Database will open in noarchive log mode, put into Archivelog mode.

           

                  Using bellow query  in sql prompt check the database mode

          SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

LOG_MODE

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

        NOARCHIVELOG

                   Put the database in mount stage and then run the query

                                           SQL> startup mount

                  ORACLE instance started.

                  Total System Global Area  184549376 bytes

                  Fixed Size                  1300928 bytes

                  Variable Size             157820480 bytes

                  Database Buffers           25165824 bytes

                  Redo Buffers                 262144 bytes

                  Database mounted.

                                            Database altered.

                                   Database altered.

                             SQL> select log_mode from v$database;

        SQL> alter database archivelog;

     SQL> alter database open;

LOG_MODE

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

      ARCHIVELOG