Originally posted by OracleDoc
*tap tap is this thing on?

you could do what we did at my last gig.
simply take a hot backup of the standby. ftp the datafiles over to your dev. Rename the database, startup using an edited controlfile from prod. Rinse and repeat as neccessary.
We did this on a nightly basis, we had a Reporting database that users could run thier reports off of instead of having to use prod.
It's particularly sweet if you're in an unsecure environment and have rsh available to use. If not use the ssh, A couple of scripts and voila` you've got yourself a nightly refresh job.
\
can i put the standby database in backupmode in all these versions

1)7.3
2)8.1.7
3)9.2

if not from which version onwards can i put the standby database in backup mode ?

regards
Hrishy