-
Target:Oracle 816/NT 4 - RMAN DB:Oracle 816 /NT
I am trying to implement RMAN at my site. When trying different options I found different unusual scenario:
If I don't specify format command, It generates one backup set with all the datafiles in one piece at default location.
I thought I want specific location for my backup, so,
If I specify format command with fixed filename, it errors out.
Specifying format with variables (_%U), it generates two backup set.
Does it mean that format command force it to generate more backup set or does it apply the restriction of filesize and force it to generate more than one files.
No other options like, FILESPERSET or SET LIMIT used.
For your reference, here is the actual output:
******************* First Case ********************
RMAN> run{
2> allocate channel d1 type disk;
3> backup
4> (database include current controlfile);
5> }
RMAN> list backup;
RMAN-03022: compiling command: list
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2688 50 450784014 0 450783988 57 10-JAN-02
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
2689 1 1 AVAILABLE 10-JAN-02 D:\ORACLE\ORACLE816\DATABASE\1PDDSQNK_1_1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
1 D:\ORACLE\ORADATA\ORCL\SYSTEM\SYSTEM01.ORA 0 Full 3228966 10-JAN-02
2 D:\ORACLE\ORADATA\ORCL\USERDATA\USER01.ORA 0 Full 3228966 10-JAN-02
3 D:\ORACLE\ORADATA\ORCL\TEMPORARY\TEMPORARY01.ORA 0 Full 3228966 10-JAN-02
4 D:\ORACLE\ORADATA\ORCL\RBS\RBS01.ORA 0 Full 3228966 10-JAN-02
RMAN>
******************* Second Case ********************
RMAN> run{
2> allocate channel d1 type disk;
3> backup
4> format 'd:\oracle\oraclebackup\rman\DATA_011002.bak'
5> (database include current controlfile);
6> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel d1
RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "d:\oracle\oraclebackup\rman\D
ATA_011002.bak"
ORA-27038: skgfrcre: file exists
OSD-04010: option specified, file already exists
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
******************* Third Case ********************
RMAN> run{
2> allocate channel d1 type disk;
3> backup
4> format 'd:\oracle\oraclebackup\rman\DATA_%U.bak'
5> (database include current controlfile);
6> }
RMAN> list backup;
RMAN-03022: compiling command: list
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2708 52 450784468 0 450784456 60 10-JAN-02
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
2710 1 1 AVAILABLE 10-JAN-02 D:\ORACLE\ORACLEBACKUP\RMAN\DATA_1SDDSR68_1_1
.BAK
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
1 D:\ORACLE\ORADATA\ORCL\SYSTEM\SYSTEM01.ORA 0 Full 3229065 10-JAN-02
4 D:\ORACLE\ORADATA\ORCL\RBS\RBS01.ORA 0 Full 3229065 10-JAN-02
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
2709 53 450784488 0 450784472 61 10-JAN-02
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
2711 1 1 AVAILABLE 10-JAN-02 D:\ORACLE\ORACLEBACKUP\RMAN\DATA_1TDDSR6O_1_1
.BAK
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
2 D:\ORACLE\ORADATA\ORCL\USERDATA\USER01.ORA 0 Full 3229066 10-JAN-02
3 D:\ORACLE\ORADATA\ORCL\TEMPORARY\TEMPORARY01.ORA 0 Full 3229066 10-JAN-02
[Edited by Sharma on 01-10-2002 at 11:23 AM]
-
Code:
allocate channel d1 type disk;
backup
full
#skip offline
#skip readonly
skip inaccessible
tag backup_db_full
filesperset 5
format 'df_%d_t%t_s%s_p%p'
(database include current controlfile);
release channel d1;
Hope this would help you.
Sam
