Sunday, 31 March 2013

Refresh Clone of Oracle R12

UPDATE CLONE FROM PROD
prod pfile with
change path according to clone and add log_file_name_convert,db_file_name_convert parameter

1- sqlplus>startup nomount pfile='/d01/oracle/PROD/tech_st/11.1.0/dbs/initfinprodrefresh.ora';
2-rman target /
rman>restore controlfile from '/backup/oracle/.......';
rman>alter database mount;
rman>catalog backuppiece '/backup/oracle/              and 'database backup' and 'archivelog backup'
or
rman>CATALOG START WITH '/backup/oracle ';
RMAN>CATALOG START WITH '/backup/oracle' NOPROMPT;
3-run rman restore script;
4-alter redolog file rename
5-alter database open resetlogs;
6-change database name
shutdow immediate
delete controlfile
startup nomount pfile='/d01/oracle/CLONE/db/tech_st/11.1.0/dbs/cloner_sfxprodapp1_ifile.ora';
create controlfile
alter database open resetlogs
7-create tablespace
6- FNDCPASS apps/mobileform 0 Y system/manager SYSTEM APPLSYS safex321
7- AUTOCONFIG

No comments:

Post a Comment