|
|
||
|
Source : http://forums.oracle.com
Activity:
1 comments
6422 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 executive search firm
ASIC Verification Engineer, A Leading Services Company, Bangalore, Hyderabad,vizag,Noida
VHDL, Spice, Modelsim, Nanosim, Mixed signal verification Engineer, A Leading Services Company, Bangalore,Noida
Systrem verilog, verilog, Specman, ASIC Verification Engineer, A Leading Services Company, Bangalore, Hyderabad,vizag,Noida
Viewers also viewed
|
|
|
|
|
|
Recent Knowledge (26)
|
|
|
|
|
|
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.... |