• Home
  • oracleofdelphi Answers

Answered Questions

  • Aug 18 2009
    05:52 AM
    6767
    12

    Backup Mode Redo Generation
    • md.sarf

    Why more redos are generated when the database is in begin backup mode?

    ddj1966

    • May 28th, 2010

    When a user managed Hot backup is executed, the tablespace or database has to be placed in backup mode. This informs the Oracle kernel that SCNs should not be updated on the datafile. i.e. the header ...

  • Jul 18 2008
    06:16 AM
    3565
    10

    ARCHIVELOG mode
    • shanthiavari

    Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode?

    Shaikh Ziya

    • Nov 22nd, 2011

    Yes We can Take of Controlfile Online Mode Just
    Fire The Command alter database backup controlfile trace And
    alter database backup controlfile as trace '/Location where u want 2 take backup of ctlfile/';

    sulbha singh

    • Sep 22nd, 2011

    No, we can not take backup of redo log files even database is running in archive log mode because of inconsistency

  • Sep 06 2004
    12:09 PM
    19724
    9

    What are the steps involved in Instance Recovery ?

    Rolling forward to recover data that has not been recorded in data files, yet  has  been recorded  in the on-line redo log, including the contents of rollback segments. Rolling back transactions that have been explicitly rolled back or have not been committed as indicated by the rollback segments regenerated in step a. Releasing any resources (locks) held by transactions in process...

    krishna

    • May 23rd, 2007

    Steps involve in recovery1.Restore backup datafiles2.Recover using Archive log files 3.apply partial backup 4.recover using redo log files

  • Sep 06 2004
    12:09 PM
    9770
    21

    What  are  the  advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

    Complete database recovery from disk failure is possible only in ARCHIVELOG mode.Online database backup is possible only in ARCHIVELOG     mode.

    Vikas

    • Jan 9th, 2018

    Too many !! High Availability (DATAGUARD,RAC), Point in time recovery, Flashback , Audits and many more.....

    hari shankar

    • Aug 5th, 2016

    We can do a lot of things in archivelog mode. 1. Can take Hot backup 2. Complete or incomplete recovery 3. Can manage several policy 4. Take incremental back 5. No need to shutdown or offline or unav...

  • Sep 06 2004
    12:09 PM
    2770
    8

    144. What is On-line Redo Log?

    The On-line Redo Log is a set of tow or more on-line redo files that record all committed  changes  made  to  the  database. Whenever a transaction is committed,  the  corresponding  redo entries temporarily stores in redo log buffers  of  the  SGA  are  written  to  an  on-line  redo  log file by the background ...

    samala

    • Sep 15th, 2007

    Redo logs records all the changes to the database  whether commited or uncommited. How does it know whether you are committing or rolling back till you commit it. Oracle always thinks positively that...

  • Sep 06 2004
    12:09 PM
    4608
    13

    What is Full Backup ?

    A full backup is an operating system backup of all data files, on-line redo log  files  and  control  file  that  constitute  ORACLE  database  and the parameter.