i have a production database (oracle_sid is prod)
i want to clone the prod database to dev environment( oracle_sid is dev) .
i have rman backups in production database. i ftp'ed them to dev environment.
if i restore the backup in dev ,
1. will DBID & oracle_sid be the same in dev and in prod??
-- Also, i am in current dev box: if i issue
2. rman target sys/sys@prod auxillary / -- will this complete the process??
3. is it essential i know the sys password on PRod ?? i have dbaoper user password .. will that be sufficient ?