What is the following step used for?1) Edit the CONTROL_FILES parameter in the database initialization parameter file to delete the old control file name.

Creating Additional Copies, Renaming, and Relocating Control Files

What is the following step used for?1) Edit the CONTROL_FILES paramete

1.	What is the following step used for?1) Edit the CONTROL_FILES parameter in the database initialization parameter file to delete the old control file name.
A.	Creating Initial Control Files
B.	Creating Additional Copies, Renaming, and Relocating Control Files
C.	Creating New Control Files
D.	Dropping Control Files
Answer» E.

Discussion

No Comment Found

Related MCQs

In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?
What are the following steps used to do?1) Make a list of all datafiles and redo log files of the database2) Back up all datafiles and redo log files of the database3) Start up a new instance, but do not mount or open the database
You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2, with one device each. In the parameter file of the production database, the following parameters have been specifiedDB_CREATE_ONLINE_LOG_DEST_1 = '+dg1'DB_CREATE_ONLINE_LOG_DEST_2 = '+dg2'What would be the impact of this setting?
The SQL*Plus STARTUP command parameters are interpreted by ASM. Which parameter Issues a SHUTDOWN ABORT to the ASM instance before restarting it?
Which way can you recover a control File using a current copy from the following,Edit the CONTROL_FILES parameter in the initialization parameter file to replace the bad location with the new location?CONTROL_FILES = (/u01/oracle/prod/control01.ctl,/u02/oracle/prod/control02.ctl,/u04/oracle/prod/control03.ctl)
Which errors can be encountered by Troubleshooting after Creating Control Files after issuing the CREATE CONTROLFILE statement?
Which file allows a no default parameter file to be used to configure the Instance?
Which initialization Parameter Specifies the default disk group location to create the following files?1) Redo log files2) Control files
Which view in an ASM instance contains one row for every ASM file in every disk group mounted by the ASM instance in a DB instance that contains no rows?
In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups, DGROUP1, is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective. DROP DISKGROUP dgroup1 EXCLUDING CONTENTS; What would be the result of this command?

What is the following step used for?1) Edit the CONTROL_FILES parameter in the database initialization parameter file to delete the old control file name.

Discussion

No Comment Found

Related MCQs

Reply to Comment