Friends after long time back to blog …. due to lots of up / down in life I was away from blog …. but promise from here onward will be in touch with you guys and will always reply your queries and suggestions …
Most of Jr. DBA while chating ask the question abt archive enable / disable query , so just coming with basic but most useful post for Jr.DBA.
Also please note , whenever we enabling the DB in archive mode as DBA we need to monitor the archive space as well.
In large database environmnet we need to take regular archive so backup , so generaly DBA use to schedule it to keep the free space in archive location.
Otherwise DB may go in hung state if archive location is fulled.
In oraganisation some time archive file is manually deleted by DBA it self or we schedule it to delete once it is backup.
This is how to enable archiving:
SQL*Plus: Release 10.2.0.4.0 – Production on Tue Feb 26 09:57:43 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to: Oracle Database 10g Release 10.2.0.4.0 – 64bit Production
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle/SID/oraarch
Oldest online log sequence 2442
Current log sequence 2444
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 96469696 bytes
Database Buffers 184549376 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/SID/oraarch
Oldest online log sequence 26
Next log sequence to archive 28
Current log sequence 28
SQL>
=================================================
This is how to disable archiving:
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 100664000 bytes
Database Buffers 180355072 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database noarchivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle/SID/oraarch
Oldest online log sequence 26
Current log sequence 28
SQL>
I Hope this article helped to you. I am expecting your suggestions/feedback.
It will help to motivate me to write more articles….!!!!
Thanks & Regards,
Samadhan
https://samadhandba.wordpress.com/
“Key for suceess, always fight even knowing your defeat is certain….!!!!
samadhandba 