// rman set newname format (파일 명명법)
- %b: Specifies the file name without the directory that it locates.
- %N: Specifies the tablespace name
- %f: Specifies the absolute file number of a datafile
- %I: Specifies DBID
- %U: Specifies system generated unique filename
// as a following format: data-D-%d_id-%I_TS-%N_FNO-%f
// archivelog log_archive_format
- %s: log sequence number
- %S: log sequence number, zero filled
- %t: thread number
- %T: thread number, zero filled
- %a: activation ID
- %d: database ID
- %r: resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database
'Oracle' 카테고리의 다른 글
| [Oracle] 파티션 Exchange (Partition Exchange) (0) | 2023.01.16 |
|---|---|
| [Oracle] ORA-00600: internal error code, arguments: [kgfz_getDiskAccessMode:ntyp] ... (0) | 2022.07.12 |
| [Oracle] oracle utility (0) | 2022.06.15 |
| [Oracle] bbed (block edit) ORA-01578: ORACLE data block corrupted (0) | 2022.06.15 |
| [Oracle] ORA-00600: internal error code, arguments: [729], [80], [space leak] (0) | 2022.03.18 |