Backup/Restore for my demo database
422557Oct 7 2004 — edited Nov 18 2004Howdy all. I am running Oracle 10g Standard Edition on Windows 2K Server. I have the following situation ...
I would like to make a standard demo database for my company. This database would be put on several machines and used by sales people to demo our software to possible customers. I need to be able to restore this database on a machine with Oracle 10g installed and then run our software on it.
I can make the database and run our software on it just fine on my machine. I am, however running into problems when trying to learn how Oracle and RMAN work with backups and restoring those backups. I am coming from the MSSQL2K environment where backup/restore is fairly simple and straightforward.
Will somebody please give me a basic idea of what I need to do in order to take the database on my machine and back it up and then restore it on another machine. I don't want to have the restore depend on a given file/directory structure. Our software depends on two tablespaces in the Oracle database. So, if it is easier to somehow backup the two tablespaces and restore them than it is to backup the entire database and restore it - then that is great. I will do it that way.
I am basically looking for the simplest approach for restoring this demo database wherever I want to quickly. Any help would be greatly appreciated.
wally