You could have these students use the export/import and save the database creation script as well. Just running the db creation script shouldnt take too long.
-----Original Message-----
From: Rahimi Saeed K.
[mailto:oracledba-ezmlmshield-x34414079.[Email address protected]
Sent: Wednesday, April 27, 2005 14:58
To: LazyDBA Discussion
Subject: RE: Quick backup and restore!
Yes, export works well for those students who use the default database,
bank. Some students create their own database and work on that. In their
case, they need to recreate the database before import - that takes time
during the class. I was hoping to eliminate the db creation time during the
class.
Regards,
SKR
-----Original Message-----
From: juneau
[mailto:oracledba-ezmlmshield-x45524282.[Email address protected]
Sent: Wednesday, April 27, 2005 2:50 PM
To: LazyDBA Discussion
Subject: Re: Quick backup and restore!
Ever tried using a database export? You could schedule a nightly database
export and then save the dump for restoring your database after the ghosting
activity takes place. This is also a nice solution for creating a
development copy of your current production database.
Hope this helps...
Josh
----- Original Message -----
From: "Rahimi Saeed K. " <oracledba-ezmlmshield-x48026266.[Email address
protected]
Date: Wednesday, April 27, 2005 2:42 pm
Subject: Quick backup and restore!
> Hello,
>
> Hi,
> I teach a database class using Oracle 9i under Windows XP at a
> Universitysetting. Students start with a database that is created
> as part of the
> computer image for the class (called bank). They create a lot of
> structuresin this database as part of their class hands on during
> the semester.
>
> Since this is a university setting, the tendency is to have a lot
> of viruses
> and Trojan horses attacking the servers. As a result, during a given
> semester we have to re-image (using Ghost) the servers many times.
> Everytime, we re-image any server all the work of the students is
> lost since the
> image has the default empty bank database .
>
> To help solve this problem, I have used the following scripts to have
> students back up their database contents on regular basis. Once
> they use the
> scripts to restore, all data and control files are back but Oracle
> does not
> start the bank service.
>
> What am I doing wrong? It this a valid approach, or anyone knows
> of a better
> approach? I cannot ask students to use RMAN since we do not get to
> coverRMAN until third part of the semester.
>
> Any help in this regard is appreciated.
>
> Regards,
> SKR
>
> Scripts to backup
> --------------------------------------------------------------
> REM This command file stops the listener and the bank service.
> REM The files for this DB are copied to a safe place for backup
> REM
>
> REM Stop the listener
> lsnrctl stop
>
>
> REM Stop the SID
> oradim -shutdown -sid bank
>
>
> REM copy the database admin\SID files
> xcopy c:\oracle\admin\bank\*.* d:\oraclecopy\admin\bank\ /E /Y
>
>
> REM Copy the oradata files - control files, ETC.
> xcopy c:\oracle\oradata\bank\*.* d:\oraclecopy\oradata\bank\ /E /Y
>
> REM Copy .ora files as well
> XCOPY C:\oracle\ora92\network\admin\*.*
> D:\oraclecopy\ora92\network\admin\/E /Y
>
> Scripts to restore
> ----------------------------------------------------------------
> REM This command file stops the listener and the bank service.
> REM The files for this DB are restored
> REM
>
> REM Stop the listener
> lsnrctl stop
>
>
> REM Stop the SID
> oradim -shutdown -sid bank
>
>
> REM copy the database admin\SID files
> xcopy D:\oraclecopy\admin\bank\*.* C:\oracle\admin\bank\ /E /Y
>
>
> REM Copy the oradata files - control files, ETC.
> xcopy D:\oraclecopy\oradata\bank\*.* C:\oracle\oradata\bank\ /E /Y
>
> REM Copy .ora files as well
> XCOPY D:\oraclecopy\ora92\network\admin\*.*
> C:\oracle\ora92\network\admin\/E /Y
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page