Backup of schema
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Backup of schema

  1. #1
    Join Date
    Jan 2001
    Posts
    5
    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...

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Jmodic solution is best bet

    And very simple to use...

    exp userid/xxxx buffer=9999 file=yyyy.dmp consistent=y owner=schemaA

  4. #4
    Join Date
    Jan 2001
    Posts
    5
    Thank you muchly....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width