You have a unique opportunity to teach the importance of backups. Backups
should always top the list of priorities.
I used to teach a one semester class on database architecture using the
Oracle RDBMS. One of the major projects for the students went as follows:
1. create a database with tablespace based on certain specs. 10 points
2. create a schema and objects 10 points
3. use PL/SQL routines to populate the scheme 10 points
4. use an export to backup the schema 10 points
- I then simulated a catastrophe by dropping their tablespaces.
5. the students were required to recover the schema from the export 30
points
6. I ran scripts to verify all objects and data were correct.
30 points
Note, failure to import after the 'catastrophe' meant the student lost 60
points out of 100 (i.e. they flunked.)
That may sound brutal; however, they were warned repeatedly that this was
coming. It helped me emphasize the critical importance of backups.
You have an opportunity to use real life problems to do the same thing. I
suggest you teach the students how to use export and import. Make them
responsible for keeping backups of their own data. If a failure occurs, it
is like a pop quiz. They get 10 points for successfully recovering the
schema from export. Failure to recover means they lose points and they
lose many hours of effort.
That would be a great lesson. In the real world companies lose lots of
money and sometimes fire people if backups aren't in place.
regards,
James E. Strange
Database Systems Consultant Wellpoint IT
Office (317) 287-5423 Fax (317) 287-5428
Home 317 253-6154 Cell (317) 402-1742
Oracle Certified Professional DBA
|---------+--------------------------------------------------------->
| | "Rahimi Saeed K. " |
| | <oracledba-ezmlmshield-x48026266.[Email Address Removed] | azyDBA.com> |
| | |
| | 04/27/2005 02:42 PM |
| | |
|---------+--------------------------------------------------------->
>-----------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: |
| Subject: Quick backup and restore! |
>-----------------------------------------------------------------------------------------------|
Hello,
Hi,
I teach a database class using Oracle 9i under Windows XP at a University
setting. Students start with a database that is created as part of the
computer image for the class (called bank). They create a lot of structures
in 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. Every
time, 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 cover
RMAN 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
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise protected by law. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.
Oracle LazyDBA home page