cancel
Showing results for 
Search instead for 
Did you mean: 

oracle backup

sh5490
Frequent Advisor

oracle backup

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
5 REPLIES
Volker Borowski
Honored Contributor

Re: oracle backup

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
Honored Contributor

Re: oracle backup

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven E. Protter
Exalted Contributor

Re: oracle backup

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
sh5490
Frequent Advisor

Re: oracle backup

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
Honored Contributor

Re: oracle backup

hi Shabir,

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


kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)