單項(xiàng)選擇題

When performing an online backup，what is the proper order of the following steps？（）
a. Issue the alter database end backup command.
b. Back up the archived redo logs.
c. Issue the alter database begin backup command.
d. Back up the database files.
e. Determine the beginning log sequence number.
f. Determine the ending log sequence number.
g. Force a log switch with the alter system switch logfile command.

A.a， b， c， d， e， f， g
B.c， d， a， b， e， g， f
C.f， d， b， g， a， c， e
D.e， c， d， a， g， f， b
E.a， f， b， g， e， c， d

你可能感興趣的試題

Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）

A. Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.
B. Just back up the database datafiles without shutting down the database.
C. You will have to wait until you can shut down the database to perform the backup.
D. Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
E. Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup

多項(xiàng)選擇題

As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（）
SQL> select group_number， name， state from v$ASM_DISKGROUP；
GROUP_NUMBER NAME STATE
0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED

A. The DGROUP1 disk group was unmounted by another DBA.
B. A datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
C. One of the redundant disks （DGROUP1） has been lost in a disk group.
D. This query has no meaning in an ASM instance.
E. A disk associated with a disk group was discovered after the ASM instance initially opened.

你可能感興趣的試題

Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）

As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL> select group_number， name， state from v$ASM_DISKGROUP； GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTED

Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）

As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（）
SQL> select group_number， name， state from v$ASM_DISKGROUP；
GROUP_NUMBER NAME STATE
0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED