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: {
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’.
您可能感兴趣的试卷
你可能感兴趣的试题
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.
There was only one data file on this disk; it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available?()
A.Only bring the tablespace back online.
B.Only recover the tablespace and then bring the tablespace back online.
C.Shut down the database, recover the data file and then start up the database.
D.Issue the ALTER DATABASE RENAME FILE command, recover the tablespace, and then bring the tablespace online.
E.Recover the tablespace, issue the ALTER DATABASE RENAME FILE command, and then bring the tablespace online.
A.Recovery is initiated using SQL*Plus.
B.Database files are backed up using SQL commands.
C.Database files are backed up with Recovery Manager.
D.Database files are restored using Recovery Manager.
E.Database files are backed up using operating system commands.
A.SQL*Plus
B.Oracle Net
C.Two-Task Common (TTC)
D.Oracle Protocol Support (OPS)
A.Load data from a disk, tape, or named pipes.
B.Load data into an Oracle database using DML statements.
C.Extract, reorganize, and insert data within an Oracle database.
D.Load data from external files into tables in an Oracle database.
E.Load data into an Oracle database using operating system commands.
F.Load data directly from a non-Oracle database to an Oracle database.
A.After a shutdown abort.
B.When recovering to an SCN.
C.When recovering until a specific time.
D.When a required archived log is missing.
A.Retain the data file backup for 7 days.
B.Run the recover process every 7 days.
C.Destroy the physical backup files every 7 days.
D.Destroy the physical backup files older than 7 days.
E.Retain one backup of each data file for at least 7 days.
F.Keep the catalog information in the control file for 7 days.
You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to recover the data files but discover that the archived redo log file with sequence number 45, which is needed to perform complete recovery, is invalid. You then begin incomplete recovery-You receive this prompt:
ORA-00279:change 309012...03/09/01 11:33:56 needed for thread ORA-00289: suggestion :
/disk1/archive/arch_45.rdo ORA-00280: change 309012 for thread 1 is in sequence #45 Specify log:
{
What is the correct response?()
A.Enter the keyword AUTO.
B.Enter the keyword CANCEL.
C.Press the Enter or Return key.
D.Provide the filename ’/disk1/archive/arcg_46.rdo’
A.COPY
B.BACKUP
C.CHANGE
D.DELETE
E.CATALOG
You issue these LSNRCTL commands:
LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02
What is the result of issuing these commands?()
A.A listener named LISTENER is started.
B.A listener named LISTENER01 is started.
C.A listener named LISTENER02 is started.
D.The START command fails and no listener is started.
A.RESTORE DATAFILE ’/DISK2/user_data01.dbf’
B.RESTORE DATAFILE ’/DISK3/user_data01.dbf’
C.SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’
D.SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
最新试题
Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()
Which of the following commands must be issued to remove a stored script from the recovery catalog?()
Which one of the following files includes the parameter NAMES.DIRECTORY_PATH(hostname)?()
Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database?()
The three tasks shown have been completed in order to configure a naming method: Task 1: Installed on server and client: Oracle Net Services, TCP/IP, TCP/IP protocol adaptor Task 2: Started default listener on port 1521 Task 3: Added global database name to the listener.ora file. Which naming method was configured?()
After a number of days set by the parameter CONTROL_FILE_RECORD_KEEP_TIME, the information in the control file is overwritten by RMAN. What is this parameter’s default value?()
Which server stack communication layer corresponds to the client application layer in a distributed environment?()
Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?()
Which of the following environment variables specifies a non-default location for the listener configuration file?()
Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users?()