-
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
-
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.
-
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 04:26 PM.
Reason: Disable smilies
-
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
-
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...
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|