Hot backup clonning

step by step procedure for hotbackup clonning.


1.copy the tops

2.unzip tops

tar -zxvf *.tgz

3.go to datatop

remove controlfiles, temp.dbf


4.create control file

5. go to user dump you will have a latest trace file

startup nomount

create controlfile set DATABASE "AFCO" RESETLOGS NOARCHIVELOG

CHANGE THE DIRECOTRY LOCATION

USING :%S#....#...#G

6. go to 10.2.0/dbs/

7.vi initsid.ora

8.controlfiles=/u02/afco/d01/proddata/cntrl01.dbf,/u02/afco/d01/proddata/cntrl02.dbf,/u02/afco/d01/proddata/cntrl03.dbf,

sqlplus "/as sysdba"

sql> recover database using backup controlfile untile cancel;

9.It will ask for archives

10.give the archive in this way

11./u02/afco/Arch/................

12.cancel

13.alter database open resetlogs;

14. alter tablespace temp add tempfile '/u02/afco/d01/proddata/temp01.dbf' size 100m;

15.conn apps/apps

16.select node_name from fnd_nodes;

17.delete from fnd_nodes where node_name in ('AFCOERP','AFCOPREDB');

18.EXIT

19.10.2.0/APPSUTIL/SCRIPTS/

20.sh adautoconfig.sh

apps/apps