|
-
In this example, we will copy PROD to TEST
1) ensure you have a full backup on your prod machine:
2) Setup convert parameters in your dev init.ora
Here is my file system layout so you need to match it to your layout.
In my example where I see 'prod' it will convert to 'dev'
prod /u08/oradata/prod
dev /u08/oradata/dev
*.db_file_name_convert='prod','dev'
*.log_file_name_convert='prod','dev'
3) scp or rcp your PROD machine files to your dev machine and stick them
into your "PROD" directory on your DEV machine
4) script ro run on your dev machine once all files are copied over
sqlplus ' / as sysdba ' <
startup nomount pfile=/u01/app/oracle/product/10g/dbs/initdev.ora
exit
EOT
rman catalog=rman/rman@tprod target=sys/prod@prod << EOT
connect auxiliary sys/sdev
duplicate target database to dev nofilenamecheck
pfile=/u01/app/oracle/product/10g/dbs/initdev.ora
#### This is the exact end time of your full database backup on PROD
until time="TO_DATE('07/02/11:06:39:26','MM/DD/YY,HH24:MI:SS')";
exit
EOT
If the database was busy during the backup, you will have to apply archive files from
PROD to your dev machine.
If your stuck on that part open another thread and I can show you how to get the
arch files you need and apply them....
Good luck
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|