How to make database backups under Oracle?

K

korjik2012-07-23 10:28:34

Oracle

korjik, 2012-07-23 10:28:34

Hello.
There is access to the database (not to the server, but to the database), not even root. How can I set up something similar to mysqldump in Oracle?

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

S

strib, 2012-07-23
@strib

Not to work with Oracle "as with MySQL".
docs.oracle.com/cd/B13789_01/server.101/b10735.pdf - Backup and Recovery Basics
docs.oracle.com/cd/B12037_01/server.101/b10734.pdf - Backup and Recovery Advanced User's Guide

R

Ruslan_Y, 2012-07-23
@Ruslan_Y

Tell us in more detail what you want to do with this database and why?
Usually, backups are made for such DBMS, as in the first answer.
But if you need to quickly transfer data to another database or for something else, and the schema is very simple and the amount of data is small, for starters, just try the exp and imp utilities. Maybe they will be enough for your task.

D

dbmaster, 2012-07-23
@dbmaster

exp user/password FULL=y FILE=db_backup.dmp LOG=backup.log

W

Wott, 2012-07-23
@Wott

mm, there is no regular means to make sql from basis for Oracle.
It seems that a native tool was made for migration, but I can’t find something, apparently after the purchase it was covered.
There are all sorts of third-party tools for migration.
You can pull out the data through cvs, and the schema through sql developer, in the same place feel the triggers and procedures, and so on.