oracle backup

[sh5490]

1) we are running oracle 10g database on hp ux 11.23 how we can automate the export script
like exp username/passwd file='/backup/abc.dmp
owner='finance' log='/backup/abc.log'

if i save this in a script file like imp.sh
how this file can be executed and scheduled time based
pls help

thanks
shabir

[Volker Borowski]

Hi,
an export is not a backup.
Keep that in mind.

What about putting your command in a script
and run it using cron ?

Volker

[Yogeeraj_1]

hi Shabir,

As mentioned by Volker above, EXP/IMP is not considered as a backup nowadays!

Unless you database is not mission-critical, you may try to look into RMAN.

Since you are already on Oracle 10g, you can easily use the Oracle Enterprise Manager (OEM) Database Control to confirm RMAN and schedule it to run at regular interval.

if you need any further assistance, please do let us know.

kind regards,
yogeeraj

[Steven E. Protter]

Shalom,

You can't do a full restore off an export.

You can restore a table or over-write selected data with an import.

A real backup means either shutting the database and backing up the db files with the OS or using a hot backup method that gets a clean copy of the data in backup mode.

SEP

[sh5490]

we use imp/exp for taking user level backup

like in windows we will put these line in .bat file and using
Scheduled task of OS we are automate the process.

How this can be achieved in hp ux

thanks

shabir

[Yogeeraj_1]

hi Shabir,

please refer to your other post at:
http://forums12.itrc.hp.com/service/forums/questionanswer.do?threadId=1216203


kind regards
yogeeraj