You have lost all members of your current redo log file group. You issue this query: SQL select * from v$log;  GROUP#    SEQ#     BYTES        ARC STATUS            FIRST_NAME  1                  60           153600        NO INACTIVE            01-03-09:19:34  2                  61           153600        NO CURRENT            01-03-09:19:50  You then perform an incomplete recover. You receive this message: ORA-00279:  change 309141...03/09/01 19:50:14 Needed for thread 1  ORA-00289: suggestion : /disk1/archive/arch_61.rdo ORA-00280: change 309043 for thread 1 is in  sequence #61 Specify log: {=suggested | filename | AUTO | CANCEL} How should you respond to this message?()A、Enter the keyword AUTO.B、Enter the keyword CANCEL.C、Press the Enter or Return key.D、Enter the filename ’/disk1/archive/log2a.rdo’.

You have lost all members of your current redo log file group. You issue this query: SQL> select * from v$log;  GROUP#    SEQ#     BYTES        ARC STATUS            FIRST_NAME  1                  60           153600        NO INACTIVE            01-03-09:19:34  2                  61           153600        NO CURRENT            01-03-09:19:50  You then perform an incomplete recover. You receive this message: ORA-00279:  change 309141...03/09/01 19:50:14 Needed for thread 1  ORA-00289: suggestion : /disk1/archive/arch_61.rdo ORA-00280: change 309043 for thread 1 is in  sequence #61 Specify log: {=suggested | filename | AUTO | CANCEL} How should you respond to this message?()

  • A、Enter the keyword AUTO.
  • B、Enter the keyword CANCEL.
  • C、Press the Enter or Return key.
  • D、Enter the filename ’/disk1/archive/log2a.rdo’.

相关考题:

Excuse me, sir. I've lost my watch. Do you have ___ time? A.theB.aC.anD.bland

—I lost my money.—_________ .A.Oh, you will be more carefulB.Oh, you must be more carefulC.Oh, you would be more carefulD.Oh, you should have been more careful

If you go into the forests with friends,stay with them. If you don't,you may get lost.If you do get lost,this is what you should do.Sit down and stay where you are.'Don't try to find your friends. Let them find you. You can help them to find you by staying in one place.There is another way to help your friends or other people to find you. Give them a signal (信号) by shouting or whistling(吹口哨) three times. Stop. Then shout or whistle three times again. Any signal given three times is a call for help.Keep on shouting or whistling,always three times'together. When people hear you,they will give two shouts or two whistles. When a signal is given twice,it is an answer to a call for help.lf you don-t think that you will get help before night comes,try to make a small room with branches(树枝).What should you do if you get hungry or need to drink water? You would have to leave your little branch room to look for something to eat and drink. Don't just walk away. Drop small branches as you walk so that you can find your way back.The most important thing to do when you are lost-stay in one place.( )16. If you get lost in the forests,you should walk everywhere to find your friends as soon as possible.

You are planning to anchor in an area where several anchors have been lost due to fouling.As a precaution,you should ______.A.anchor using both anchorsB.anchor with scope of 8 or more to 1C.use a stern anchorD.fit a crown strap and work wire to the anchor

Which of the following words in bold is pronounced with a falling tone?A.Do you have any specials?B.You're kidding ... he has lost his job?C.When will we have the exam, today or tomorrow?D.The flat has a kitchen, a living room, two bedrooms, and a bath.

You have lost your cellphone charger at the hotel where you stayed during your vacation.Write a letter to the hotel aboul your item left behind.You should write about 100 words neatly on the ANSWER SHEET Do not sign your own name.Use"Li Ming"instead.Do not write your address

It is not until you have lost your health()you know its value.AuntilBwhenCwhatDthat

For self elevating and column stabilized units, is 100% lifeboat capacity acceptable for the MODU Code?()A、No, the MODU Code requires that there should be 100% capacity available when all lifeboats in one location are lost or rendered unusable, or all the lifeboats on any one side, or any one corner of the unit are lost or rendered unusable. Generally, this requirement is met by applying 2 x 100% lifeboat capacitiesB、Yes, the lifeboats should be able of carrying the number of personnel onboard the unit., i.e. 1 x 100%C、Yes, provided you have additional liferaft capacityD、You don’t need lifeboats as long as you have 2 x 100% liferaft capacity

It is not until you have lost your health()you know its value.A、untilB、whenC、whatD、that

At database startup, you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes?()A、 Start the database in OPEN mode, and create a new index tablespace.B、 Start the database in OPEN mode, and drop the lost index tablespace from the database.C、Start the database in MOUNT mode, create a new index tablespace, and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode, drop the lost index tablespace from the database, open the database, and create a new index tablespace.

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager (RMAN) to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.

As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?()  A、 Shut down the databaseB、 Clear the online redo logC、 Back up the databaseD、 Checkpoint the databaseE、 Call Oracle support

You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?()  A、 register databaseB、 recover catalogC、 load backupsetD、 synch metadataE、 catalog start with

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

单选题It is not until you have lost your health()you know its value.AuntilBwhenCwhatDthat

单选题But for his courage, the battle ______ .Awas lost Bwill be lost Cwould lose Dwould have been lost

单选题You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?()A register databaseB recover catalogC load backupsetD synch metadataE catalog start with

单选题You are underway and pass by a lighthouse. Its light,which was white since you first sighted it,changes to red. This means().Athe light is characterized as alternately flashingBthe lighthouse has lost power and has switched to emergency lightingCit is the identifying light characteristic of the lighthouseDyou have entered an area of shoal water or other hazard

单选题For self elevating and column stabilized units, is 100% lifeboat capacity acceptable for the MODU Code?()ANo, the MODU Code requires that there should be 100% capacity available when all lifeboats in one location are lost or rendered unusable, or all the lifeboats on any one side, or any one corner of the unit are lost or rendered unusable. Generally, this requirement is met by applying 2 x 100% lifeboat capacitiesBYes, the lifeboats should be able of carrying the number of personnel onboard the unit., i.e. 1 x 100%CYes, provided you have additional liferaft capacityDYou don’t need lifeboats as long as you have 2 x 100% liferaft capacity

单选题Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database?()A 13:00 on Tuesday.B 15:00 on Tuesday.C Up until the last available archived redo log on Sunday.D To any point; all the redo should still be available in the online redo logs.E The database is not recoverable.

单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure, you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time?()A Restore all the datafiles from the backup.B Restore only the lost datafile from the backup.C Restore all the datafiles for the lost tablespace from the backup.D Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.

单选题I lost your address, otherwise I _____ you long before.Ahad visitedBhave visitedCwould have visitedDshould visit

多选题Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario?()AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.

单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file?()ARestore all the data files and open the databaseBCreate the data file and performtablespacerecoveryCNo need to restore any file, just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery

单选题As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?()A Shut down the databaseB Clear the online redo logC Back up the databaseD Checkpoint the databaseE Call Oracle support

单选题Telephone enquiry Clerk: Lost property department. Can I help you?  Phone caller: ______ I left it on the "Margate Mermaid" when we cross from Olsten yesterday morning.AI want you help me find my lost camera.BI wonder if you have a camera of mine.CDo you think if you have a camera of mine?DI doubt if you could help me find my lost camera.

单选题You are planning to anchor in an area where several anchors have been lost due to fouling.As a precaution,you should().Aanchor using both anchorsBanchor with scope of 8 or more to 1Cuse a stern anchorDfit a crown strap and work wire to the anchor

问答题Practice 2You had a small fire in your room. Write a letter to your landlord Mr. Smiths, and tell him:(1) The situation of what has happened.(2) What property you have lost.(3) The recommendations you provide.Do not sign your own name at the end of the letter. Use “Li Ming” instead. You do not need to write the address.