Using SQL commands.
Using SQL*Plus commands.
Using operating system commands.
Using Recover Manager commands.
第1题:
Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()
第2题:
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()
第3题:
You are using Enterprise Manager to schedule backups for your database. Which type of script would begenerated by the backup scheduler()
第4题:
You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup?()
第5题:
You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate? ()
第6题:
You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()
第7题:
Which two are characteristics of user-managed backup and recovery operations?()
第8题:
A company has a policy that states that all servers will be fully backed up on the weekend.Additionally, all changed items will be backed up each night. In the event of a server failure, the administrator wants to be able to fully recover the system using two restore jobs. Which of the following backup levels should be used nightly?()
第9题:
Your database is in ARCHIVELOG mode. On Friday evening, you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager (RMAN) prompt and close the database. On Monday, the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles, HR1.DBF and HR2.DBF, both of which belong to a read/write tablespace named HR. The disk also contains a datafile, USERS.DBF, which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database, you issue the following RMAN commands: RMAN>RESTORE DATABASE; RMAN>RECOVER DATABASE; After successfully executing these RMAN commands, you issue the following statement using SQL*Plus: SQL>ALTER DATABASE OPEN; You receive the following errors when attempting to open the database: ORA-01157: cannot identify/lock data file 10 see DBWR trace file ORA-01110: data file 10: ’D:///USERS.DBF’ What is the cause of these errors?()
第10题:
You issue the following statement: SQL> SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE; You receive the following error: 01578: ORACLE data block corrupted (file# 6, block # 54) ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()