Home » RDBMS Server » Backup & Recovery » Data files backed up to FRA instead of specified location (Oracle 11.2.0.1.0 on , OEL 5.7 (VM))
| Data files backed up to FRA instead of specified location [message #588292] |
Mon, 24 June 2013 11:20  |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
Hi all,
I am trying to backup my entire database's files :
[oracle@testing-oracle-1 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jun 24 16:09:54 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1341263457)
RMAN> list backup;
using target database control file instead of recovery catalog
specification does not match any backup in the repository
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT
FOR DEVICE TYPE DISK TO '/u01/app/oracle/backupsets/control_files/cf_%F.BCKP';2>
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backupsets/control_files/cf_%F.BCKP';
new RMAN configuration parameters are successfully stored
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG format '/u01/app/oracle/backupsets/%t_%s_%r.BCKP';
Starting backup at 24-JUN-13
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=46 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=7 RECID=1 STAMP=818957424
channel ORA_DISK_1: starting piece 1 at 24-JUN-13
channel ORA_DISK_1: finished piece 1 at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/818957425_1_%r.BCKP tag=TAG20130624T161025 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-JUN-13
Starting backup at 24-JUN-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-JUN-13
channel ORA_DISK_1: finished piece 1 at 24-JUN-13
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/o1_mf_nnnd0_TAG20130624T161026_8wjkb2tg_.bkp tag=TAG20130624T161026 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 24-JUN-13
Starting backup at 24-JUN-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=8 RECID=2 STAMP=818957451
channel ORA_DISK_1: starting piece 1 at 24-JUN-13
channel ORA_DISK_1: finished piece 1 at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/818957451_3_%r.BCKP tag=TAG20130624T161051 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-JUN-13
Starting Control File and SPFILE Autobackup at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/control_files/cf_c-1341263457-20130624-00.BCKP comment=NONE
Finished Control File and SPFILE Autobackup at 24-JUN-13
I see that a backup set was created to "/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/" , in spite of my specification.
So I asked RMAN to list all the backups I have:
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 41.14M DISK 00:00:00 24-JUN-13
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20130624T161025
Piece Name: /u01/app/oracle/backupsets/818957425_1_%r.BCKP
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 7 1035608 24-JUN-13 1045486 24-JUN-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Incr 0 981.45M DISK 00:00:16 24-JUN-13
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20130624T161026
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/o1_mf_nnnd0_TAG20130624T161026_8wjkb2tg_.bkp
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 1045494 24-JUN-13 /u01/app/oracle/oradata/orcl/system01.dbf
2 0 Incr 1045494 24-JUN-13 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 0 Incr 1045494 24-JUN-13 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 0 Incr 1045494 24-JUN-13 /u01/app/oracle/oradata/orcl/users01.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3 16.50K DISK 00:00:00 24-JUN-13
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20130624T161051
Piece Name: /u01/app/oracle/backupsets/818957451_3_%r.BCKP
List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 8 1045486 24-JUN-13 1045507 24-JUN-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 9.36M DISK 00:00:01 24-JUN-13
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20130624T161052
Piece Name: /u01/app/oracle/backupsets/control_files/cf_c-1341263457-20130624-00.BCKP
SPFILE Included: Modification time: 24-JUN-13
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1045516 Ckp time: 24-JUN-13
RMAN>
Here I see that 4 backup sets have been created.
The backup sets 1 & 3 containing the archived redo logs (818957425_1_%r.BCKP and 818957451_3_%r.BCKP) are placed as I wanted in /u01/app/oracle/backupsets/ dir.(although I don't understand why are there two of them???)
The file containing the Control File and Spfile (cf_c-1341263457-20130624-00.BCKP) is placed as I wanted in /u01/app/oracle/backupsets/control_files/ dir.
However, The backup set file containing the data files(o1_mf_nnnd0_TAG20130624T161026_8wjkb2tg_.bkp) is placed under the directory /u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/ ,and I don't understand why.
When I backup my database without the archived redo logs - it is saved correctly:
RMAN>
RMAN> delete backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1 1 1 1 AVAILABLE DISK /u01/app/oracle/backupsets/818957425_1_%r.BCKP
2 2 1 1 AVAILABLE DISK /u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/o1_mf_nnnd0_TAG20130624T161026_8wjkb2tg_.bkp
3 3 1 1 AVAILABLE DISK /u01/app/oracle/backupsets/818957451_3_%r.BCKP
4 4 1 1 AVAILABLE DISK /u01/app/oracle/backupsets/control_files/cf_c-1341263457-20130624-00.BCKP
Do you really want to delete the above objects (enter YES or NO)? y
deleted backup piece
backup piece handle=/u01/app/oracle/backupsets/818957425_1_%r.BCKP RECID=1 STAMP=818957425
deleted backup piece
backup piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/o1_mf_nnnd0_TAG20130624T161026_8wjkb2tg_.bkp RECID=2 STAMP=818957426
deleted backup piece
backup piece handle=/u01/app/oracle/backupsets/818957451_3_%r.BCKP RECID=3 STAMP=818957451
deleted backup piece
backup piece handle=/u01/app/oracle/backupsets/control_files/cf_c-1341263457-20130624-00.BCKP RECID=4 STAMP=818957453
Deleted 4 objects
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE format '/u01/app/oracle/backupsets/%t_%s_%r.BCKP';
Starting backup at 24-JUN-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-JUN-13
channel ORA_DISK_1: finished piece 1 at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/818957922_5_%r.BCKP tag=TAG20130624T161842 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 24-JUN-13
Starting Control File and SPFILE Autobackup at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/control_files/cf_c-1341263457-20130624-01.BCKP comment=NONE
Finished Control File and SPFILE Autobackup at 24-JUN-13
RMAN>
RMAN>
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Incr 0 982.13M DISK 00:00:11 24-JUN-13
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20130624T161842
Piece Name: /u01/app/oracle/backupsets/818957922_5_%r.BCKP
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 1046026 24-JUN-13 /u01/app/oracle/oradata/orcl/system01.dbf
2 0 Incr 1046026 24-JUN-13 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 0 Incr 1046026 24-JUN-13 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 0 Incr 1046026 24-JUN-13 /u01/app/oracle/oradata/orcl/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 9.36M DISK 00:00:00 24-JUN-13
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20130624T161857
Piece Name: /u01/app/oracle/backupsets/control_files/cf_c-1341263457-20130624-01.BCKP
SPFILE Included: Modification time: 24-JUN-13
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1046041 Ckp time: 24-JUN-13
RMAN>
My questions are:
1. Why aren't my data files backed up to the location I specified when I backup using PLUS ARCHIVELOG syntax?
2. Why are my redo logs saved to two different backup sets and not just one?
3. Is there a way to combine backup of all files (data files, control file, spfile, redo logs & arch redo's) in one backup set, one file?
Thanks in advance,
Andrey
[Updated on: Mon, 24 June 2013 11:23] Report message to a moderator |
|
|
|
| Re: Data files backed up to FRA instead of specified location [message #588294 is a reply to message #588292] |
Mon, 24 June 2013 11:55  |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
Andrey_R wrote on Mon, 24 June 2013 12:20. . . E t c . . .
My questions are:
1. Why aren't my data files backed up to the location I specified when I backup using PLUS ARCHIVELOG syntax?
You may need to specify a default backup location:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/app/oracle/backupsets/%t_%s_%r.BCKP';
Quote:
2. Why are my redo logs saved to two different backup sets and not just one?
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
Quote:
3. Is there a way to combine backup of all files (data files, control file, spfile, redo logs & arch redo's) in one backup set, one file?
See answer to #1.
[Updated on: Mon, 24 June 2013 12:40] by Moderator Report message to a moderator |
|
|
|
| Re: Data files backed up to FRA instead of specified location [message #588297 is a reply to message #588294] |
Mon, 24 June 2013 12:29 |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
Hi LKBrwn_DBA,
Thanks for your reply:)
I've deleted the backups, and tried to re-do it with your suggestion - I must have done something wrong because I still see two backup sets for the redo's:
RMAN> delete backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
7 7 1 1 AVAILABLE DISK /u01/app/oracle/backupsets/818961866_7_%r.BCKP
8 8 1 1 AVAILABLE DISK /u01/app/oracle/backupsets/818961867_8_%r.BCKP
9 9 1 1 AVAILABLE DISK /u01/app/oracle/backupsets/818961882_9_%r.BCKP
10 10 1 1 AVAILABLE DISK /u01/app/oracle/backupsets/control_files/cf_c-1341263457-20130624-02.BCKP
Do you really want to delete the above objects (enter YES or NO)? y
deleted backup piece
backup piece handle=/u01/app/oracle/backupsets/818961866_7_%r.BCKP RECID=7 STAMP=818961866
deleted backup piece
backup piece handle=/u01/app/oracle/backupsets/818961867_8_%r.BCKP RECID=8 STAMP=818961867
deleted backup piece
backup piece handle=/u01/app/oracle/backupsets/818961882_9_%r.BCKP RECID=9 STAMP=818961882
deleted backup piece
backup piece handle=/u01/app/oracle/backupsets/control_files/cf_c-1341263457-20130624-02.BCKP RECID=10 STAMP=818961883
Deleted 4 objects
RMAN> list backup;
specification does not match any backup in the repository
RMAN>
RMAN>
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters are successfully stored
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG format '/u01/app/oracle/backupsets/%t_%s_%r.BCKP';
Starting backup at 24-JUN-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=7 RECID=1 STAMP=818957424
input archived log thread=1 sequence=8 RECID=2 STAMP=818957451
input archived log thread=1 sequence=9 RECID=3 STAMP=818961866
input archived log thread=1 sequence=10 RECID=4 STAMP=818961882
input archived log thread=1 sequence=11 RECID=5 STAMP=818962126
channel ORA_DISK_1: starting piece 1 at 24-JUN-13
channel ORA_DISK_1: finished piece 1 at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/818962126_11_%r.BCKP tag=TAG20130624T172846 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-JUN-13
Starting backup at 24-JUN-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-JUN-13
channel ORA_DISK_1: finished piece 1 at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/818962128_12_%r.BCKP tag=TAG20130624T172848 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 24-JUN-13
Starting backup at 24-JUN-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=12 RECID=6 STAMP=818962143
channel ORA_DISK_1: starting piece 1 at 24-JUN-13
channel ORA_DISK_1: finished piece 1 at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/818962143_13_%r.BCKP tag=TAG20130624T172903 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-JUN-13
Starting Control File and SPFILE Autobackup at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/control_files/cf_c-1341263457-20130624-03.BCKP comment=NONE
Finished Control File and SPFILE Autobackup at 24-JUN-13
RMAN>
|
|
|
|
 Re: Data files backed up to FRA instead of specified location [message #588303 is a reply to message #588297] |
Mon, 24 June 2013 14:32 |
|
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
The first batch of archive logs (seq. 7 - 11) are those created between last backup until current backup:
Quote:
. . . .
Starting backup at 24-JUN-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=7 RECID=1 STAMP=818957424
input archived log thread=1 sequence=8 RECID=2 STAMP=818957451
input archived log thread=1 sequence=9 RECID=3 STAMP=818961866
input archived log thread=1 sequence=10 RECID=4 STAMP=818961882
input archived log thread=1 sequence=11 RECID=5 STAMP=818962126
channel ORA_DISK_1: starting piece 1 at 24-JUN-13
channel ORA_DISK_1: finished piece 1 at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/818962126_11_%r.BCKP tag=TAG20130624T172846 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-JUN-13
. . .
The next archive log (seq. 12) is the one generated at the END of current backup:
Quote:. . .
Starting backup at 24-JUN-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=12 RECID=6 STAMP=818962143
channel ORA_DISK_1: starting piece 1 at 24-JUN-13
channel ORA_DISK_1: finished piece 1 at 24-JUN-13
piece handle=/u01/app/oracle/backupsets/818962143_13_%r.BCKP tag=TAG20130624T172903 comment=NONE
. . .
PS: Once you configure the default backup location, there is no need to repeat it on the on the BACKUP command.
[Updated on: Mon, 24 June 2013 14:43] by Moderator Report message to a moderator |
|
|
|
| Re: Data files backed up to FRA instead of specified location [message #588305 is a reply to message #588303] |
Mon, 24 June 2013 14:39 |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
Thank you LKBrwn_DBA very much for helping, and for the explanation.
Quote:PS: Once you configure the default backup location, there is no need to repeat it on the on the BACKUP command.
Yes, it makes sense. However, I still don't understand why when I specify an *explicit* location for the backup - it's alright,
But, when I specify an explicit location for the backup and use *PLUS ARCHIVELOG* attribute - the backup of the data files goes to FRA 
Is there a logical explanation? maybe it's a bug?
Regards,
Andrey
[Updated on: Mon, 24 June 2013 14:41] Report message to a moderator |
|
|
|
| Re: Data files backed up to FRA instead of specified location [message #588488 is a reply to message #588305] |
Wed, 26 June 2013 03:35 |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
No logic here, I guess...
Thanks LKBrwn_DBA for your help!
If it helpes anyone, I have performed the following commands in RMAN and the Archive redo's, Spfile, Control file & data files were backed up to the location I wanted them to with success:
[oracle@testing-oracle-1 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 26 08:23:25 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1341263457)
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backupsets/control_files/cf_%F.BCKP';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backupsets/control_files/cf_%F.BCKP';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/app/oracle/backupsets/%t_%s_%r.BCKP';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/app/oracle/backupsets/%t_%s_%r.BCKP';
new RMAN configuration parameters are successfully stored
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters are successfully stored
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG ;
Starting backup at 26-JUN-13
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=49 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=7 RECID=1 STAMP=819102242
channel ORA_DISK_1: starting piece 1 at 26-JUN-13
channel ORA_DISK_1: finished piece 1 at 26-JUN-13
piece handle=/u01/app/oracle/backupsets/819102242_1_%r.BCKP tag=TAG20130626T082402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JUN-13
Starting backup at 26-JUN-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 26-JUN-13
channel ORA_DISK_1: finished piece 1 at 26-JUN-13
piece handle=/u01/app/oracle/backupsets/819102244_2_%r.BCKP tag=TAG20130626T082403 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 26-JUN-13
Starting backup at 26-JUN-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=8 RECID=2 STAMP=819102269
channel ORA_DISK_1: starting piece 1 at 26-JUN-13
channel ORA_DISK_1: finished piece 1 at 26-JUN-13
piece handle=/u01/app/oracle/backupsets/819102269_3_%r.BCKP tag=TAG20130626T082429 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JUN-13
Starting Control File and SPFILE Autobackup at 26-JUN-13
piece handle=/u01/app/oracle/backupsets/control_files/cf_c-1341263457-20130626-00.BCKP comment=NONE
Finished Control File and SPFILE Autobackup at 26-JUN-13
RMAN>
Best Regards,
Andrey
|
|
|
|
Goto Forum:
Current Time: Thu Dec 26 19:00:35 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
