|
||
|
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
|
|
The second, or preliminary, estimate of GDP for the second quarter was left unchanged from the... |
|
|
25 referals
11 arguments,
279 views
|
|
|
Hi ,i want to do certification in oracle but i don't have appropriate idea about the... |
|
|
1 referals
1 answers,
94 views
|
|
|
Today, I am surprised to find fake IDs and hijaked IDs. I noticed it since my name is dragged... |
|
|
294 referals
118 comments,
718 views
|
|
|
|
|
|
|
Recent Knowledge (26)
|
|
How to spot a fake resume Here are somethings you need to look for to ensure that you are not... |
|
|
464 referals
10 comments,
2793 views
|
|
|
We are hired for our ability to use our intellectual resources - to find solutions, suggest the... |
|
|
386 referals
2 comments,
20 views
|
|
|
|
the old geezer writes again. here's a more non physical view of the 'second law of... |
|
|
296 referals
1 comments,
10 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.... |