Revision [3623]

Last edited on 2010-01-28 07:32:21 by WikiAdmin
Additions:
To immediate archive redo logs
SQL> alter system switch logfile;
SQL> select group#,status,archive from v$log;
SQL> select name from v$archived_log;

Revision [3622]

Edited on 2010-01-28 07:26:53 by WikiAdmin
Additions:
Then archive logs are automatically stored in DB_RECOVERY_FILE_DEST. One can check where that is by
SQL> show parameters DB_RECOVERY_FILE_DEST;
Which is the $ORACLE_HOME/flash_recovery_area

Revision [3621]

Edited on 2010-01-28 07:18:47 by WikiAdmin
Additions:
==Enable archivelog mode==
SQL> shutdown immediate;
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list;

Revision [3611]

Edited on 2010-01-07 20:47:45 by WikiAdmin
Additions:
group 2 ('D:\oracle\databases\ora10\redo2.log') size 10M,
group 3 ('D:\oracle\databases\ora10\redo3.log') size 10M
size 50M
autoextend on
next 10M maxsize unlimited
extent management local
size 10M
autoextend on
next 10M
maxsize unlimited
datafile 'D:\oracle\databases\ora10\undo.dbf'
size 10M
tempfile 'D:\oracle\databases\ora10\temp.dbf'
size 10M;
==Query database's process limit==
show parameters PROCESS
Deletions:
group 2 ('D:\oracle\databases\ora10\redo2.log') size 10M,
group 3 ('D:\oracle\databases\ora10\redo3.log') size 10M
size 50M
autoextend on
next 10M maxsize unlimited
extent management local
size 10M
autoextend on
next 10M
maxsize unlimited
datafile 'D:\oracle\databases\ora10\undo.dbf'
size 10M
tempfile 'D:\oracle\databases\ora10\temp.dbf'
size 10M;

Revision [1409]

Edited on 2008-02-18 00:37:52 by WikiAdmin
Additions:
===Oracle timezone changes===
srvctl setenv database -d SID -t TZ=Australia/Sydney

Revision [461]

Edited on 2007-05-03 22:59:37 by WikiAdmin
Deletions:
{{adsense}}

Revision [135]

Edited on 2007-04-14 21:30:38 by WikiAdmin
Additions:
{{parent page="Oracle"}}

Revision [78]

Edited on 2007-04-14 09:25:22 by WikiAdmin
Additions:
== Query a database's character set setting ==
Deletions:
++ Query a database's character set setting

Revision [77]

The oldest known version of this page was created on 2007-04-14 09:25:12 by WikiAdmin
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki