DB%File

Show parameter pfile

  To check if DB is running from pfile or spfile

Show parameter  db_create_file_dest  

   Db_create_file_dest  is used for table space monitor, if we are doing daily clone to Test  then we don’t need to worry since table space are fixed in Production .Any new DB growth should be directed to this destination.

Show parameter   db_file_name_convert 

 It’s a strong clone parameter . Whenever cloning runs manually we have to set it up to resemble Production mount points.

*In case of snapshot clone (FS clone) both the parameters value can be left blank.