Solved

What is the meaning of this archive log named based on the parameters?  11G version

Posted on 2008-10-28
2
618 Views
Last Modified: 2013-11-11
Hi.I want to know what is the meaning of this name of the archive logs based on the parameters:
I know that the %s is the sequence but this number 656783391 will change?  what is its meaning?

log_archive_format=arch_invdbprd%t_%s_%r.arc

Archive log name:  


arch_invdbprd1_791_656783391.arc
arch_invdbprd1_792_656783391.arc
arch_invdbprd1_793_656783391.arc
arch_invdbprd1_794_656783391.arc
arch_invdbprd1_795_656783391.arc
arch_invdbprd1_796_656783391.arc
arch_invdbprd1_797_656783391.arc
arch_invdbprd1_798_656783391.arc
arch_invdbprd1_799_656783391.arc
arch_invdbprd1_800_656783391.arc
arch_invdbprd1_801_656783391.arc
0
Comment
Question by:LindaC
2 Comments
 
LVL 23

Accepted Solution

by:
David earned 500 total points
ID: 22827866

Optionally, set the LOG_ARCHIVE_FORMAT initialization parameter, using %t to include the thread number as part of the file name, %s to include the log sequence number, and %r to include the resetlogs ID (a timestamp value represented in ub4). Use capital letters (%T, %S, and %R) to pad the file name to the left with zeroes.

Note:If the COMPATIBLE initialization parameter is set to 10.0 or higher, the database requires the specification of resetlogs ID (%r) when you include the LOG_ARCHIVE_FORMAT parameter. The default for this parameter is operating system dependent. For example, this is the default format for UNIX:
LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf
The incarnation of a database changes when you open it with the RESETLOGS option. Specifying %r causes the database to capture the resetlogs ID in the archive log file name, enabling you to more easily perform recovery from a backup of a previous database incarnation. See Oracle Database Backup and Recovery Advanced User's Guide for more information about this method of recovery.
Source: http://youngcow.net/doc/oracle10g/server.102/b14231/archredo.htm
 
0
 
LVL 8

Author Closing Comment

by:LindaC
ID: 31510898
I was able to modify the script to add the resetlog_id from the v$archived_log to move them to Tivoli when they are already "archived" combining the script with the v$log.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now