DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: hot backup instructions

  1. #1
    Join Date
    Feb 2001
    Posts
    51

    Smile



    Hi there,

    Does anyone here have or used some kind of a documentation on doing a hot backup step-by-step?

    I'm new at this stuff, and want to try some. I rather not trial by error, I rather get an instruction from an expert and work off that.

    I appreciated if someone can help me with this venture.


    thanks

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Wink

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=6587[/url]

    Better not be 'looser' in database administration. Nothing much happens, Just Nightmares...

    [Edited by sreddy on 02-22-2001 at 07:36 PM]
    Reddy,Sam

  3. #3
    Join Date
    Feb 2001
    Posts
    51

    Wink

    cool

    thanks

  4. #4
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    This is Rohit Nirkhe from India.U want some help regarding doing hot backup.
    Hot backup is done when ur database can't be shutdown.It is meant for databases running 365*24*7 days.
    This kind of backup requires ur database in archivelog mode.If ur database is in noarchivelog mode(default),shutdown the database with normal,immediate,transactional.Dont use abort option;
    SVRMGR> shutdown immediate/normal/transactional

    Change ur init.ora parameters for putting ur database in archive log mode.
    In init.ora
    LOG_ARCHIVE_START=true (Arch process will
    automatically archive ur log
    files)
    LOG_ARCHIVE_DEST=dest (destination where ur
    archived log files will be
    kept)
    LOG_ARCHIVE_FORMAT="%s.arc" (format for arch files)

    Startup ur database in mount state and
    SVRMGR > startup mount pfile=<parameter file>

    SVRMGR> alter database archivelog (changes ur database
    into archivelog and
    reflects ur control file)
    SVRMGR > alter database open

    U can find out the status of it from v$database view.
    After putting ur database into archivelog mode ,all ur previous backup taken when ur database was in noarchivelog mode has become obsloete.
    To take backups for ur archivelog database,put each tablespace in ur backup mode and then take the backup.

    SVRMGR> alter tablespace SYSTEM begin backup;
    SVRMGR> host copy c:\system.dbf a:
    SVRMGR> alter tablespace SYSTEM end backup;

    Perform the above steps to backup all ur tablespaces one-by-one.At the same time also backup the archived log files which were getting generated while the backup was going.This backup of tablespace files + archived log files will be applied in case of any failure to the database. If u have any kind of doubts please contact me at this email id
    rohitsn@hotmail.com



  5. #5
    Join Date
    Nov 2000
    Posts
    212
    a time ago I read some article about uniquenes of RMAN in that is allows to make hot backups ant there was some statements about

    alter tablespace SYSTEM begin backup;
    SVRMGR> host copy c:\system.dbf a:
    SVRMGR> alter tablespace SYSTEM end backup;

    being possibly wrong approach if some conditions regarding data block buffers size and OS block buffer size are met.

    Anyone has more about it?


  6. #6
    Join Date
    Nov 2000
    Posts
    89
    Backups are a big enough pain in the ass that even if you get a good script you should figuire out whats happening.

    Get a good book:

    Oracle8i DBA Bible
    [url]http://www.idgbooks.com[/url]

    is well worth the 40 bucks if you are being payed to keep that database running.

    Oracle 8i Backup and Recovery Handbook: Implement Sound Data Protection Techniques
    by Rama Velpuri, Anand Adkoli, George Williams

    will be a book that only deals with backup.

    To get started quick, get the free hotbackup scripts from backup central:

    [url]http://www.backupcentral.com/toc-free-backup-software.html[/url]

    These scripts are just about ready to go out of the box.

    If your broke read the online oracle8i backup guide that comes on the CDROM. It explains the gruesome details of the alter this and that statements.

    Cheers,

    Roger

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    alter tablespace SYSTEM begin backup;
    SVRMGR> host copy c:\system.dbf a:
    SVRMGR> alter tablespace SYSTEM end backup;

    this is a wrong approach for NT/2000 since to copy datafiles in NT/2000 during hot backup you have to use OCOPY

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