This presentation is the property of its rightful owner.
Sponsored Links
1 / 35

ما معنى إغلاق القاعدة أو تشغيلها ؟ PowerPoint PPT Presentation


  • 141 Views
  • Uploaded on
  • Presentation posted in: General

ما معنى إغلاق القاعدة أو تشغيلها ؟.

Download Presentation

ما معنى إغلاق القاعدة أو تشغيلها ؟

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


4330050

  • : Oracle instance Oracle Database .. Instance Software .... .. Oracle instance ..


4330050

  • Oracle instance ... Oracle Instance ... Instance


4330050

  • : nomount : 1- Parameters File .. instance Control file .. ( ) ... 2- . 3- Background process .. 4- alertSID.log ..... :

  • Oracle home\admin\dbclass\bdumb\alert_dbclass.log


4330050

  • : Mount : Control File Data files Redo Files .... .. ... .


4330050

  • : Open : Data files Redo log .. ...


4330050

  • : Control File .... : 1- Control file no mount .. 2- Mount .. :


4330050

  • : 1- SYS AS SYSDBA SQLPLUS . 2- :

  • startup Level_name;

  • No Mount :

  • startup nomount;


4330050

  • Mount :

  • startup mount;

  • :

  • startup;


4330050

  • 1- nomount :

  • startup nomount;

  • 2- mount :

  • alter database mount;

  • 3- :

  • alter database open;

  • : open mount Mount nomount ...


4330050

: 1- Data files Redo Files ..2- Control file .. 3- Background Process instance ( ... ) ... :


Transactions

Transactions

  • DML ... .. : insert update delete :

  • rollback;

  • .. Rollback ... :

  • commit;


4330050

  • : :

  • SHUTDOWN [NORMAL | TRANSACTIONAL | IMMEDIATE | ABORT ]

  • : 1- Normal : ( SQLPLUS ) ... .. : ( ) ... : 1- SQLPLUS Scott .. 2- SQLPLUS SYS AS SYSDBA ... :

  • shutdown normal;

  • ... 3- SQLPLUS Scott ....


4330050

: Database

.Database -

Database-

.Database

.Redo Log Files Redo Log Buffer-

.Data Files Database Buffer Cache -

.ROLLBACK COMMIT -

.Background Processes-

. SGA-

.Instance Database-

Instance Recovery :

. SMON PMON Recovery .


4330050

  • 2- Transactional : .. : 1- SQLPLUS Scott update delete insert ...2- SQLPLUS SYS AS SYSDBA :

  • shutdown transactional;

  • ... 3- scott :

  • commit;

  • SYS ... 4- scott : Oracle not available Shutdown in progress .....


4330050

  • 3-Immediate : .... : 1- SQLPLUS Scott update :

  • update emp set sal=0 ;

  • .. 2- - SQLPLUS SYS AS SYSDBA :

  • shutdown transactional;

  • .. 3- :

  • startup normal;

  • 4- scott select :

  • select sal from emp;

  • sal=0 ...


4330050

  • 4- ABORT : Instance Recovery ....


4330050

. Database

.ROLLBACK ( )

.Redo Log Files Redo Log Buffer

Data Files Database Buffer Cache

.

ROLLBACK COMMIT

. Instance Database


4330050

  • Enterprise Manager

  • 1- Enterprise Manager SYS AS SYSDBA .. 2- General shutdown :


4330050

  • 3- :


4330050

  • Host Credentials ( linux ) Database Credentials Sys ... ok .. :

  • .... patch jop ..


4330050

  • Local Security Policy Administrative Tools ... :


4330050

  • ... ( Administrators .. ) Add :


4330050

  • 1-3 ... :


4330050

  • immediate .. Advanced Options Abort Transactional normal ... 1- Enterprise Manger SYS AS SYSDBA .. 2- .. Startup .. 3- :


4330050

  • ... .. 4- open .. advanced Options mount nomount .. 5- ok .. 6-


4330050

  • :STARTUP Command

    : Database

    STARTUP [FORCE] [RESTRICT] [PFILE='location and name']

    [OPEN [recover] [databases name] | MOUNT | NOMOUNT ]

NOMOUNT : PFILE

.

MOUNT OPEN : RECOVER

. RECOVERY

Database : RESTRICT

. Restricted Session Privilege

. Instance : FORCE

. "Restart"


4330050

:ALTER DATABASE Command -1

:

: Database -

MOUNT NOMOUNT-

OPEN MOUNT-

  • : ALTER DATABASE

    ALTER DATABASE [database's name] MOUNT | OPEN;

    :

  • : MOUNT NOMOUNT

    ALTER DATABASE MOUNT;


4330050

:Restricted Mode

Database

. Restricted Session Privilege

:

: Restricted Database

STARTUP RESTRICTED;

:

ALTER SYSTEM ENABLE RESTRICTED SESSION;

ALTER SYSTEM DISABLE RESTRICTED SESSION;


4330050

:

: Kill Session

Database

SQLPLUS SQLPLUS

.

username = SCOTT , password =TIGER SYSTEM

:SYSTEM

SELECT USERNAME, SID, SERIAL#

FROM V$SESSION

WHERE USERNAME = 'SCOTT';

( )

USERNAME SID SERIAL#

------------------ ---------- ------------------------------

SCOTT 9 51

: SYSTEM

ALTER SYSTEM KILL SESSION '9, 51';


  • Login