Refresh Database form production for EBS(no RMAN)

copy all  dbf file from production to non prod server 
example  '/oradata/SID/*.dbf based on your init.ora

 1. Source your environment

   sqlplus '/as sysdba'

2.  SQL - startup nomount

[In the nomount stage, Oracle  opens and reads the initialization parameter file (init.ora) to see how the database is configured]


3. execute the below script newdb.sql

Inside newdb.sql


CREATE CONTROLFILE SET DATABASE "SID" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 5
    MAXDATAFILES 500
    MAXINSTANCES 1
    MAXLOGHISTORY 8180
LOGFILE
  GROUP 1 (
    '/oradata/SID/log10a.log',
    '/orafra/redo/SID/log10b.log'
  ) SIZE 50M,
  GROUP 2 (
    '/oradata/SID/log20a.log',
    '/orafra/redo/SID/log20b.log'
  ) SIZE 50M,
  GROUP 3 (
    '/oradata/SID/log30a.log',
    '/orafra/redo/SID/log30b.log'
  ) SIZE 50M,
  GROUP 4 (
    '/oradata/SID/log40a.log',
    '/orafra/redo/SID/log40b.log'
  ) SIZE 50M,
 GROUP 5 (
    '/oradata/SID/log50a.log',
    '/orafra/redo/SID/log50b.log'
  ) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/oradata/SID/system01.dbf',
  '/oradata/SID/system02.dbf',
  '/oradata/SID/system03.dbf',
  '/oradata/SID/system04.dbf',
  '/oradata/SID/system05.dbf',
  '/oradata/SID/rbs01.dbf',
  '/oradata/SID/ctxd01.dbf',
 ...
...
...
..

'/oradata/SID/interim.dbf',
  '/oradata/SID/izud01.dbf',
  '/oradata/SID/izux01.dbf',
  '/oradata/SID/sysaux01.dbf'
CHARACTER SET US7ASCII
;

ALTER DATABASE OPEN RESETLOGS;
ALTER TABLESPACE TEMP ADD TEMPFILE '/oradata/SID/temp02.dbf'
     SIZE 2000M REUSE AUTOEXTEND ON NEXT 106496  MAXSIZE 32767M;
ALTER TABLESPACE TEMP ADD TEMPFILE '/oradata/SID/temp01.dbf'
     SIZE 2000M REUSE AUTOEXTEND ON NEXT 106496  MAXSIZE 32767M;
-- End of tempfile additions.

once database is created,
4. shutdown 
5. startup 
6  unclock system account,
7. change apps password using fndcpass
8. clean up fnd_nodes.
9. take backup TNS_ADMIN directory
10. run adconfig.sh on db side and apps server side.
11 startup database server, application server and make sure every thing works.