online backup

[pras]

Hi everybody,
can anybody tell me how do i take an online backup.If possible pls provide me the step by step procedure.
Right now what i am doing is following the steps given below

1.Execute archive log list from Server Manager. Note value for "Oldest online log sequence." This is the oldest redo log required for using the online backup.

2.Execute alter tablespace name begin backup from Server Manager. This step prepares the tablespace for online backup by freezing the headers in the datafiles for the tablespace.

But the prob is when i issue the above command it is giving me the error
ORA-01123:cannot start online backup;media recovery not enabled.

Then i enabled the follo in init.ora file
log_archive_start = true
log_archive_dest = c:\orant\database\pras
log_archive_format = "%ORACLE_SID%%S.%T"

Still it is giving me the same error i also tried
alter database archivelog;

pls help,thanking u all in advance..

pras

[hrishy]

hi there

for your parameters to take effect you will have to bounce back your database.for this go to servermanger and sty

svrngrl>shutdown immediate
svrmgrl>startup open

and now dow alter tablespace begin backup
this puts the datafiles belonging to the tablespace in hotbackup mode.go to the operating system level and take a copy.

hth
hrishy

[padmam]

Hi,

I understand first you DB was in No Archive Log Mode.

So follow this steps to take hot back up.

1)Make a clean shutdown or (shutdown or shutdown immediate).

2)Mount the DB.

3)Alter database archivelog(issue this command this will make the db change to archive mode)

4)Next shutdown the DB and take a cold backup.

5)Before startup set the 3 init parameters enabled.
i)log_archive_start = true
ii)log_archive_dest_1= "location=e:\Oracle\oradata\bit\archive"
iii)log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

and ensure to save the init parameter file.

5)Now startup open state

6)Issue the command ===Alter tablespace begin backup

Now it will be ok

Cheers

Padmam

Originally posted by hrishy
hi there

for your parameters to take effect you will have to bounce back your database.for this go to servermanger and sty

svrngrl>shutdown immediate
svrmgrl>startup open

and now dow alter tablespace begin backup
this puts the datafiles belonging to the tablespace in hotbackup mode.go to the operating system level and take a copy.

hth
hrishy

[padmam]

Hi,

I understand first you DB was in No Archive Log Mode.

So follow this steps to take hot back up.

1)Make a clean shutdown or (shutdown or shutdown immediate).

2)Mount the DB.

3)Alter database archivelog(issue this command this will make the db change to archive mode)

4)Next shutdown the DB and take a cold backup.

5)Before startup set the 3 init parameters enabled.
i)log_archive_start = true
ii)log_archive_dest_1= "location=e:\Oracle\oradata\bit\archive"
iii)log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

and ensure to save the init parameter file.

6)Now startup open state

7)Issue the command ===Alter tablespace begin backup

Now it will be ok

Cheers

Padmam

Originally posted by hrishy
hi there

for your parameters to take effect you will have to bounce back your database.for this go to servermanger and sty

svrngrl>shutdown immediate
svrmgrl>startup open

and now dow alter tablespace begin backup
this puts the datafiles belonging to the tablespace in hotbackup mode.go to the operating system level and take a copy.

hth
hrishy

[rogerF]

Download the scripts for hotbackup from:

http://www.backupcentral.com/free-ba...DatabaseBackup

If you examine the scripts you will learn a ton. You don't have to use their script- just see how it works. The Oracle recovery guide(available on the net) has all the commands to get started.

All this info is easily found all over the net.

-Roger