OraFAQ Forum: Backup & Recovery » need a script to backup ..??

Home » RDBMS Server » Backup & Recovery » need a script to backup ..??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

need a script to backup ..?? [message #136665]

Fri, 09 September 2005 08:03

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hai all,

we are using RMAN for backup.we need a clean script to backup whole database including control files and archived logs.can u plz suggest some useful script to do the same??plz help out.

regards
bala

Report message to a moderator

Re: need a script to backup ..?? [message #136666 is a reply to message #136665]

Fri, 09 September 2005 08:11

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Every backup site is different.
SO, you need to comeup with your own backup script.
Honestly,
backing up the database with RMAN is the easiest thing to do
( whether you use catalog or not).
But recovering the backup ( older backups), maintaining and reliablity is more important.
RMAN can provide it, no doubts about it. But only if you can understand it.

Please start with RMAN documentation.

TO backup, all you need to do is

RMAN> backup database plus archivelog;

>> including control files
control files are automatically backep and you can also set CONTROL FILE AUTOBACKUP.
See here

http://www.orafaq.com/forum/m/135192/42800/#msg_135192

and spend some quality time with
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/toc.htm

Report message to a moderator

Previous Topic:	Exp/Imp Problem - Urgent Thanks Plz
Next Topic:	rman retention policy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 19:21:25 CDT 2024