The user requirement is to prepare a desktop icon on a NT workstation which allows the user to execute a backup of the Oracle 7.3 DB at any time. In this case prior to a mission critical job. The backup will be running at peak times. The main reason for the backup is if the subsequent job fails, a quick recovery can be performed before checking out reasons for the failure. The relevant DB cannot be placed in ARCHIVELOG mode.
The part of the DB that the user requires backup'ed is only one small part of the whole DB(schema A say).
Can you think of a simple way or product to perform this backup without stopping the whole DB and setting the ARCHIVELOG mode on?
I am new to this area....treat me kindly...
Use Oracle export utility, which performs a kinda logical backup, can also be applied only to specific schema.
Read about it in Oracle Utilities guide or run "EXP help=yes" from command line (on NT it might also be named EXPnn, where nn is your database version number, like 73 or 80).
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Jmodic solution is best bet
And very simple to use...
exp userid/xxxx buffer=9999 file=yyyy.dmp consistent=y owner=schemaA
Click Here to Expand Forum to Full Width