oracle啟用歸檔日志
1.用有dba權(quán)限的用戶登錄：sys用戶
2.創(chuàng)建一個新用戶：create user abc identified by 123456;
3.授予DBA權(quán)限： grant connect,resource,dba to abc;
select * from dba_users; 查看數(shù)據(jù)庫里面所有用戶，前提是你是有dba權(quán)限的帳號是目，如sys,system
select * from all_users; 查看你能管理的所有用戶絮供！
select * from user_users; 查看當(dāng)前用戶信息 ！
SQL> conn / as sysdba(以DBA身份連接數(shù)據(jù)庫)
SQL> shutdown immediate(立即關(guān)閉數(shù)據(jù)庫)
SQL> startup mount(啟動實例并加載數(shù)據(jù)庫，但不打開)
SQL> alter database archivelog(更改數(shù)據(jù)庫為歸檔模式)
SQL> alter database open(打開數(shù)據(jù)庫)
SQL> alter system archive log start(啟用自動歸檔)
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/arch_log
Oldest online log sequence 6
Next log sequence to archive 8
Current log sequence 8
SQL> select * from dba_sys_privs where GRANTEE='GGS'; 查看賬戶權(quán)限
