Enabling Automatic Archiving

Oracle

Just a post to remind myself how to start archiving. There are a few details I tend to forget, and presumably they stick better to memory when written down.

Fact 1: ALTER SYSTEM SET LOG_ARCHIVE_START=TRUE SCOPE..(static variable, remember bouncing to effectuate)
Subfact: Definition of “archiving manually” is to start the arch process without setting the init parameter. (ALTER SYSTEM ARCHIVE LOG START)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s