[Oracle] Oracle日常维护中管理用户以及重做日志文件的方法

select distinct object_type from dba_objects;

create user u1 identified by u1; --->默认 users表空间和temp表空间
    create user u2 identified by u2 default tablespace user_u2 temporary tablespace temp_u2; --->指定user_u2表空间和temp_u2表空间

grant connect, resource to u1;
    grant creata session to u1;  --->设置会话的权限

drop user u1;

select * from session_privs;  --->查询当前用户的权限
  select * from session_roles;  --->查询当前用户的角色
  select * from role_sys_privs;  --->查询当前用户的角色权限
  select * from user_sys_privs;  --->查询当前用户的系统权限

>select * from v$logfile;

>select * from v$log;

alter database add logfile [group <X0>] ('<logfile path&name>','',……) size <Y>, [group <X1>] ……

alter database add logfile member '<logfile path&name>' to group <X0>，'<logfile path&name>' ……

alter database drop logfile group <X>, group……

alter database drop logfile member '<logfile path&name>','<logfile path&name>',……;

ho cp <old> <new>
  alter database rename file '<old>' tp '<new>';

alter database clear logfile group <X>;

alter database clear unarchived logfile group <X>;

alter database clear logfile group <X>;

recover database using backup controlfile;alter database open resetlog;

alter system set "_allow_resetlogs_corruption"=true scope=spfile;

alter system reset "_allow_resetlogs_corruption" scope=spfile sid='*';