Abd

Classified in Other subjects

Written at on English with a size of 1.5 KB.

 
- Move or Rename Redo Log Files group3
alter database add logfile group 3
'C: \ OracleXE \ app \ oracle \ flash_recovery_area \ XE \ ONLINELOG \ REDOLOG_03.LOG' SIZE 10M;
SELECT * FROM V $ LOGFILE;
- Download the database (shutdown immediate).
- Up to BD Mount (startup mount).
-Move the file C: \ OracleXE \ app \ oracle \ flash_recovery_area \ XE \ ONLINELOG \ REDOLOG_03.LOG to directory
C: \ OracleXE \ oradata \ XE
alter database rename file
'C: \ OracleXE \ app \ oracle \ flash_recovery_area \ XE \ ONLINELOG \ REDOLOG_03.LOG' to
'C: \ OracleXE \ oradata \ XE \ REDOLOG_03.LOG'

- Display a list of all "archived log" registered in the control file.
Select * from v $ archived_log;

- KNOW THE USERS WITH SYSDBA and / or SYSOPER
SQL> select * from v $ pwfile_users;

- Assign user privileges sysdba to system
SQL> GRANT SYSDBA TO system;
SQL> select * from v $ pwfile_users;

- Unlock the user account HR:
SQL> alter user HR account unlock;

- Lock the user account HR:
SQL> alter user HR account lock;

- Change password of the user account by DUOC HR:
SQL> ALTER USER HR IDENTIFIED BY duoc;

Entradas relacionadas: