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 Go to next message
Andrey_R
Messages: 191
Registered: January 2012
Location: Euro-Asia
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 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 447
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 Go to previous messageGo to next message
Andrey_R
Messages: 191
Registered: January 2012
Location: Euro-Asia
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>
icon6.gif  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 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 447
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 Go to previous messageGo to next message
Andrey_R
Messages: 191
Registered: January 2012
Location: Euro-Asia
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 Sad

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 Go to previous message
Andrey_R
Messages: 191
Registered: January 2012
Location: Euro-Asia
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

Previous Topic: RMAN-03002: failure of Duplicate Db command at 06/22/2013 18:36:23
Next Topic: Trace of calls made by OSB module for cloud backup to S3
Goto Forum:
  


Current Time: Tue Nov 25 20:01:23 CST 2014

Total time taken to generate the page: 0.09296 seconds