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

Thread: Few questions

  1. #1
    Join Date
    Dec 2002
    Location
    Singapore
    Posts
    27

    Few questions

    hi,
    I would like to know the correct answers for these questions.

    1.you configured automatic archive logging for the database.on the next startup the database runs for a while,but then hangs.After checking the alert log you determine that all the online redologs need archiving
    which step was skipped when you set up automatic archive log?
    A.LOG_ARCHIVE_DEST was not set in the parameter file
    B.LOG_ARCHIVE_START was not set in the parameter file
    C.alter database archivelog; was not executed in MOUNT mode.
    D.LOG_ARCHIVE_MAX processes were not set in the parameter file.
    -----------------------------
    2.you notice that your RMAN scipt used to copy Control file,data file and archived redo log files is performing slowly.Which 2 changes might you want to include in your RMAN script to speed up the COPY commands.(choose 2)
    A.NOCHECKSUM
    B.MAXCORRUPT
    C.CHECK LOGICAL
    D.BACKUP INCREMENTAL
    E.CONFIGURE DEVICE TYPE....PARALLELISM
    ---------------------------
    3.Which 2 statements regarding the control file and RMAN are true?(choose two)
    A.The control file can grow in size
    B.The control file can store RMAN scripts
    C.CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records
    D.The RMAN catalog can exist solely in the control file of the target database
    -----------------------
    ur help will be appreciated
    Thanks
    Gaya
    K.M.Ramakrishnan

  2. #2
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    Homework perhaps? If so, I'm sure your tutor wouldn't appreciate our answering it for you. Do a little research/experimentation to get your answers, please!
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  3. #3
    1: B. Automatic archive logging needs to be enabled.

    2:D sounds right. Incrementals are faster, but you should still do a full occasionally as you need the last full + all intervening incrementals.

    3:D, although with reduced functionality.
    Last edited by jhmartin; 08-30-2006 at 05:26 PM. Reason: Disable smilies

  4. #4
    Join Date
    Dec 2002
    Location
    Singapore
    Posts
    27
    Hi,
    Thanks for the response.For 3 question can i say it as A& C.

    For 2 question can i give it as A & D as giving NOCHECKSUM speeds up the copy process

    For question 1 the database has been already configured for automatic archiving(as said in the first line of the question).Can i say the option as C alter datbase archivelog.

    pls correct me if iam wrong.

    thanks
    gaya
    K.M.Ramakrishnan

  5. #5
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Is your tutor expecting you to give 10g or 9i answers to these questions? Incrementals aren't always faster in versions older than 10g, and only guarteed to be quicker in 10g if you use block change tracking.

    Lesson One: Always specify software version
    Assistance is Futile...

  6. #6
    Join Date
    Oct 2001
    Location
    Toronto, Canada
    Posts
    236
    Regardless of the version, for question #3 - A and C.

    Question #2 - E and A. Maybe D as well if 10g.

    # 1 is no brainer and I agree with the previous answers.
    Leo
    Oracle 8i OCP DBA
    Toronto, Canada

  7. #7
    Join Date
    Dec 2002
    Location
    Singapore
    Posts
    27
    thanks guys for ur inputs !
    K.M.Ramakrishnan

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