Oracle Database object File backup

How can i take a backup of all database objects(table schema, procedure, function) and store it in my windows file location every night. I'm connecting using PL/SQL Developer to oracle server located at different location.

开发者_运维问答To put in short words "I should have backup in my machine rather than the server", Any ideas

---

Assuming you installed them as part of your Oracle client installation, you could use the Oracle Export and Import utilities to create a logical backup on your client machine.

On the other hand, I would strongly question the wisdom of this requirement. Your DBA ought to be quite concerned about someone generating regular exports of their database that are not under the same controls as the normal backups to prevent them falling into the wrong hands. You're also copying all the data from the database over the network on a regular basis-- that is going to put a substantial load on the database and on the network that are likely to draw the attention of DBAs and network admins.

---

To back up backup sets from disk to tape:

If you are backing up a subset of available backup sets, then execute the LIST BACKUPSET command to obtain their primary keys.

The following example lists the backup sets in summary form:

RMAN> LIST BACKUPSET SUMMARY;

List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Comp Tag
--- -- -- - ----------- --------------- ------- ------- ---- ---
1   B  F  A DISK        28-MAY-07       1       1       NO   TAG20070528T132432
2   B  F  A DISK        29-MAY-07       1       1       NO   TAG20070529T132433
3   B  F  A DISK        30-MAY-07       1       1       NO   TAG20070530T132434

The following example lists details about backup set 3:

RMAN> LIST BACKUPSET 3;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    8.33M      DISK        00:00:01     30-MAY-07
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20070530T132434
        Piece Name: /disk1/oracle/dbs/c-35764265-20070530-02
  Control File Included: Ckp SCN: 397221       Ckp time: 30-MAY-07
  SPFILE Included: Modification time: 30-MAY-07
  SPFILE db_unique_name: PROD