online backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: online backup

  1. #1
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    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


  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Smile

    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

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution

    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
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  4. #4
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution

    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
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  5. #5
    Join Date
    Nov 2000
    Posts
    89
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width