How to make a Data Backup in oracle ? What is the procedure
for creating the dump files in oracle ( any version ) ?
Answer Posted / ace dba
A dump is _NOT_ a backup. You cannot roll forward to a
point in time after the dump was taken. The dump is for
moving data from one environment to another, and etc. Using
dump for backup _WILL_ result in data loss.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Whether any commands are used for months calculation? If so, what are they?
What is ADDM Advisor in Oracle?
How to select some columns from a table in oracle?
How do I reset a sequence in oracle?
Why is oracle so popular?
How to export several tables together?
Can we store pictures in the database and if so, how it can be done?
How to compare dates in oracle sql?
What is the oracle implicit cursor?
What is an Oracle Instance?
Which environment variables are absolutely critical in order to run the OUI?
How to delete a column in an existing table?
What are the ways tablespaces can be managed and how do they differ?
How remove data files before opening a database?