• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4727
  • Last Modified:

Oracle backup by Oracle SQl DEVELOPER

In MS SQL server, backup file is .bak. If we want to restore it, we just need to take the .bak file

I have the following questions

1. Now I want to do the same in Oracle. Does Oracle have the similar single file we can take for restore process?

2. Can Oracle use or accept .bak file?

3.
I have Oracle 11g in Windows system
I have Oracle SQL developer. I use the migration tool to migrate MS SQL 2008 database to Oracle 11g. I want to back up the migrated database.

I use DBA->Create Disk backup,
I don't know how to do the next step

Anyone has experience to do this?
0
wasabi3689
Asked:
wasabi3689
  • 2
  • 2
1 Solution
 
wasabi3689Author Commented:
see the attached screen shot.

Here is my backup.rman file content

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
RUN {
ALLOCATE CHANNEL SQLDEV_DISK_BACKUP DEVICE TYPE DISK;
RECOVER COPY OF DATABASE WITH TAG 'ORA_SQLDEV_LEVEL_0';
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE COPIES=1 FOR RECOVER OF COPY WITH TAG 'ORA_SQLDEV_LEVEL_0' DATABASE;
}
ALTER DATABASE OPEN;
SQL "BEGIN DBMS_SCHEDULER.END_DETACHED_JOB_RUN(''SQLDEV$JOB_1344637216375'', 0, null); END;";


How do I do "Please copy this file onto the server and run it using:....". Please instruct the detail to me if you know.
CAP-Migration-Oracle-Backup.JPG
0
 
Geert GruwezOracle dbaCommented:
wasabi3689
you may want to warn the user, it's going to stop the database

not something you would want in a production database ...

the backup by rman is saved to a file.
extension can be anything, it's just a file, you could just as well name it .bak

BACKUP INCREMENTAL LEVEL 0 DATABASE;
check the rman backup reference for taking a backup:
http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta009.htm#sthref141
0
 
wasabi3689Author Commented:
This is not a production backup.

Geert_Gruwez

I don't understand your comment.

the backup run by rman is saved to xxx.rman. I put the script above. But, xxx.rman is not a backup file, right?
0
 
OP_ZaharinCommented:
1- yes there is similar backup approach called EXP or EXPDP (export datapump) tool to backup the database or certain user schema into a dump file with .dmp extension. to import the dump file to other Oracle database, you can use IMP or IMPDP. this dmp file however is oracle propritery format therefore can only use within oracle.

2. I'm not sure what is the formatting of the bak file. if its a comma delimeter text file, yes there is a way to load the file into Oracle using various tool.

3. there is another approach to backup and restore your database using the EXP/IMP approach as i mention in #1. here is the steps:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/SQLdev3.0_Import_Export/sqldev3.0_import_export.htm
0
 
Geert GruwezOracle dbaCommented:
>> xxx.rman is not a backup file, right
every file is a backup file ...

microsoft let you buy their windows product (or set of files)... why ?
so you can be their backup for windows
>> they will come knocking on your door if you have the last windows when all their servers fail

the idea of backup is very important
in general it is a copy of a other piece of data or file

you didn't specify what exactly you want to backup
a single tablespace, the whole database, a single record in a single table ???

and ... the idea also contains they way data is restored
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now