Results 1 to 4 of 4

Thread: Backup of Database

  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    85

    Exclamation Backup of Database

    I have heard about backups of database. I wanted to know whether people take backups of table space also while doing maintenance of database. If so why is that taken? Can someone tell me about this interesting fact.


  2. #2
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: Backup of Database

    Backups are taken for "Database Recovery". With out backups you can't recover database.


  3. #3
    Junior Member
    Join Date
    Oct 2006
    Answers
    24

    Re: Backup of Database

    Backup of database can be taken in hot mode or cold mode in cold backup the database is shutdown properly and then backup of datafiles and controlfile is taken, but in hot bakup the database has to be in archivelog mode and then backup of tablespaces are taken one by one by giving the command alter tablespace T1 begin backup;
    then all the datafiles concerned with this tablespace is copied. after that we have to meke the tablespace into end backup mode, and all arhived log generated in this process is also copied so that recovery is possible.
    backup of tablespace is taken to safeguard in case of media failure occured.


  4. #4
    Contributing Member
    Join Date
    May 2006
    Answers
    85

    Re: Backup of Database

    Ohh so there are types of modes in backups of database.Very interesting to know.Is it that all only a database administrator takes backups of database in both the modes.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact