第十一章： manager role <P>    1.create roles <P>    sql> create role sales_clerk; <P>    sql> create role hr_clerk identified by bonus; <P>    sql> create role hr_manager identified externally; <P>    2.modify role <P>    sql> alter role sales_clerk identified by commission; <P>    sql> alter role hr_clerk identified externally; <P>    sql> alter role hr_manager not identified; <P>    3.assigning roles <P>    sql> grant sales_clerk to scott; <P>    sql> grant hr_clerk to hr_manager; <P>    sql> grant hr_manager to scott with admin option; <P>    4.establish default role <P>    sql> alter user scott default role hr_clerk,sales_clerk; <P>    sql> alter user scott default role all; <P>    sql> alter user scott default role all except hr_clerk; <P>    sql> alter user scott default role none; <P>    5.enable and disable roles <P>    sql> set role hr_clerk; <P>    sql> set role sales_clerk identified by commission; <P>    sql> set role all except sales_clerk; <P>    sql> set role none; <P>    6.remove role from user <P>    sql> revoke sales_clerk from scott; <P>    sql> revoke hr_manager from public; <P>    7.remove role <P>    sql> drop role hr_manager; <P>    8.display role information <P>    view: =>dba_roles,dba_role_privs,role_role_privs,dba_sys_privs,
role_sys_privs,role_tab_privs,session_roles </P>

第十二章: BACKUP and RECOVERY <P>    1. v$sga,v$instance,v$process,v$bgprocess,v$database,v$datafile,v$sgastat <P>    2. Rman need set dbwr_IO_slaves or backup_tape_IO_slaves and large_pool_size <P>    3. Monitoring Parallel Rollback <P>    > v$fast_start_servers , v$fast_start_transactions <P>    4.perform a closed database backup (noarchivelog) <P>    > shutdown immediate <P>    > cp files /backup/ <P>    > startup <P>    5.restore to a different location <P>    > connect system/manager as sysdba <P>    > startup mount <P>    > alter database rename file '/disk1/../user.dbf'to '/disk2/../user.dbf'; <P>    > alter database open; <P>    6.recover syntax <P>    --recover a mounted database <P>    >recover database; <P>    >recover datafile '/disk1/data/df2.dbf'; <P>    >alter database recover database; <P>    --recover an opened database <P>    >recover tablespace user_data; <P>    >recover datafile 2; <P>    >alter database recover datafile 2; <P>    7.how to apply redo log files automatically <P>    >set autorecovery on <P>    >recover automatic datafile 4; <P>    8.complete recovery: <P>    --method 1(mounted databae) <P>    >copy c:\backup\user.dbf c:\oradata\user.dbf <P>    >startup mount <P>    >recover datafile 'c:\oradata\user.dbf; <P>    >alter database open; <P>    --method 2(opened database,initially opened,not system or rollback datafile) </P>

>copy c:\backup\user.dbf c:\oradata\user.dbf (alter tablespace offline) <P>    >recover datafile 'c:\oradata\user.dbf' or <P>    >recover tablespace user_data; <P>    >alter database datafile 'c:\oradata\user.dbf' online or <P>    >alter tablespace user_data online; <P>    --method 3(opened database,initially closed not system or rollback datafile) <P>    >startup mount <P>    >alter database datafile 'c:\oradata\user.dbf' offline; <P>    >alter database open <P>    >copy c:\backup\user.dbf d:\oradata\user.dbf <P>    >alter database rename file 'c:\oradata\user.dbf'to 'd:\oradata\user.dbf' <P>    >recover datafile 'e:\oradata\user.dbf' or recover tablespace user_data; <P>    >alter tablespace user_data online; <P>    --method 4(loss of data file with no backup and have all archive log) <P>    >alter tablespace user_data offline immediate; <P>    >alter database create datafile 'd:\oradata\user.dbf'as 'c:\oradata\user.dbf'' <P>    >recover tablespace user_data; <P>    >alter tablespace user_data online <P>    5.perform an open database backup <P>    > alter tablespace user_data begin backup; <P>    > copy files /backup/ <P>    > alter database datafile '/c:/../data.dbf' end backup; <P>    > alter system switch logfile; <P>    6.backup a control file <P>    > alter database backup controlfile to 'control1.bkp'; <P>    > alter database backup controlfile to trace; <P>    7.recovery (noarchivelog mode) <P>    > shutdown abort <P>    > cp files <P>    > startup <P>    8.recovery of file in backup mode <P>    >alter database datafile 2 end backup; <P>    9.clearing redo log file <P>    >alter database clear unarchived logfile group 1; <P>    >alter database clear unarchived logfile group 1 unrecoverable datafile; <P>    10.redo log recovery <P>    >alter database add logfile group 3 'c:\oradata\redo03.log'size 1000k; <P>    >alter database drop logfile group 1; <P>    >alter database open; <P>    or >cp c:\oradata\redo02.log' c:\oradata\redo01.log <P>    >alter database clear logfile 'c:\oradata\log01.log';</P>