db clone 2 hist

useradd -g dba -G oinstall orahris

passwd 123

　

1.

COPY PARAMETRE FILE.

ORAPWD FILE

RMAN FILE

ARCHIVE FILES.

　

2.PUT IN SOME DIR IN SERVER SIDE.

　

3.

MAKE PATH MENTION AS PER PARAMETRE FILE.IF ITS SPFILE, CONVERT TO PFILE.

　

SQL>crete pfile from spfile;

spfile created.

　

　

4.CREATE DIRECTORIES.

　

A>$ORACLE_BASE: /GSTDB/hrist

ORACLE HOME:/GSTDB/hrist/product/11.2.0/dbhome_1

audit_file_dest=$ORACLE_BASE/admin/HRIST/adump

control_files=$ORACLE_BASE/oradata/HRIST/control01.ctl

$ORACLE_BASE/fast_recovery_area/HRIST/control02.ctl

db_recovery_file_dest=$ORACLE_BASE/fast_recovery_area

dispatchers='(PROTOCOL=TCP) (SERVICE=HRISTXDB)'

*.local_listener='LISTENER_HRIST'

log_archive_dest_1=$ORACLE_BASE/archivelogs

　

mkdir -p /GSTDB/hrist

mkdir -p /GSTDB/hrist/product/11.2.0/dbhome_1

mkdir -p /GSTDB/hrist/admin/HRIST/adump

mkdir -p /GSTDB/hrist/oradata/HRIST/

mkdir -p /GSTDB/hrist/fast_recovery_area/HRIST/

mkdir -p /GSTDB/hrist/archivelogs

mkdir -p /GSTDB/hrist/diag/rdbms/hrist/HRIST/trace

　

chown -R hrist:dba /GSTDB/hrist

chmod -R 775 /GSTDB/hrist

　

　

　

dump :

$ORACLE_BASE/diag/rdbms/hrist/HRIST/trace

　

Place Parametre file in respective location:

　

5.Create bash Profile

BASH PROFILE SETUP IN HRIST:

export PATH

export ORACLE_HOME=/GSTDB/hrist/product/11.2.0/dbhome_1/

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_BASE=/GSTDB/hrist/

export ORACLE_SID=HRIST

　

　

6.

START DB WITH NOMOUNT.

　

7.

　

TAKE CONTROL FILE FROM PROD , WITH BELOW COMMANDS.

> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/tmp/control.sql' ;

COPY TO NEWDB SERVER.

EDIT IT.

　

IF YOU ARE GOING TO CHANGE DB NAME THEN CHANGE CONTROL FILE COMMANDS.

　

=================================================================================

　

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

AFTER EDITING:

　

　

CREATE CONTROLFILE SET DATABASE "HRIST" RESETLOGS NOARCHIIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 5552

LOGFILE

GROUP 1 '/GSTDB/orahris/oradata/HRIST/redo01.log' SIZE 50M BLOCKSIZE 512,

GROUP 2 '/GSTDB/orahris/oradata/HRIST/redo02.log' SIZE 50M BLOCKSIZE 512,

GROUP 3 '/GSTDB/orahris/oradata/HRIST/redo03.log' SIZE 50M BLOCKSIZE 512

-- STANDBY LOGFILE

DATAFILE

'/GSTDB/orahris/oradata/HRIST/system01.dbf',

'/GSTDB/orahris/oradata/HRIST/sysaux01.dbf',

'/GSTDB/orahris/oradata/HRIST/undotbs01.dbf',

'/GSTDB/orahris/oradata/HRIST/users01.dbf',

'/GSTDB/orahris/oradata/HRIST/tjtghrp_data01.dbf'

CHARACTER SET WE8ISO8859P1

;

　

=================================================================================

/home/hrist/filehris

/GSTDB/hrist/product/11.2.0/dbhome_1/dbs

　

　

7.

SQL> startup nomount;

SQL> @/tmp/control.sql

　

8.

TRANSFER ALL LATEST DATE ARCHIVELOG AND RMAN BACKUP.

scp -r TJTGHRP_Control_file969088033_16002_1 hrist@172.16.2.65:/home/hrist/filehris/

scp -r * hrist@172.16.2.65:/GSTDB/hrist/archivelogs

　

sql>archive log list;

sql>rman backup location;

DedRspu5e

　

　

　

catalog start with '/home/hrist/filehris/rmanbkp/';

YES

list backup of database;

　

　

RMAN>

run

{

allocate channel c1 device type disk;

SET NEWNAME FOR DATAFILE 1 TO '/GSTDB/app/hrist/oradata/TJTGHRP/system01.dbf';

SET NEWNAME FOR DATAFILE 2 TO '/GSTDB/app/hrist/oradata/TJTGHRP/sysaux01.dbf';

SET NEWNAME FOR DATAFILE 3 TO '/GSTDB/app/hrist/oradata/TJTGHRP/undotbs01.dbf';

SET NEWNAME FOR DATAFILE 4 TO '/GSTDB/app/hrist/oradata/TJTGHRP/users01.dbf';

SET NEWNAME FOR DATAFILE 5 TO '/GSTDB/app/hrist/oradata/TJTGHRP/tjtghrp_data01.dbf';

　

RESTORE DATABASE;

SWITCH DATAFILE ALL;

RECOVER DATABASE;

}

　

　

alter database open resetlogs;

　

done.

===============================