oracle 基本练习 -凯发app官方网站

sql*plus: release 9.2.0.4.0 - production on sun mar 18 11:58:12 2007

凯发app官方网站 copyright (c) 1982, 2002, oracle corporation. all rights reserved.

sql> connect /as sysdba

connected.

sql> shutdown immediate

database closed.

database dismounted.

oracle instance shut down.

sql> startup mount

oracle instance started.

total system global area 105978600 bytes

fixed size 453352 bytes

variable size 79691776 bytes

database buffers 25165824 bytes

redo buffers 667648 bytes

database mounted.

sql> alter database archivelog;

database altered.

sql> archive log list;

database log mode no archive mode

automatic archival disabled

archive destination c:/oracle/ora92/rdbms

oldest online log sequence 22

current log sequence 24

sql> alter system set log_archive_dest='/u1/oradata/arch';

system altered.

sql> alter system set log_archive_start=true scope=spfile;

system altered.

sql> shutdown immediate

database closed.

database dismounted.

oracle instance shut down.

sql> startup

oracle instance started.

total system global area 105978600 bytes

fixed size 453352 bytes

variable size 79691776 bytes

database buffers 25165824 bytes

redo buffers 667648 bytes

database mounted.

database opened.

sql> archive log list;

database log mode archive mode

automatic archival disabled

archive destination c:/oracle/ora92/database/archive

oldest online log sequence 22

next log sequence to archive 24

sql> alter system switch logfile;

system altered.

sql> alter system switch logfile;

system altered.

sql> alter system switch logfile;

阅读(2011) | 评论(0) | 转发(0) |

上一篇：compile linux kernel

下一篇：[转]oracle scn学习

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们