backup script

[sri_dba]

Hi DBAs,

is there any script to backup the database in specific time for everyday.

I mean a batch file.

pls let me know if anyone has any script for this.

Thanx in advance.

[anandkl]

Which version of oracle and what OS r u using.

regards
anandkl

[sri_dba]

OS - Win NT
DB - 8.1.5 Production.

Thanx

[anandkl]

You can use RMAN,
Have u used RMAN earlier.IF not, please look at this URL

http://download-west.oracle.com/docs...rma.htm#438923

regards
anandkl

[sri_dba]

Hi Anand,

Thanx for ur info. I never used RMAN backup.
Is it easy to configure,, bcoz i went through some materials
but still i am bit confused on this.

I am using import and export utility only.

my basic doubts on RMAN.
1. Will it take a lot of sapce in DB.
2. How to bring RMAN prompt.
3. Should i create any separate tablespace for RMAN.

It would be great if u explian something abt RMAN.
I am really interested to know and work with RMAN.

Thanx in advance.

[anandkl]

Ok,
How big is your DB.For RAMN, you need to create a seperate DB, so obviously you need to create tablespaces for them.Its always better to created RMAN repository(DB) in a different m/c.Then you need to register the database which ur going to backup with RMAN.
At the commond prompt type
rman target / nocatalog

u will get RMAN prompt

Please check the same URL for more info

regards
anandk

[sri_dba]

Thanx Anand.

I got some idea abt RMAN and I will go throught the URL.

The doubts are...

1.DB to be created in the same server which is already running or
it should be in separate system.

2. Can i store my backup files into tap or other backup devices.

Please clear above mentioned doubts.

Thanx in advance.

[anandkl]

Create RMAN repository in another m/c, becuase if u create RMAN repository in the same m/c as the DB and if there is any disk failure you may not be able to recovery as the RMAN will also fail

U can store ur back either in TAPE or HDD

regards
anandkl

[sri_dba]

Thanx a lot Anand.

I will try this.