DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Hot backups

  1. #1
    Join Date
    Aug 2000
    Posts
    32

    Question Hot backups

    Hello,

    I am a new DBA for an existing database which is running in archive mode and I cannot shut it down to take a cold backup.

    And we lost the cold backup that old DBA has taken when he turn database into archive mode.

    Old DBA set up hot backups of all data files and control file every alternative day. This backup script stops archive log, deletes all archive log files and starts archive log just before hot backups. We have archive log files from just before hot backups are performed.

    Now I want to take these hot backup data files, control file and archive log files into another system and bring up the database...basically wants to test these backups.

    I would appreciate if anyone can give me a feasible method to test my backups.

    Thank you

  2. #2
    Join Date
    Aug 2001
    Posts
    267
    Just forget about your old DBA. Come with your own scripts for hot backups. Same site has some hot backup scripts for reference.

    http://www.dbasupport.com/oracle/scr...ry/Hot_Backup/
    Raghu

  3. #3
    Join Date
    Aug 2000
    Posts
    32
    Hot backups that old DBA took were genuine. Would I be able to bring up database on another system with these hot backups? I am sure that I need cold backups too in addition to these hot backups. But we lost them.

  4. #4
    Join Date
    Aug 2001
    Posts
    267
    No, you do not need cold backup to restore to another box. Even with hot backups ( I am assuming he got all datafiles,control file to trace, ness. archived log files) you can restore DB to another server provided you have same binaries(version) running on another server.
    Raghu

  5. #5
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    Re: Hot backups

    Originally posted by Vimala
    Hello,
    And we lost the cold backup that old DBA has taken when he turn database into archive mode.
    You can do your own hot backup too,
    aside from the link that raghud stated, here is one quick script
    of DOING A HOT BACKUP in SOLARIS(you can edit it,according to your needs) from one machine to another:
    DECLARE
    WS_TBS NUMBER;
    VAR_TBS VARCHAR2(25);
    tbs_nam varchar2(25);
    file_nam varchar2(50);
    Cursor c1 is select tablespace_name, file_name
    from dba_data_files order by tablespace_name;
    BEGIN
    VAR_TBS := 'XXXXXXXXXXXX';
    WS_TBS := 1;
    OPEN c1;
    LOOP
    FETCH c1 INTO tbs_nam, file_nam;
    IF VAR_TBS = tbs_nam THEN
    DBMS_OUTPUT.PUT_LINE('host rcp -pr '||file_nam||' SERVER02:'||file_nam);
    ELSE
    begin
    IF WS_TBS = 0 THEN
    DBMS_OUTPUT.PUT_LINE('ALTER TABLESPACE '||VAR_TBS||' END backup;');
    END IF;
    DBMS_OUTPUT.PUT_LINE('ALTER TABLESPACE '||tbs_nam||' begin backup;');
    DBMS_OUTPUT.PUT_LINE('host rcp -pr '||file_nam||' SERVER02:'||file_nam);
    VAR_TBS := tbs_nam;
    WS_TBS := 0;
    end;
    END IF;
    EXIT WHEN c1%NOTFOUND;
    END LOOP;
    CLOSE c1;
    DBMS_OUTPUT.PUT_LINE('ALTER TABLESPACE '||VAR_TBS||' END backup;');
    END;

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    You can restore hot/cold backup to any server, just with hot backups most probably is you need to recreate controlfiles if the PATHs where you are gonna store the datafiles are different then that would imply resetlogs when you recover and open the database

  7. #7
    Join Date
    Aug 2000
    Posts
    32
    Can someone write me a procedure to bring up database on another system (with same oracle binaries) with this type of hot backup.

    I have all data files hot backups, control file to trace backup and archive log files.

    Should I restore redo log files or create them?

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    recreate
    Jeff Hunter

  9. #9
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: Hot backups

    Originally posted by Vimala
    This backup script stops archive log, deletes all archive log files and starts archive log just before hot backups.
    I don't like this.

    What if your last backup tape turns out to be unreadable? You can't use the last-but-one because you don't have the archivelogs.

    I'd keep the archivelogs for at least a week in this case.

  10. #10
    Join Date
    Aug 2001
    Posts
    267
    Can someone write me a procedure to bring up database on another system (with same oracle binaries) with this type of hot backup.

    __________________


    You have to give your pay check then we can ??

    I am just joking .. Please search in metalink there are so many scripts...
    Raghu

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