Solved

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

Posted on 2008-10-28
2
626 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 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

726 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