?
Solved

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

Posted on 2008-10-28
2
Medium Priority
?
627 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Accepted Solution

by:
David earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

762 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