That is done as a separate script after restore.
SKR
-----Original Message-----
From: Smith Ron L.
[mailto:oracledba-ezmlmshield-x92610660.[Email address protected]
Sent: Wednesday, April 27, 2005 2:57 PM
To: LazyDBA Discussion
Subject: RE: Quick backup and restore!
Your copy is the fastest an simplest idea. I don't see where you
restart the database or listener though.
Ron
-----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