«
»

更改 oracle 成 archivelog mode

2010/04/20, 6:21 pm

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size                  1220796 bytes
Variable Size             171970372 bytes
Database Buffers          423624704 bytes
Redo Buffers                7163904 bytes
Database mounted.

SQL> alter database archivelog;
Database altered.

SQL> alter database open;
Database altered.

SQL> select log_mode from v$database;

LOG_MODE
————
ARCHIVELOG

Tags:
Category: DATABASE

Comments are closed.

Related URL:
  1. Protected: special oracle SQL command , prevent join
  2. [case] compare Oracle : select …. in (…) / or … explain result
  3. Protected: strange problem, RAC , ORACLE data block corrupted (file # %s, block # %s)
  4. oracle export / import command
  5. Protected: oracle 的一些 SOP command
  6. Maximum Availability Architecture – Oracle Streams Configuration Best Practices
  7. [設定/memo] PL/SQL Developer , plsql 免設 tnsname 檔的方法
  8. Protected: [memo] Streams process
  9. Protected: oracle standby SOP
  10. 使用 mysql partition table sample