Home » RDBMS Server » Backup & Recovery » size of archive logs
size of archive logs [message #267070] Wed, 12 September 2007 07:30 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi,

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


Thx
Re: size of archive logs [message #267075 is a reply to message #267070] Wed, 12 September 2007 07:50 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
You will have to drop and create bigger online redo log files.
Re: size of archive logs [message #267281 is a reply to message #267070] Wed, 12 September 2007 23:33 Go to previous messageGo to next message
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
Re: size of archive logs [message #267293 is a reply to message #267281] Thu, 13 September 2007 00:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How is this answer the question?

Regards
Michel
Re: size of archive logs [message #267512 is a reply to message #267293] Thu, 13 September 2007 10:17 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I guess he went wrong like me Wink
Previous Topic: master db in archive mode and slaves not
Next Topic: Recovery using RMAN Backup after OS Crash
Goto Forum:
  


Current Time: Fri Dec 09 09:41:55 CST 2016

Total time taken to generate the page: 0.10089 seconds