OraFAQ Forum: Backup & Recovery » size of archive logs

Home » RDBMS Server » Backup & Recovery » size of archive logs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

size of archive logs [message #267070]

Wed, 12 September 2007 07:30

dirish
Messages: 232
Registered: November 2006

Senior Member

Hi,

how can i change the size of the archive logs in oracle10g?

Thx

Report message to a moderator

Re: size of archive logs [message #267075 is a reply to message #267070]

Wed, 12 September 2007 07:50

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

You will have to drop and create bigger online redo log files.

Report message to a moderator

Re: size of archive logs [message #267281 is a reply to message #267070]

Wed, 12 September 2007 23:33

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

SQL> select dest_name,status,destination from v$archive_dest where status='VALID';

DEST_NAME
--------------------------------------------------------------------------------
STATUS
---------
DESTINATION
--------------------------------------------------------------------------------
LOG_ARCHIVE_DEST_10
VALID
USE_DB_RECOVERY_FILE_DEST

SQL> show parameter DB_RECOVERY_FILE_DEST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /oradata2
db_recovery_file_dest_size           big integer 1G
SQL> alter system set db_recovery_file_dest_size=2G
  2  ;

System altered.

SQL> show parameter DB_RECOVERY_FILE_DEST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /oradata2
db_recovery_file_dest_size           big integer 2G

Report message to a moderator