0 Remove / Delete Control File Oracle

Remove or Delete a Control File Oracle.
 
How to delete a Control File Oracle?
We will remove the control file F:\Database\CONTROL03.CTL.

Two methods depending on the configuration PFILE or SPFILE in place.

If you use the static parameter file PFILE.

Edit the PFILE is appointing initSID.ora and delete
CONTROL_FILES Part F:\Database\ CONTROL03.CTL
CONTROL_FILES = ('C:oracledba\oradata\test_database\control.ctl   'D:\DATABASE\CONTROL02.CTL','F:\DATABASE\CONTROL03.CTL')
  
Close the database
    SQL> shutdown immediate;
 then restart the database.
    SQL> STARTUP
    SQL> SHOW PARAMETER CONTROL_FILES;

If you use the server parameter file SPFILE.

With alter system set
     SQL> ALTER SYSTEM SET CONTROL_FILES = 'C:oracledba\oradata\test_database\control.ctl   'D:\DATABASE\CONTROL02.CTL' SCOPE = SPFILE;
  Close the database
    SQL> shutdown immediate;
then restart the database.
    SQL> STARTUP
                    SQL> SHOW PARAMETER CONTROL_FILES;




0 File oracle Control (Control Files)

Oracle control file (Control Files).

What is a file Control Files.
The control file is one of the most important files (this is not the only way!!), It contains valuable information on the database.
Its format is binary, do not even try to modify it with a text editor under penalty of rendering it unusable.

What is stored in the control file:
- Date / time of database creation.
- Database name (DBNAME).
- The ID of the base (DBID).
- Info RMAN.
- Archive Log On / Off.
- Sequence number (SCN).
- Path + file name of the database with their statutes.
- Checkpoint (Checkpoint).
- Etc.
Oracle can work with one control file, but it is strongly recommended to multiplex control files on different disks, otherwise in case of corruption of a single file, the database will not start. The Control File is read and updated perpetually at the base is in MOUNT state.
 

Where can I find information on checks files oracle.


SQL> show PARAMETER CONTROL_FILES;
SQL> SELECT value FROM v $ parameter WHERE name = 'control_files';

VALUE
-------------------------------------------------- -
'C:oracledba\oradata\test_database\control.ctl,
'D:\DATABASE\CONTROL02.CTL,
E:\DATABASE\CONTROL02.CTL
 

See the status of controls files (INVALID or Null)
SQL> SELECT status, name FROM v $ controlfile;
 
See MAXLOGFILES, MAXDATAFILES, MAXINSTANCES, MAXLOGHISTORY, etc.
SQL> SELECT * FROM v $ controlfile_record_section;
 

Control-Files-oracle
To know:
 
- The creation date of the file control
- Sequence control file (incremented each shift thereof)
- The last recorded SNA
- The SNA last checkpoint
- The current SNA
- Last time updated.
 
SQL> SELECT controlfile_created,
            controlfile_sequence #,
            controlfile_change #,
            checkpoint_change #,
            current_scn,
            controlfile_time
FROM v $ database;

3 Managing the Oracle Instance


Note that the directory where Oracle is installed is indicated by the environment variable:

    % ORACLE_HOME% for Microsoft Windows. Its value is defined in the registry.
    $ ORACLE_HOME on UNIX systems. Its value is defined in the file. Profiles.

In what follows, we use the variable $ ORACLE_HOME generally and to simplify the nomenclature Unix.
Database Control

To access and manage your Oracle10g database via a web interface, you use the management interface "Oracle Enterprise Manager Database Control" that connects to the Oracle instance through the process of listening : the Listner.

These three components must then be started to manage the database via web.

The Database Control management interface once available, can then launch the other components (and Listner instance).

To use the management interface, the corresponding server-side process "dbconsole" must be started (emctl start dbconsole command). For instance ORCL example, the variable ORACLE_SID must be set in advance (set ORACLE_SID = ORCL Windows or variable $ ORACLE_SID = ORCL in. Profiles Unix). Note however that in Windows, if you do not use the command line and you start "OracleDBConsoleorcl" in the console "Services" (Control Panel ==> Administrative Tools), the variable will be read from the Windows registry.

Emctl command is available in the "$ ORACLE_HOME / bin". Make sure the path is listed in the environment variable "$ PATH".

Oracle DBA (database administrator) can still run commands to manage the online database, create and edit objects, make backups or recovery operations ... etc.

The Database Control management interface allows all these administrative operations via a GUI based on the web.

NB: Through a Database Control Console, you can manage only one database at a time.
Access to Database Control

DBConsole process being started to access the management interface, enter the following URL in your Web browser: http://hostname:1158/em

"Hostname" is the name of the machine on which the process is Listner running. If you test facility "Oracle Database" on your local computer, hostname can be set to localhost or 127.0.0.1 or the name of your computer.

"1158" is the HTTP port of the Database Control management console. Check it in the file "$ ORACLE_HOME / install / portlist.ini."

If the database is stopped, a page is displayed on your browser:

    start the Oracle instance .
    start the listening process (listener)
    or initiating recovery operations.

If instead, the database is already started, a login page is displayed asking you for your "username" and "password" authorized to access Database Control .. Log in as SYSDBA or SYSOPER to give you administrative privileges special purpose.

The DBA role does not include SYSOPER and SYSDBA privileges that allow an administrator to access the instance even if the database is not open and perform administrative tasks such as creating or deleting a database, run STARTUP and SHUTDOWN, place a base archivelog mode.

0 Oracle Database Server


 

Oracle Database Server
Oracle Database Server




Oracle database server includes instance and daranase.


Insatance


Oracle Database Instance is nothing but combination of

  • Background Process
  • Memory Structure
    -----Background Process

      Background process (DBW0,PMON, RECO,CKPT,SMON, LGWR and others). Background process is basically know as computer program.These process performs input/output operations.

   
    ------Memory Structure

When  oracle database instance is started,memory structure (SGA)system global area is been created.Immediately the background processes also starts. The oracle Database instance gives access to an oracle database. An oracle Database Instance opens one and only one database.


Memory Structure includes two area of memory


1)(SGA)System Global Area---This is created when an  instance is started.

2)(PGA)Program Global Area--This is created when a  process at server starts up.

SGA


The system global area is in memory which is used to store the  information shares by all database process and by all users of database.The information includes both organization data and control info used  by the oracle server.The system global area is created in virtual memory.The size of SGA is established by the parameter SGA_MAX_SIXE ..


PGA


The Program Global Area is also termed as Process Global Area(PGA) and is a part of memory allocated that is outside of the oracle Database instance. The PGA stores control and data information fr a single background process terminates.One PGA ia applicable to one process only.


Oracle Database

As we discussed in before post in database architecture oracle database consists of two phases one os logical and other one is physical



  • The control file is used to synchronize all oracle database activity
  • The database files that store the database information that a organization needs in order to operate.
  • The  redo-log files are useful in recovering the data when the disk is failed or any network is failed.
 Process 

 We have three types of process:

  • User process--Starts when a database user requests to connet to an oracle server
  • Server process--Establishes the connection to an oracle Database instance when  user process requests connection makes the connection for the user process
  • Background process--These start when an oracle Database instance is started up

 

Oracle DBA Tutorial Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates