Backup Database

[Cristina]

Hallo
i am a beginner into Oracle Technologies.I would like to make backup
of my database,but i dont know how.Is there tools?Can i schedule the
backup plan?
thanks
Cristina

[Hans Forbrich]

Re: Backup Database

Cristina wrote:

Hallo
i am a beginner into Oracle Technologies.I would like to make backup
of my database,but i dont know how.Is there tools?Can i schedule the
backup plan?
thanks
Cristina

Several questions need to be answered before we can tell you how ...

1) WHY do you want to back this up?
2) Operating system, including version?
3) Database version?
4) Are you familiar with Oracle's online documentation?

The first question is indeed somewhat cheeky - but also quite serious. We
need to understand

- whether you want to back up the production (as comnpared to developement,
test, education, etc.) environment;

- whether the backup is for recovery or for legal archive or other purpose;

- whether it's for a warehouse or OLTP environment;

- whether you can afford to lose transactions.

This, and a lot more, is introduced in the Backup and Recovery Concepts
manual found at the online documentation.

Directions to get there: http://docs.racle.om (go to your version and then
to the 'View Library' link). Look at the 'List of Books' link or the
'Books' tab and scroll down to the "Backup and Recovery Concepts" entry.

HTH
/Hans

[s.kapitza]

Re: Backup Database

mcrisf@hotmail. com (Cristina) wrote in message news:<3415b937. 0406200743.2a50 5bb1@posting.go ogle.com>...

Hallo
i am a beginner into Oracle Technologies.I would like to make backup
of my database,but i dont know how.Is there tools?Can i schedule the
backup plan?
thanks
Cristina

hello,

the beginner way of backup is,

- to shutdown the database
- backup the server
- startup the database

the beginners first mistake is

- startup the database before the backup finishes
(and crashing the database)

so beware to sync both in a reliable way.

also lookup

- archivelog mode
- logical backup

regards

s.kapitza

[cs]

Re: Backup Database

Hi,


There are 2 type of back-ups Physical and logical

Logical backup ---- this is done using tools like export, import.

Physical backups is of two types
---- Hot backup --backup performed when the database is up and running.
steps involved in making hot backup.
assumes that you have privileges to perform backups of objects.
check to see in which mode the database is in

sys@ORCL$ archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oradata/orcl/archive
Oldest online log sequence 324
Next log sequence to archive 327
Current log sequence 327

Now before performing the hot backup put the tablespaces in backup mode.

sys@ORCL$ alter tablespace begin backup;

Now use the copy command to copy the datafile pertaining to that tablespace
to a backup location.

if you are using windows you can go to oradata folder and copy the file.
or you can also do it from sqlplus

sys@ORCL$host /cp C:\ORACLE\ORADA TA\SYSTEM01.DBF C:\ORACLE\BACKU P\SYSTEM01.DBF

once the cp command is done

Issue the following command to bring the tablespace out of backup mode.
sys@ORCL$ alter tablespace end backup;

steps involved in cold backup.

1. shutdown the database.
2. go to the oradata folder and copy the datafiles to new location
3. startup the database.

To perform logical backups
you have to have privileges to export and import the objects

The command to perform export is as follows

$exp scott/tiger@orcl
this will generate a dump file expdat.dmp
save the expdat.dmp file and when necessary you can
import the dump file.

to see more info about export tool
$exp help=y

hope this info helped you

sekhar.