We will continue with the online backups.
Online Database backups -
To be able to do the online backups, your database has to be in archivelog mode. You can chek it with
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/oarch
Oldest online log sequence 24
Next log sequence to archive 26
Current log sequence 26
If your database is in noarchivelog mode, you should set the log_archive_dest parameter to the path were you want to store your archived logs and then:
sqlplus "/as sysdba"
shu immediate;
startup mount;
alter database archivelog;
alter database open;
alter system switch logfile;
Online databae backup -
RMAN> backup format='/backup/database/online_%d_%U.bkp' database plus archivelog format='/backup/archivelogs/archives_%d_%U.bkp';
Starting backup at 26-JAN-12
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device
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=16 RECID=3 STAMP=773328689
input archived log thread=1 sequence=17 RECID=4 STAMP=773328729
input archived log thread=1 sequence=18 RECID=5 STAMP=773362834
input archived log thread=1 sequence=19 RECID=6 STAMP=773446113
input archived log thread=1 sequence=20 RECID=7 STAMP=773503930
input archived log thread=1 sequence=21 RECID=8 STAMP=773504013
input archived log thread=1 sequence=22 RECID=9 STAMP=773505766
input archived log thread=1 sequence=23 RECID=10 STAMP=773505832
input archived log thread=1 sequence=24 RECID=11 STAMP=773564439
input archived log thread=1 sequence=25 RECID=12 STAMP=773586516
input archived log thread=1 sequence=26 RECID=13 STAMP=773588930
input archived log thread=1 sequence=27 RECID=14 STAMP=773589076
input archived log thread=1 sequence=28 RECID=15 STAMP=773589675
input archived log thread=1 sequence=29 RECID=16 STAMP=773589793
input archived log thread=1 sequence=30 RECID=17 STAMP=773589987
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1an1o2vd_1_1.bkp tag=TAG20120126T140634 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:48
Finished backup at 26-JAN-12
Starting backup at 26-JAN-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/oradata/system01.dbf
input datafile file number=00002 name=/oracle/oradata/sysaux01.dbf
input datafile file number=00003 name=/oracle/oradata/undotbs1.dbf
input datafile file number=00004 name=/oracle/oradata/users01.dbf
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/database/online_BTEST_1bn1o333_1_1.bkp tag=TAG20120126T140829 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
Finished backup at 26-JAN-12
Starting backup at 26-JAN-12
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=31 RECID=18 STAMP=773590206
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1cn1o362_1_1.bkp tag=TAG20120126T141008 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-01 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Tablespace backup -
[oracle@btest ~]$ rman target bkpuser/testOra1 catalog rcat/testOra1@rcat
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 26 14:41:30 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: BTEST (DBID=4236471253)
connected to recovery catalog database
RMAN> backup tablespace users format='/backup/database/users_%d_%U.bkp';
Starting backup at 26-JAN-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/oracle/oradata/users01.dbf
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/database/users_BTEST_1en1o54f_1_1.bkp tag=TAG20120126T144323 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-02 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
RMAN> list backup of tablespace users;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1129 Full 355.20M DISK 00:01:25 26-JAN-12
BP Key: 1145 Status: AVAILABLE Compressed: NO Tag: TAG20120126T140829
Piece Name: /backup/database/online_BTEST_1bn1o333_1_1.bkp
List of Datafiles in backup set 1129
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 437015 26-JAN-12 /oracle/oradata/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1196 Full 1.03M DISK 00:00:01 26-JAN-12
BP Key: 1199 Status: AVAILABLE Compressed: NO Tag: TAG20120126T144323
Piece Name: /backup/database/users_BTEST_1en1o54f_1_1.bkp
List of Datafiles in backup set 1196
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 438032 26-JAN-12 /oracle/oradata/users01.dbf
Datafile backup -
[oracle@btest ~]$ rman target bkpuser/testOra1 catalog rcat/testOra1@rcat
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 26 14:44:30 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: BTEST (DBID=4236471253)
connected to recovery catalog database
RMAN> backup datafile 4 format='/backup/database/users_data_%d_%U.bkp';
Starting backup at 26-JAN-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/oracle/oradata/users01.dbf
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/database/users_data_BTEST_1gn1o57l_1_1.bkp tag=TAG20120126T144507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-03 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Archived Redo Log Backups -
[oracle@btest ~]$ rman target bkpuser/testOra1 catalog rcat/testOra1@rcat
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 26 14:46:57 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: BTEST (DBID=4236471253)
connected to recovery catalog database
RMAN> backup archivelog all format='/backup/archivelogs/archives_%d_%U.bkp';
Starting backup at 26-JAN-12
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device
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=16 RECID=3 STAMP=773328689
input archived log thread=1 sequence=17 RECID=4 STAMP=773328729
input archived log thread=1 sequence=18 RECID=5 STAMP=773362834
input archived log thread=1 sequence=19 RECID=6 STAMP=773446113
input archived log thread=1 sequence=20 RECID=7 STAMP=773503930
input archived log thread=1 sequence=21 RECID=8 STAMP=773504013
input archived log thread=1 sequence=22 RECID=9 STAMP=773505766
input archived log thread=1 sequence=23 RECID=10 STAMP=773505832
input archived log thread=1 sequence=24 RECID=11 STAMP=773564439
input archived log thread=1 sequence=25 RECID=12 STAMP=773586516
input archived log thread=1 sequence=26 RECID=13 STAMP=773588930
input archived log thread=1 sequence=27 RECID=14 STAMP=773589076
input archived log thread=1 sequence=28 RECID=15 STAMP=773589675
input archived log thread=1 sequence=29 RECID=16 STAMP=773589793
input archived log thread=1 sequence=30 RECID=17 STAMP=773589987
input archived log thread=1 sequence=31 RECID=18 STAMP=773590206
input archived log thread=1 sequence=32 RECID=19 STAMP=773592455
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1in1o5cb_1_1.bkp tag=TAG20120126T144737 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-04 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Backup archives from specific sequence:
RMAN> backup archivelog from sequence 30 format='/backup/archivelogs/archives_%d_%U.bkp';
Starting backup at 26-JAN-12
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=30 RECID=17 STAMP=773589987
input archived log thread=1 sequence=31 RECID=18 STAMP=773590206
input archived log thread=1 sequence=32 RECID=19 STAMP=773592455
input archived log thread=1 sequence=33 RECID=20 STAMP=773593354
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1kn1o68f_1_1.bkp tag=TAG20120126T150237 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-05 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Backup archives from specific time:
RMAN> backup archivelog from time 'sysdate-1' format='/backup/archivelogs/archives_%d_%U.bkp';
Starting backup at 26-JAN-12
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=24 RECID=11 STAMP=773564439
input archived log thread=1 sequence=25 RECID=12 STAMP=773586516
input archived log thread=1 sequence=26 RECID=13 STAMP=773588930
input archived log thread=1 sequence=27 RECID=14 STAMP=773589076
input archived log thread=1 sequence=28 RECID=15 STAMP=773589675
input archived log thread=1 sequence=29 RECID=16 STAMP=773589793
input archived log thread=1 sequence=30 RECID=17 STAMP=773589987
input archived log thread=1 sequence=31 RECID=18 STAMP=773590206
input archived log thread=1 sequence=32 RECID=19 STAMP=773592455
input archived log thread=1 sequence=33 RECID=20 STAMP=773593354
input archived log thread=1 sequence=34 RECID=21 STAMP=773593846
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1mn1o6nr_1_1.bkp tag=TAG20120126T151048 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-06 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Backup archives and delete them:
RMAN> backup archivelog all format='/backup/archivelogs/archives_%d_%U.bkp' delete input;
Starting backup at 26-JAN-12
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=16 RECID=3 STAMP=773328689
input archived log thread=1 sequence=17 RECID=4 STAMP=773328729
input archived log thread=1 sequence=18 RECID=5 STAMP=773362834
input archived log thread=1 sequence=19 RECID=6 STAMP=773446113
input archived log thread=1 sequence=20 RECID=7 STAMP=773503930
input archived log thread=1 sequence=21 RECID=8 STAMP=773504013
input archived log thread=1 sequence=22 RECID=9 STAMP=773505766
input archived log thread=1 sequence=23 RECID=10 STAMP=773505832
input archived log thread=1 sequence=24 RECID=11 STAMP=773564439
input archived log thread=1 sequence=25 RECID=12 STAMP=773586516
input archived log thread=1 sequence=26 RECID=13 STAMP=773588930
input archived log thread=1 sequence=27 RECID=14 STAMP=773589076
input archived log thread=1 sequence=28 RECID=15 STAMP=773589675
input archived log thread=1 sequence=29 RECID=16 STAMP=773589793
input archived log thread=1 sequence=30 RECID=17 STAMP=773589987
input archived log thread=1 sequence=31 RECID=18 STAMP=773590206
input archived log thread=1 sequence=32 RECID=19 STAMP=773592455
input archived log thread=1 sequence=33 RECID=20 STAMP=773593354
input archived log thread=1 sequence=34 RECID=21 STAMP=773593846
input archived log thread=1 sequence=35 RECID=22 STAMP=773593969
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1on1o6rk_1_1.bkp tag=TAG20120126T151250 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:06
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/oracle/oarch/1_16_769077077.dbf RECID=3 STAMP=773328689
archived log file name=/oracle/oarch/1_17_769077077.dbf RECID=4 STAMP=773328729
archived log file name=/oracle/oarch/1_18_769077077.dbf RECID=5 STAMP=773362834
archived log file name=/oracle/oarch/1_19_769077077.dbf RECID=6 STAMP=773446113
archived log file name=/oracle/oarch/1_20_769077077.dbf RECID=7 STAMP=773503930
archived log file name=/oracle/oarch/1_21_769077077.dbf RECID=8 STAMP=773504013
archived log file name=/oracle/oarch/1_22_769077077.dbf RECID=9 STAMP=773505766
archived log file name=/oracle/oarch/1_23_769077077.dbf RECID=10 STAMP=773505832
archived log file name=/oracle/oarch/1_24_769077077.dbf RECID=11 STAMP=773564439
archived log file name=/oracle/oarch/1_25_769077077.dbf RECID=12 STAMP=773586516
archived log file name=/oracle/oarch/1_26_769077077.dbf RECID=13 STAMP=773588930
archived log file name=/oracle/oarch/1_27_769077077.dbf RECID=14 STAMP=773589076
archived log file name=/oracle/oarch/1_28_769077077.dbf RECID=15 STAMP=773589675
archived log file name=/oracle/oarch/1_29_769077077.dbf RECID=16 STAMP=773589793
archived log file name=/oracle/oarch/1_30_769077077.dbf RECID=17 STAMP=773589987
archived log file name=/oracle/oarch/1_31_769077077.dbf RECID=18 STAMP=773590206
archived log file name=/oracle/oarch/1_32_769077077.dbf RECID=19 STAMP=773592455
archived log file name=/oracle/oarch/1_33_769077077.dbf RECID=20 STAMP=773593354
archived log file name=/oracle/oarch/1_34_769077077.dbf RECID=21 STAMP=773593846
archived log file name=/oracle/oarch/1_35_769077077.dbf RECID=22 STAMP=773593969
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-07 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Control File and Parameter File Backup:
RMAN> backup current controlfile format='/backup/controlfile/control_%d_%U.bkp';
Starting backup at 26-JAN-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/controlfile/control_BTEST_1sn1o76e_1_1.bkp tag=TAG20120126T151836 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-09 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
To be able to do the online backups, your database has to be in archivelog mode. You can chek it with
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/oarch
Oldest online log sequence 24
Next log sequence to archive 26
Current log sequence 26
If your database is in noarchivelog mode, you should set the log_archive_dest parameter to the path were you want to store your archived logs and then:
sqlplus "/as sysdba"
shu immediate;
startup mount;
alter database archivelog;
alter database open;
alter system switch logfile;
Online databae backup -
RMAN> backup format='/backup/database/online_%d_%U.bkp' database plus archivelog format='/backup/archivelogs/archives_%d_%U.bkp';
Starting backup at 26-JAN-12
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device
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=16 RECID=3 STAMP=773328689
input archived log thread=1 sequence=17 RECID=4 STAMP=773328729
input archived log thread=1 sequence=18 RECID=5 STAMP=773362834
input archived log thread=1 sequence=19 RECID=6 STAMP=773446113
input archived log thread=1 sequence=20 RECID=7 STAMP=773503930
input archived log thread=1 sequence=21 RECID=8 STAMP=773504013
input archived log thread=1 sequence=22 RECID=9 STAMP=773505766
input archived log thread=1 sequence=23 RECID=10 STAMP=773505832
input archived log thread=1 sequence=24 RECID=11 STAMP=773564439
input archived log thread=1 sequence=25 RECID=12 STAMP=773586516
input archived log thread=1 sequence=26 RECID=13 STAMP=773588930
input archived log thread=1 sequence=27 RECID=14 STAMP=773589076
input archived log thread=1 sequence=28 RECID=15 STAMP=773589675
input archived log thread=1 sequence=29 RECID=16 STAMP=773589793
input archived log thread=1 sequence=30 RECID=17 STAMP=773589987
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1an1o2vd_1_1.bkp tag=TAG20120126T140634 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:48
Finished backup at 26-JAN-12
Starting backup at 26-JAN-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/oradata/system01.dbf
input datafile file number=00002 name=/oracle/oradata/sysaux01.dbf
input datafile file number=00003 name=/oracle/oradata/undotbs1.dbf
input datafile file number=00004 name=/oracle/oradata/users01.dbf
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/database/online_BTEST_1bn1o333_1_1.bkp tag=TAG20120126T140829 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
Finished backup at 26-JAN-12
Starting backup at 26-JAN-12
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=31 RECID=18 STAMP=773590206
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1cn1o362_1_1.bkp tag=TAG20120126T141008 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-01 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Tablespace backup -
[oracle@btest ~]$ rman target bkpuser/testOra1 catalog rcat/testOra1@rcat
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 26 14:41:30 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: BTEST (DBID=4236471253)
connected to recovery catalog database
RMAN> backup tablespace users format='/backup/database/users_%d_%U.bkp';
Starting backup at 26-JAN-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/oracle/oradata/users01.dbf
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/database/users_BTEST_1en1o54f_1_1.bkp tag=TAG20120126T144323 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-02 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
RMAN> list backup of tablespace users;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1129 Full 355.20M DISK 00:01:25 26-JAN-12
BP Key: 1145 Status: AVAILABLE Compressed: NO Tag: TAG20120126T140829
Piece Name: /backup/database/online_BTEST_1bn1o333_1_1.bkp
List of Datafiles in backup set 1129
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 437015 26-JAN-12 /oracle/oradata/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1196 Full 1.03M DISK 00:00:01 26-JAN-12
BP Key: 1199 Status: AVAILABLE Compressed: NO Tag: TAG20120126T144323
Piece Name: /backup/database/users_BTEST_1en1o54f_1_1.bkp
List of Datafiles in backup set 1196
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 438032 26-JAN-12 /oracle/oradata/users01.dbf
Datafile backup -
[oracle@btest ~]$ rman target bkpuser/testOra1 catalog rcat/testOra1@rcat
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 26 14:44:30 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: BTEST (DBID=4236471253)
connected to recovery catalog database
RMAN> backup datafile 4 format='/backup/database/users_data_%d_%U.bkp';
Starting backup at 26-JAN-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/oracle/oradata/users01.dbf
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/database/users_data_BTEST_1gn1o57l_1_1.bkp tag=TAG20120126T144507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-03 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Archived Redo Log Backups -
[oracle@btest ~]$ rman target bkpuser/testOra1 catalog rcat/testOra1@rcat
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 26 14:46:57 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: BTEST (DBID=4236471253)
connected to recovery catalog database
RMAN> backup archivelog all format='/backup/archivelogs/archives_%d_%U.bkp';
Starting backup at 26-JAN-12
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device
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=16 RECID=3 STAMP=773328689
input archived log thread=1 sequence=17 RECID=4 STAMP=773328729
input archived log thread=1 sequence=18 RECID=5 STAMP=773362834
input archived log thread=1 sequence=19 RECID=6 STAMP=773446113
input archived log thread=1 sequence=20 RECID=7 STAMP=773503930
input archived log thread=1 sequence=21 RECID=8 STAMP=773504013
input archived log thread=1 sequence=22 RECID=9 STAMP=773505766
input archived log thread=1 sequence=23 RECID=10 STAMP=773505832
input archived log thread=1 sequence=24 RECID=11 STAMP=773564439
input archived log thread=1 sequence=25 RECID=12 STAMP=773586516
input archived log thread=1 sequence=26 RECID=13 STAMP=773588930
input archived log thread=1 sequence=27 RECID=14 STAMP=773589076
input archived log thread=1 sequence=28 RECID=15 STAMP=773589675
input archived log thread=1 sequence=29 RECID=16 STAMP=773589793
input archived log thread=1 sequence=30 RECID=17 STAMP=773589987
input archived log thread=1 sequence=31 RECID=18 STAMP=773590206
input archived log thread=1 sequence=32 RECID=19 STAMP=773592455
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1in1o5cb_1_1.bkp tag=TAG20120126T144737 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-04 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Backup archives from specific sequence:
RMAN> backup archivelog from sequence 30 format='/backup/archivelogs/archives_%d_%U.bkp';
Starting backup at 26-JAN-12
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=30 RECID=17 STAMP=773589987
input archived log thread=1 sequence=31 RECID=18 STAMP=773590206
input archived log thread=1 sequence=32 RECID=19 STAMP=773592455
input archived log thread=1 sequence=33 RECID=20 STAMP=773593354
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1kn1o68f_1_1.bkp tag=TAG20120126T150237 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-05 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Backup archives from specific time:
RMAN> backup archivelog from time 'sysdate-1' format='/backup/archivelogs/archives_%d_%U.bkp';
Starting backup at 26-JAN-12
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=24 RECID=11 STAMP=773564439
input archived log thread=1 sequence=25 RECID=12 STAMP=773586516
input archived log thread=1 sequence=26 RECID=13 STAMP=773588930
input archived log thread=1 sequence=27 RECID=14 STAMP=773589076
input archived log thread=1 sequence=28 RECID=15 STAMP=773589675
input archived log thread=1 sequence=29 RECID=16 STAMP=773589793
input archived log thread=1 sequence=30 RECID=17 STAMP=773589987
input archived log thread=1 sequence=31 RECID=18 STAMP=773590206
input archived log thread=1 sequence=32 RECID=19 STAMP=773592455
input archived log thread=1 sequence=33 RECID=20 STAMP=773593354
input archived log thread=1 sequence=34 RECID=21 STAMP=773593846
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1mn1o6nr_1_1.bkp tag=TAG20120126T151048 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-06 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Backup archives and delete them:
RMAN> backup archivelog all format='/backup/archivelogs/archives_%d_%U.bkp' delete input;
Starting backup at 26-JAN-12
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=16 RECID=3 STAMP=773328689
input archived log thread=1 sequence=17 RECID=4 STAMP=773328729
input archived log thread=1 sequence=18 RECID=5 STAMP=773362834
input archived log thread=1 sequence=19 RECID=6 STAMP=773446113
input archived log thread=1 sequence=20 RECID=7 STAMP=773503930
input archived log thread=1 sequence=21 RECID=8 STAMP=773504013
input archived log thread=1 sequence=22 RECID=9 STAMP=773505766
input archived log thread=1 sequence=23 RECID=10 STAMP=773505832
input archived log thread=1 sequence=24 RECID=11 STAMP=773564439
input archived log thread=1 sequence=25 RECID=12 STAMP=773586516
input archived log thread=1 sequence=26 RECID=13 STAMP=773588930
input archived log thread=1 sequence=27 RECID=14 STAMP=773589076
input archived log thread=1 sequence=28 RECID=15 STAMP=773589675
input archived log thread=1 sequence=29 RECID=16 STAMP=773589793
input archived log thread=1 sequence=30 RECID=17 STAMP=773589987
input archived log thread=1 sequence=31 RECID=18 STAMP=773590206
input archived log thread=1 sequence=32 RECID=19 STAMP=773592455
input archived log thread=1 sequence=33 RECID=20 STAMP=773593354
input archived log thread=1 sequence=34 RECID=21 STAMP=773593846
input archived log thread=1 sequence=35 RECID=22 STAMP=773593969
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/archivelogs/archives_BTEST_1on1o6rk_1_1.bkp tag=TAG20120126T151250 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:06
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/oracle/oarch/1_16_769077077.dbf RECID=3 STAMP=773328689
archived log file name=/oracle/oarch/1_17_769077077.dbf RECID=4 STAMP=773328729
archived log file name=/oracle/oarch/1_18_769077077.dbf RECID=5 STAMP=773362834
archived log file name=/oracle/oarch/1_19_769077077.dbf RECID=6 STAMP=773446113
archived log file name=/oracle/oarch/1_20_769077077.dbf RECID=7 STAMP=773503930
archived log file name=/oracle/oarch/1_21_769077077.dbf RECID=8 STAMP=773504013
archived log file name=/oracle/oarch/1_22_769077077.dbf RECID=9 STAMP=773505766
archived log file name=/oracle/oarch/1_23_769077077.dbf RECID=10 STAMP=773505832
archived log file name=/oracle/oarch/1_24_769077077.dbf RECID=11 STAMP=773564439
archived log file name=/oracle/oarch/1_25_769077077.dbf RECID=12 STAMP=773586516
archived log file name=/oracle/oarch/1_26_769077077.dbf RECID=13 STAMP=773588930
archived log file name=/oracle/oarch/1_27_769077077.dbf RECID=14 STAMP=773589076
archived log file name=/oracle/oarch/1_28_769077077.dbf RECID=15 STAMP=773589675
archived log file name=/oracle/oarch/1_29_769077077.dbf RECID=16 STAMP=773589793
archived log file name=/oracle/oarch/1_30_769077077.dbf RECID=17 STAMP=773589987
archived log file name=/oracle/oarch/1_31_769077077.dbf RECID=18 STAMP=773590206
archived log file name=/oracle/oarch/1_32_769077077.dbf RECID=19 STAMP=773592455
archived log file name=/oracle/oarch/1_33_769077077.dbf RECID=20 STAMP=773593354
archived log file name=/oracle/oarch/1_34_769077077.dbf RECID=21 STAMP=773593846
archived log file name=/oracle/oarch/1_35_769077077.dbf RECID=22 STAMP=773593969
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-07 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12
Control File and Parameter File Backup:
RMAN> backup current controlfile format='/backup/controlfile/control_%d_%U.bkp';
Starting backup at 26-JAN-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 26-JAN-12
channel ORA_DISK_1: finished piece 1 at 26-JAN-12
piece handle=/backup/controlfile/control_BTEST_1sn1o76e_1_1.bkp tag=TAG20120126T151836 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-JAN-12
Starting Control File and SPFILE Autobackup at 26-JAN-12
piece handle=/backup/controlfile/c-4236471253-20120126-09 comment=NONE
Finished Control File and SPFILE Autobackup at 26-JAN-12