i need to prepare local database for testing, with same patch/options level like production.I belive forum user already answered your question. I just want to add why you dont clone your ORACLE_HOME or db for test?
But I have only sqlplus access to production db (as sysdba).
select * from v$option;
PARAMETER VALUE -------------------------------------------------- ---------- Partitioning TRUE Objects TRUE Real Application Clusters FALSE Advanced replication TRUE Bit-mapped indexes TRUE Connection multiplexing TRUE Connection pooling TRUE Database queuing TRUE Incremental backup and recovery TRUE Instead-of triggers TRUE Parallel backup and recovery TRUE
Pavan Kumar wrote:unfortunately, I have only:
Does the any DBA exists who is having access to your production database environment (or) else left alone ? It's looks strange with out any access to production environment, how best you can mak equalize the environment in sync to production.
Ask you DBA to provide the tar of Oracle binaries, that would suffice your requirement, further proceed with performing cloning steps with respect to RAC/Non-RAC - which ever applicable to your case.
This would be easy way to complete your task.
- Pavan Kumar N
When you have said the above line of statement, then above task is not possible with out access. Who provided the task ? Does he an DBA (or) non-technical person, ask him and explain the things in technical terms.
i need to prepare local database for testing, with same patch/options level like production.
Do you have idea about the size of your production database ? If it deals with Tera btye (1024 GB), do you know how much time does the schema export take place (forget about the import) ?
unfortunately, I have only: - sql access (i can select other parameter like NLS, etc.) - schema export .. database must by running tomorrow