Disk is cheap . You are better off getting the required space and cloning a
development db .
Are you using RMAN to backup or doing user managed backups ? May be you
could resize the datafiles on prod and copy them to development . Then you
can resize datafiles back on production .
"chongsoon" <wchuacs_at_pc.jaring.my> wrote in message
news:3F953085.A665A6B3_at_pc.jaring.my...
>
> Hi all,
>
> What is the best method to refresh a development database on different
> box from production database ?
>
> There is hot backup running daily and the databases are in archivelog
> mode. The production database now reaching
> 140G although it's actually size only 60%, we don't use autoextend here.
>
> I am wondering here, whether can we able to clone the production
> environment by partially ? What I mean here is we
> copy some of necessary tablespaces like system while other make them
> offline and bring the database. Then step by
> step copying the rest of the tablespaces and resize them accordingly.
> The main purpose is due to space limitation as we
> don't have identical disk space.
>
> Let me know if I haven't describe the situation clearly !
>
> thank you.
>
Received on Wed Oct 22 2003 - 06:54:28 CDT
