|
||
|
Source : http://forums.oracle.com
Activity:
1 comments
5706 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
Exclusive Portal for Aerospace & Automobile Jobs - A Roland & Associates initiative
- 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
17 arguments,
2527 views
|
|
|
print media vs electronic media |
|
|
0 referals
3 arguments,
30 views
|
|
|
Which one is more better secure ? |
|
|
1 referals
17 arguments,
1311 views
|
|
|
|
|
|
|
Recent Knowledge (175)
|
|
"They all were looking at me on the bed. I went back to my bedroom. "Am I dead??" I asked... |
|
|
168 referals
26 comments,
257 views
|
|
|
IBM Turns 100: Will Other Tech Companies Last That Long? IBM reached an impressive milestone.... |
|
|
0 referals
3 comments,
52 views
|
|
|
SUCCESSFUL PEOPLE Success seems to be connected with action. Successful people keep moving. They... |
|
|
482 referals
15 comments,
124 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.... |