Oracle Cold Backup Shared tablespaces

Hi there

I am new to oracle and I am trying to get up to speed very quickly. I have recently took over administration of two oracle databases on the same server, these two databases share a temporary and data tablespace, my question is with regards to backup and restore. At the moment the first database is shutdown and the files are copied to a backup directory using a batch file which just copies them using operating system commands, once this is complete the second database is shutdown and the files are copied in the same way. Will I be able to recover both the databases in the event of a failure or will I be told that the temp and data file for one of the databases has failed a verification check? Also the directory structure on this server is obscure, would in the event of failure would I be able to copy these files to a new server and restore the database? The databases are both running in noarchive log mode.

Thanks in advance Received on Mon Mar 04 2002 - 09:54:08 CST