Build your professional network on facebook via our app Go to app
 
 
 
By : Raja B, Database Administrator, Computer Sciences Corporation
Industry : IT Products Functional Area : Backup & Recovery
Activity:  1 comments  7186 views  last activity : 07 06 2010 20:18:04 +0000
 Refer 20
Share
 
 
 

SQL> shutdown
SQL> startup mount
SQL> alter database archivelog
SQL> alter database open
SQL> archive log list

If your database is 10g then no need of setting LOG_ARCHIVE_START parameter as it is deprecated in 10g release. Just do the following 3 steps to enable archiving.
SQL> startup mount
SQL> alter database archivelog
SQL> alter database open

By default the LOG_ARCHIVE_DEST in 10g is the flash recovery area that is the value for parameter DB_RECOVERY_FILE_DEST

 For complete details, view the URL link below....

 
TrackBack URL:
1 comments on "Oracle - Steps to turn on the archive log mode"
  Commented by  Sourav Chatterjee, IT Engineer- CMC Limited-ATata Enterprise    | 07 24 2008 21:39:10 +0000
good article 
Add your comment on "Oracle - Steps to turn on the archive log mode"

Rate:
Submit
Leading HR Consulting specialists in India
  • Create a confidential Career Profile and Resume/C.V. online
  • Get advice for planning their career and for marketing of experience and skills
  • Maximize awareness of and access to the best career opportunities
Viewers also viewed
The ongoing fight for business applications supremacy between Oracle and SAP AG has been long and...
 
274 referals 23 arguments, 5302 views
7 Steps to Protect Against Online Fraud for this Year's Tax Day SonicWALL  Security Threat  Team...
 
1243 referals 21 comments, 262 views
The prevention of violence and harassment at work represents a challenge for many organisations,...
 
759 referals 25 comments, 902 views
more...  
Recent Knowledge (15)
Top SEO Forums Sites List http://searchengineforums.com/ http://www.abakus-internet-marketing.de...
 
344 referals 8 comments, 3693 views
It is relatively easy to identify the use count and resource usage of your SP’s, but first let...
244 referals 6 comments, 401 views
What could be wrong with the Stock Market? Today, the 1 standard deviation event occurred,...
 
306 referals 8 comments, 258 views
more...  
More From Author
A good write up of XML usage in Oracle DB. For complete details, view the following URL...
It is beyond the scope of this document to present all the scenarios that mark an index as unusable and how to validate unusable indexes. Instead, we are going to see what happens to an index when it becomes unusable.  To read the full article,...
Good discussion on capability of Oracle 10g Flashback Database versus DB2 Recovery Expert. Click the link below for the complete information....
more...