|
||
|
Source : http://forums.oracle.com
Activity:
1 comments
7186 views
last activity : 07 06 2010 20:18:04 +0000
|
||
|
|
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"
Sort by:
Most Recent
Top Rated
Commented by
Sourav Chatterjee, IT Engineer- CMC Limited-ATata Enterprise
| 07 24 2008 21:39:10 +0000
Report Abuse
Not Rated
Found the article
"Oracle - Steps to turn on the archive log mode"
interesting ?
Share with your connections and communities
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
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
Sponsored Jobs
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.... |