Solved

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

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

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
oracle 11g 23 106
constraint check 2 48
Trying to get a Linked Server to Oracle DB working 21 67
Oracle create type table from existing table%rowtype ? 6 33
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.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

809 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