Re: Backup and Recovery

Try export command

Example bat-file
d:
cd \data.ora\backup

set BASE=SID1
exp80.exe user SID1/usersid1@%BASE% file=%BASE%.exp log=%BASE%.log full=Y

set BASE= SID2
.....

You don't have to stop oracle databases

In next step copy export-file to tape etc...

Recover
1. Create instance, system tablespace, rolbacksegment ... 2. Import from export file as system/manager

lauracampos_at_yahoo.com napisał(a) w wiadomości: <7lgbpe$l0e$1_at_nnrp1.deja.com>...
>My company wants me to create some backup and recovery procedures for
>If anyone has a template please email me at: camposlm_at_navair.navy.mil.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Jul 02 1999 - 09:59:22 CDT