Oracle Rman Backup Format%a What does that mean?

Think twice about asking me today: Rman backs up the meaning of%a in format formats.

In fact, Oracle's documentation has this statement:

%a

Specifies the activation ID of the database.

But the description is not clear. In fact, junsansi means that the corresponding information of this%a is reflected in the database.

Let's take a look at this value in the backup information below:

[oracle@yans1 ~]$ Rman Target/

Recovery Manager:release10.2.0.3.0-production on Thursday July 16 14:18:14 2009

Copyright (c) 1982, +, Oracle. All rights reserved.

Connected to target database:test08 (dbid=3812548755)

Rman> backup tablespace users format '/data/backup/test08_%a ';

Starting backup at 1 June-July-09

Using target database control file instead of recovery catalog

Allocated Channel:ora_disk_1

Channel ora_disk_1:sid=100 Devtype=disk

Channel ora_disk_1:starting full datafile backupset

Channel ora_disk_1:specifying DataFile (s) in Backupset

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR message STACK follows ===============

RMAN-00571: ===========================================================

Rman-03009:failure of Backup command on Ora_disk_1 channel at 07/16/2009 14:18:38

Ora-19602:cannot Backup or copy active file in Noarchivelog mode

Rman> SQL ' alter tablespace users read Only ';

SQL Statement:alter tablespace users Read Only

Rman> backup tablespace users format '/data/backup/test08_%a ';

Starting backup at 1 June-July-09

Using channel Ora_disk_1

Channel ora_disk_1:starting full datafile backupset

Channel ora_disk_1:specifying DataFile (s) in Backupset

Input datafile fno=00004 name=/data/oradata/test08/users01.dbf

Channel ora_disk_1:starting piece 1 at 1 June-July-09

Channel ora_disk_1:finished piece 1 at 1 June-July-09

Piece handle=/data/backup/test08_657125523 tag=tag20090716t141924 comment=none

Channel Ora_disk_1:backup set complete, elapsed time:00:00:01

Finished backup at 1 June-July-09

Rman> exit

Recovery Manager complete.

As you can see, the ID of the corresponding activation is 657125523.

And according to the document description, this property is a database, but the corresponding value is not found in the V$database view.

Sql> SELECT view_definition from V$fixed_view_definition

2 WHERE view_name = ' gv$database ';

View_definition

--------------------------------------------------------------------------------------------

Select Di.inst_id,di.didbi,di.didbn,to_date (di.dicts, ' mm/dd/rr HH24:MI:SS ', ' Nls_calendar=gregorian '), To_number ( Di.dirls)

, To_date (DI.DIRLC, ' mm/dd/rr HH24:MI:SS ', ' Nls_calendar=gregorian '), To_number (DI.DIPRS), to_date (DI.DIPRC, ' MM/DD/ RR Hh24:mi

: SS ', ' Nls_calendar=gregorian '), decode (di.dimla,0, ' Noarchivelog ', 1, ' Archivelog ', ' MANUAL '), To_number (DI.DISCN), To_number (d

I.DIFAS), Decode (Bitand (di.diflg,256), 256, ' CREATED ', decode (Bitand), di.diflg,1024, ' 1024 ', STANDBY (Decode ( Di.diflg,32

768), 32768, ' CLONE ', Decode (Bitand (di.diflg,4096), 4096, ' BACKUP ', ' current ')), to_date (Di.dicct, ' mm/dd/rr hh24:mi: SS ', ' Nls_

Calendar=gregorian '), Di.dicsq,to_number (DI.DICKP_SCN), to_date (Di.dickp_tim, ' mm/dd/rr HH24:MI:SS ', ' NLS_CALENDAR= Gregorian

'), Decode (Bitand (di.diflg,4), 4, ' REQUIRED ', decode (di.diirs,0, ' not allowed ', ' allowed ')), to_date (Di.divts, ' mm/dd/ RR Hh24:mi

: SS ', ' Nls_calendar=gregorian '), decode (di.didor,0, ' mounted ', decode (di.didor,1, ' Read WRITE ', ' Read Only '), Decode ( Bitand (di

. diflg,65536), 65536, ' MAXIMUM PROTECTION ', Decode (Bitand (di.diflg,128), 128, ' MAXIMUM availability ', Decode (Bitand ( di.diflg,1

34217728), 134217728, ' resynchronization ', Decode (Bitand (di.diflg,8), 8, ' unprotected ', ' MAXIMUM performance ')), Decode (Di.di

prt,1, ' MAXIMUM PROTECTION ', 2, ' MAXIMUM availability ', 3, ' resynchronization ', 4, ' MAXIMUM performance ', 5, ' unprotected ' , ' UNK

Nown '), decode (di.dirae,0, ' DISABLED ', 1, ' SEND ', 2, ' RECEIVE ', 3, ' ENABLED ', ' UNKNOWN '), To_number (di.diacid), To_number (Di.diacid

), Decode (Bitand (di.diflg,33554432), 33554432, ' LOGICAL STANDBY ', decode (Bitand), di.diflg,1024, ' 1024 STANDBY ', ' PRIM

ARY '), To_number (Di.diars), Decode (Bitand (difl2,1), 1, ' ENABLED ', ' DISABLED '), decode (di.disos,0, ' impossible ', 1, ' Not allowed '

, 2, ' switchover latent ', 3, ' Switchover PENDING ', 4, ' to PRIMARY ', 5, ' to STANDBY ', 6, ' RECOVERY NEEDED ', 7, ' SESSIONS ACTIVE ', 8, ' P

Reparing switchover ', 9, ' preparing DICTIONARY ', ten, ' to LOGICAL STANDBY ', ' UNKNOWN '), decode (di.didgd,0, ' DISABLED ', ' ENABLED ')

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45461.htm