博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
rman备份指定备份集对应文件
阅读量:2042 次
发布时间:2019-04-28

本文共 21243 字,大约阅读时间需要 70 分钟。

例如备份user表空间,指定备份集对应文件

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on 9 10:32:05 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> set line 160

SQL> set wrap off
SQL> select file_id,file_name from dba_data_files where tablespace_name='JYC';

   FILE_ID FILE_NAME

---------- -----------------------------------------------------------------------------------------------------------------------------------------------------
         5 /oracle/oradata/pri/jyc.dbf
         7 /oracle/oradata/pri/jyc2.dbf
         8 /oracle/oradata/pri/jyc3.dbf
         9 /oracle/oradata/pri/jyc4.dbf
        10 /oracle/oradata/pri/jyc5.dbf
        11 /oracle/oradata/pri/jyc6.dbf
        12 /oracle/oradata/pri/jyc7.dbf
        13 /oracle/oradata/pri/jyc8.dbf

8 rows selected.

SQL> 

0级备份指定备份集数据文件

注意:datafile只能用逗,号隔开,不可以用中横杠-这种方式。备份路径必须在通道后指定,否则会备份到$ORACLE_HOME/dbs下。

错误:

正确指定如下:(可惜发现备份了2次,去掉tablespace JYC则正常)

run {allocate channel t1 type disk format '/home/oracle/rman/jyc0_%U';allocate channel t2 type disk format '/home/oracle/rman/jyc0_%U';allocate channel t3 type disk format '/home/oracle/rman/jyc0_%U';allocate channel t4 type disk format '/home/oracle/rman/jyc0_%U';backup as backupset incremental level=0 tablespace JYCdatafile 5,7,8 channel t1 tag=jyc0datafile 9,10 channel t2 tag=jyc0datafile 11,12 channel t3 tag=jyc0datafile 13 channel t4 tag=jyc0;}

RMAN> run {

2> allocate channel t1 type disk format '/home/oracle/rman/jyc0_%U';
3> allocate channel t2 type disk format '/home/oracle/rman/jyc0_%U';
4> allocate channel t3 type disk format '/home/oracle/rman/jyc0_%U';
5> allocate channel t4 type disk format '/home/oracle/rman/jyc0_%U';
6> backup as backupset incremental level=0 tablespace JYC
7> datafile 5,7,8 channel t1 tag=jyc0
8> datafile 9,10 channel t2 tag=jyc0
9> datafile 11,12 channel t3 tag=jyc0
10> datafile 13 channel t4 tag=jyc0;
11> }

allocated channel: t1

channel t1: SID=171 device type=DISK

allocated channel: t2

channel t2: SID=254 device type=DISK

allocated channel: t3

channel t3: SID=89 device type=DISK

allocated channel: t4

channel t4: SID=249 device type=DISK

Starting backup at 19-321

channel t1: starting incremental level 0 datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00005 name=/oracle/oradata/pri/jyc.dbf
input datafile file number=00007 name=/oracle/oradata/pri/jyc2.dbf
input datafile file number=00008 name=/oracle/oradata/pri/jyc3.dbf
channel t1: starting piece 1 at 19-321
channel t2: starting incremental level 0 datafile backup set
channel t2: specifying datafile(s) in backup set
input datafile file number=00005 name=/oracle/oradata/pri/jyc.dbf
input datafile file number=00013 name=/oracle/oradata/pri/jyc8.dbf
channel t2: starting piece 1 at 19-321
channel t3: starting incremental level 0 datafile backup set
channel t3: specifying datafile(s) in backup set
input datafile file number=00007 name=/oracle/oradata/pri/jyc2.dbf
input datafile file number=00010 name=/oracle/oradata/pri/jyc5.dbf
channel t3: starting piece 1 at 19-321
channel t4: starting incremental level 0 datafile backup set
channel t4: specifying datafile(s) in backup set
input datafile file number=00008 name=/oracle/oradata/pri/jyc3.dbf
input datafile file number=00011 name=/oracle/oradata/pri/jyc6.dbf
channel t4: starting piece 1 at 19-321
channel t1: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_1rvq4e8v_1_1 tag=JYC0 comment=NONE
channel t1: backup set complete, elapsed time: 00:00:00
channel t1: starting incremental level 0 datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00009 name=/oracle/oradata/pri/jyc4.dbf
input datafile file number=00012 name=/oracle/oradata/pri/jyc7.dbf
channel t1: starting piece 1 at 19-321
channel t2: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_1svq4e8v_1_1 tag=TAG20210319T102743 comment=NONE
channel t2: backup set complete, elapsed time: 00:00:00
channel t2: starting incremental level 0 datafile backup set
channel t2: specifying datafile(s) in backup set
input datafile file number=00009 name=/oracle/oradata/pri/jyc4.dbf
input datafile file number=00010 name=/oracle/oradata/pri/jyc5.dbf
channel t2: starting piece 1 at 19-321
channel t1: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_1vvq4e8v_1_1 tag=TAG20210319T102743 comment=NONE
channel t1: backup set complete, elapsed time: 00:00:00
channel t3: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_1tvq4e8v_1_1 tag=TAG20210319T102743 comment=NONE
channel t3: backup set complete, elapsed time: 00:00:00
channel t3: starting incremental level 0 datafile backup set
channel t3: specifying datafile(s) in backup set
input datafile file number=00011 name=/oracle/oradata/pri/jyc6.dbf
input datafile file number=00012 name=/oracle/oradata/pri/jyc7.dbf
channel t3: starting piece 1 at 19-321
channel t4: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_1uvq4e8v_1_1 tag=TAG20210319T102743 comment=NONE
channel t4: backup set complete, elapsed time: 00:00:00
channel t4: starting incremental level 0 datafile backup set
channel t4: specifying datafile(s) in backup set
input datafile file number=00013 name=/oracle/oradata/pri/jyc8.dbf
channel t4: starting piece 1 at 19-321
channel t2: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_20vq4e8v_1_1 tag=JYC0 comment=NONE
channel t2: backup set complete, elapsed time: 00:00:00
channel t3: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_21vq4e8v_1_1 tag=JYC0 comment=NONE
channel t3: backup set complete, elapsed time: 00:00:00
channel t4: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_22vq4e8v_1_1 tag=JYC0 comment=NONE
channel t4: backup set complete, elapsed time: 00:00:01
Finished backup at 19-321
released channel: t1
released channel: t2
released channel: t3
released channel: t4

RMAN> list backup tag=jyc0;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
37      Incr 0  1.17M      DISK        00:00:00     19-321     
        BP Key: 37   Status: AVAILABLE  Compressed: NO  Tag: JYC0
        Piece Name: /home/oracle/rman/jyc0_1rvq4e8v_1_1
  List of Datafiles in backup set 37
  File LV Type Ckp SCN    Ckp Time   Name
  ---- -- ---- ---------- ---------- ----
  5    0  Incr 1063259    19-321 /oracle/oradata/pri/jyc.dbf
  7    0  Incr 1063259    19-321 /oracle/oradata/pri/jyc2.dbf
  8    0  Incr 1063259    19-321 /oracle/oradata/pri/jyc3.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------
42      Incr 0  168.00K    DISK        00:00:00     19-321     
        BP Key: 42   Status: AVAILABLE  Compressed: NO  Tag: JYC0
        Piece Name: /home/oracle/rman/jyc0_20vq4e8v_1_1
  List of Datafiles in backup set 42
  File LV Type Ckp SCN    Ckp Time   Name
  ---- -- ---- ---------- ---------- ----
  9    0  Incr 1063264    19-321 /oracle/oradata/pri/jyc4.dbf
  10   0  Incr 1063264    19-321 /oracle/oradata/pri/jyc5.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------
43      Incr 0  168.00K    DISK        00:00:00     19-321     
        BP Key: 43   Status: AVAILABLE  Compressed: NO  Tag: JYC0
        Piece Name: /home/oracle/rman/jyc0_21vq4e8v_1_1
  List of Datafiles in backup set 43
  File LV Type Ckp SCN    Ckp Time   Name
  ---- -- ---- ---------- ---------- ----
  11   0  Incr 1063265    19-321 /oracle/oradata/pri/jyc6.dbf
  12   0  Incr 1063265    19-321 /oracle/oradata/pri/jyc7.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------
44      Incr 0  96.00K     DISK        00:00:00     19-321     
        BP Key: 44   Status: AVAILABLE  Compressed: NO  Tag: JYC0
        Piece Name: /home/oracle/rman/jyc0_22vq4e8v_1_1
  List of Datafiles in backup set 44
  File LV Type Ckp SCN    Ckp Time   Name
  ---- -- ---- ---------- ---------- ----
  13   0  Incr 1063266    19-321 /oracle/oradata/pri/jyc8.dbf

 

不指定备份集对应数据文件的话是正常的。但这不是我想要的。

run {allocate channel t1 type disk;allocate channel t2 type disk;allocate channel t3 type disk;allocate channel t4 type disk;backup as backupset incremental level=0 tablespace JYC format '/home/oracle/rman/jyc0_%U' tag=jyc0;}

RMAN> run {
2> allocate channel t1 type disk;
3> allocate channel t2 type disk;
4> allocate channel t3 type disk;
5> allocate channel t4 type disk;
6> backup as backupset incremental level=0 tablespace JYC format '/home/oracle/rman/jyc0_%U' tag=jyc0;
7> }
allocated channel: t1
channel t1: SID=88 device type=DISK
allocated channel: t2
channel t2: SID=255 device type=DISK
allocated channel: t3
channel t3: SID=9 device type=DISK
allocated channel: t4
channel t4: SID=87 device type=DISK
Starting backup at 19-321
channel t1: starting incremental level 0 datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00005 name=/oracle/oradata/pri/jyc.dbf
input datafile file number=00013 name=/oracle/oradata/pri/jyc8.dbf
channel t1: starting piece 1 at 19-321
channel t2: starting incremental level 0 datafile backup set
channel t2: specifying datafile(s) in backup set
input datafile file number=00007 name=/oracle/oradata/pri/jyc2.dbf
input datafile file number=00010 name=/oracle/oradata/pri/jyc5.dbf
channel t2: starting piece 1 at 19-321
channel t3: starting incremental level 0 datafile backup set
channel t3: specifying datafile(s) in backup set
input datafile file number=00008 name=/oracle/oradata/pri/jyc3.dbf
input datafile file number=00011 name=/oracle/oradata/pri/jyc6.dbf
channel t3: starting piece 1 at 19-321
channel t4: starting incremental level 0 datafile backup set
channel t4: specifying datafile(s) in backup set
input datafile file number=00009 name=/oracle/oradata/pri/jyc4.dbf
input datafile file number=00012 name=/oracle/oradata/pri/jyc7.dbf
channel t4: starting piece 1 at 19-321
channel t1: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_4cvq5fdk_1_1 tag=JYC0 comment=NONE
channel t1: backup set complete, elapsed time: 00:00:00
channel t2: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_4dvq5fdk_1_1 tag=JYC0 comment=NONE
channel t2: backup set complete, elapsed time: 00:00:00
channel t3: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_4evq5fdk_1_1 tag=JYC0 comment=NONE
channel t3: backup set complete, elapsed time: 00:00:00
channel t4: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc0_4fvq5fdk_1_1 tag=JYC0 comment=NONE
channel t4: backup set complete, elapsed time: 00:00:00
Finished backup at 19-321
released channel: t1
released channel: t2
released channel: t3
released channel: t4

去掉tablespace JYC则正常:

run {allocate channel t1 type disk format '/home/oracle/rman/jyc0_%U';allocate channel t2 type disk format '/home/oracle/rman/jyc0_%U';allocate channel t3 type disk format '/home/oracle/rman/jyc0_%U';allocate channel t4 type disk format '/home/oracle/rman/jyc0_%U';backup as backupset incremental level=0datafile 5,7,8 channel t1 tag=jyc0datafile 9,10 channel t2 tag=jyc0datafile 11,12 channel t3 tag=jyc0datafile 13 channel t4 tag=jyc0;}

RMAN> run {

2> allocate channel t1 type disk format '/home/oracle/rman/jyc0_%U';
3> allocate channel t2 type disk format '/home/oracle/rman/jyc0_%U';
4> allocate channel t3 type disk format '/home/oracle/rman/jyc0_%U';
5> allocate channel t4 type disk format '/home/oracle/rman/jyc0_%U';
6> backup as backupset incremental level=0
7> datafile 5,7,8 channel t1 tag=jyc0
8> datafile 9,10 channel t2 tag=jyc0
9> datafile 11,12 channel t3 tag=jyc0
10> datafile 13 channel t4 tag=jyc0;
11> }

allocated channel: t1

channel t1: SID=87 device type=DISK

allocated channel: t2

channel t2: SID=172 device type=DISK

allocated channel: t3

channel t3: SID=253 device type=DISK

allocated channel: t4

channel t4: SID=89 device type=DISK

Starting backup at 22-321

channel t1: starting incremental level 0 datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00005 name=/oracle/oradata/pri/jyc.dbf
input datafile file number=00007 name=/oracle/oradata/pri/jyc2.dbf
input datafile file number=00008 name=/oracle/oradata/pri/jyc3.dbf
channel t1: starting piece 1 at 22-321
channel t2: starting incremental level 0 datafile backup set
channel t2: specifying datafile(s) in backup set
input datafile file number=00009 name=/oracle/oradata/pri/jyc4.dbf
input datafile file number=00010 name=/oracle/oradata/pri/jyc5.dbf
channel t2: starting piece 1 at 22-321
channel t3: starting incremental level 0 datafile backup set
channel t3: specifying datafile(s) in backup set
input datafile file number=00011 name=/oracle/oradata/pri/jyc6.dbf
input datafile file number=00012 name=/oracle/oradata/pri/jyc7.dbf
channel t3: starting piece 1 at 22-321
channel t4: starting incremental level 0 datafile backup set
channel t4: specifying datafile(s) in backup set
input datafile file number=00013 name=/oracle/oradata/pri/jyc8.dbf
channel t4: starting piece 1 at 22-321
channel t1: finished piece 1 at 22-321
piece handle=/home/oracle/rman/jyc0_4kvqcab9_1_1 tag=JYC0 comment=NONE
channel t1: backup set complete, elapsed time: 00:00:00
channel t2: finished piece 1 at 22-321
piece handle=/home/oracle/rman/jyc0_4lvqcab9_1_1 tag=JYC0 comment=NONE
channel t2: backup set complete, elapsed time: 00:00:00
channel t3: finished piece 1 at 22-321
piece handle=/home/oracle/rman/jyc0_4mvqcab9_1_1 tag=JYC0 comment=NONE
channel t3: backup set complete, elapsed time: 00:00:00
channel t4: finished piece 1 at 22-321
piece handle=/home/oracle/rman/jyc0_4nvqcab9_1_1 tag=JYC0 comment=NONE
channel t4: backup set complete, elapsed time: 00:00:00
Finished backup at 22-321
released channel: t1
released channel: t2
released channel: t3
released channel: t4

或者:

run {allocate channel t1 type disk;allocate channel t2 type disk;allocate channel t3 type disk;allocate channel t4 type disk;backup as backupset incremental level=0 format '/home/oracle/rman/jyc0_%U'datafile 5,7,8 channel t1 tag=jyc00datafile 9,10 channel t2 tag=jyc00datafile 11,12 channel t3 tag=jyc00datafile 13 channel t4 tag=jyc00;}

RMAN> run {

2> allocate channel t1 type disk;
3> allocate channel t2 type disk;
4> allocate channel t3 type disk;
5> allocate channel t4 type disk;
6> backup as backupset incremental level=0 format '/home/oracle/rman/jyc0_%U'
7> datafile 5,7,8 channel t1 tag=jyc00
8> datafile 9,10 channel t2 tag=jyc00
9> datafile 11,12 channel t3 tag=jyc00
10> datafile 13 channel t4 tag=jyc00;
11> }

allocated channel: t1

channel t1: SID=87 device type=DISK

allocated channel: t2

channel t2: SID=172 device type=DISK

allocated channel: t3

channel t3: SID=253 device type=DISK

allocated channel: t4

channel t4: SID=89 device type=DISK

Starting backup at 22-321

channel t1: starting incremental level 0 datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00005 name=/oracle/oradata/pri/jyc.dbf
input datafile file number=00007 name=/oracle/oradata/pri/jyc2.dbf
input datafile file number=00008 name=/oracle/oradata/pri/jyc3.dbf
channel t1: starting piece 1 at 22-321
channel t2: starting incremental level 0 datafile backup set
channel t2: specifying datafile(s) in backup set
input datafile file number=00009 name=/oracle/oradata/pri/jyc4.dbf
input datafile file number=00010 name=/oracle/oradata/pri/jyc5.dbf
channel t2: starting piece 1 at 22-321
channel t3: starting incremental level 0 datafile backup set
channel t3: specifying datafile(s) in backup set
input datafile file number=00011 name=/oracle/oradata/pri/jyc6.dbf
input datafile file number=00012 name=/oracle/oradata/pri/jyc7.dbf
channel t3: starting piece 1 at 22-321
channel t4: starting incremental level 0 datafile backup set
channel t4: specifying datafile(s) in backup set
input datafile file number=00013 name=/oracle/oradata/pri/jyc8.dbf
channel t4: starting piece 1 at 22-321
channel t1: finished piece 1 at 22-321
piece handle=/home/oracle/rman/jyc0_4ovqcm2u_1_1 tag=JYC00 comment=NONE
channel t1: backup set complete, elapsed time: 00:00:00
channel t2: finished piece 1 at 22-321
piece handle=/home/oracle/rman/jyc0_4pvqcm2u_1_1 tag=JYC00 comment=NONE
channel t2: backup set complete, elapsed time: 00:00:00
channel t3: finished piece 1 at 22-321
piece handle=/home/oracle/rman/jyc0_4qvqcm2u_1_1 tag=JYC00 comment=NONE
channel t3: backup set complete, elapsed time: 00:00:01
channel t4: finished piece 1 at 22-321
piece handle=/home/oracle/rman/jyc0_4rvqcm2u_1_1 tag=JYC00 comment=NONE
channel t4: backup set complete, elapsed time: 00:00:01
Finished backup at 22-321
released channel: t1
released channel: t2
released channel: t3
released channel: t4

RMAN> list backup tag=jyc00;   

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
129     Incr 0  1.17M      DISK        00:00:00     22-321     
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: JYC00
        Piece Name: /home/oracle/rman/jyc0_4ovqcm2u_1_1
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time   Name
  ---- -- ---- ---------- ---------- ----
  5    0  Incr 1167438    22-321 /oracle/oradata/pri/jyc.dbf
  7    0  Incr 1167438    22-321 /oracle/oradata/pri/jyc2.dbf
  8    0  Incr 1167438    22-321 /oracle/oradata/pri/jyc3.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------
130     Incr 0  168.00K    DISK        00:00:00     22-321     
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: JYC00
        Piece Name: /home/oracle/rman/jyc0_4pvqcm2u_1_1
  List of Datafiles in backup set 130
  File LV Type Ckp SCN    Ckp Time   Name
  ---- -- ---- ---------- ---------- ----
  9    0  Incr 1167439    22-321 /oracle/oradata/pri/jyc4.dbf
  10   0  Incr 1167439    22-321 /oracle/oradata/pri/jyc5.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------
131     Incr 0  168.00K    DISK        00:00:00     22-321     
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: JYC00
        Piece Name: /home/oracle/rman/jyc0_4qvqcm2u_1_1
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time   Name
  ---- -- ---- ---------- ---------- ----
  11   0  Incr 1167440    22-321 /oracle/oradata/pri/jyc6.dbf
  12   0  Incr 1167440    22-321 /oracle/oradata/pri/jyc7.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------
132     Incr 0  96.00K     DISK        00:00:00     22-321     
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: JYC00
        Piece Name: /home/oracle/rman/jyc0_4rvqcm2u_1_1
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time   Name
  ---- -- ---- ---------- ---------- ----
  13   0  Incr 1167441    22-321 /oracle/oradata/pri/jyc8.dbf

RMAN> 

 

1级增量备份:文件放在一个备份集里。

run {                                                                                          allocate channel t1 type disk;                                                                 backup incremental level=1 tablespace JYC filesperset 200 format '/home/oracle/rman/jyc1_%U' tag=jyc1;release channel t1;                                                                            }

RMAN> run {                                                                                          

2> allocate channel t1 type disk;                                                                 
3> backup incremental level=1 tablespace JYC filesperset 200 format '/home/oracle/rman/jyc1_%U' tag=jyc1;
4> release channel t1;                                                                            
5> }  

using target database control file instead of recovery catalog

allocated channel: t1
channel t1: SID=249 device type=DISK

Starting backup at 19-321

channel t1: starting incremental level 1 datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00005 name=/oracle/oradata/pri/jyc.dbf
input datafile file number=00007 name=/oracle/oradata/pri/jyc2.dbf
input datafile file number=00008 name=/oracle/oradata/pri/jyc3.dbf
input datafile file number=00009 name=/oracle/oradata/pri/jyc4.dbf
input datafile file number=00010 name=/oracle/oradata/pri/jyc5.dbf
input datafile file number=00011 name=/oracle/oradata/pri/jyc6.dbf
input datafile file number=00012 name=/oracle/oradata/pri/jyc7.dbf
input datafile file number=00013 name=/oracle/oradata/pri/jyc8.dbf
channel t1: starting piece 1 at 19-321
channel t1: finished piece 1 at 19-321
piece handle=/home/oracle/rman/jyc1_23vq4f82_1_1 tag=JYC1 comment=NONE
channel t1: backup set complete, elapsed time: 00:00:01
Finished backup at 19-321

released channel: t1

RMAN> list backup tag=jyc1;

List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
45      Incr 1  88.00K     DISK        00:00:00     19-321     
        BP Key: 45   Status: AVAILABLE  Compressed: NO  Tag: JYC1
        Piece Name: /home/oracle/rman/jyc1_23vq4f82_1_1
  List of Datafiles in backup set 45
  File LV Type Ckp SCN    Ckp Time   Name
  ---- -- ---- ---------- ---------- ----
  5    1  Incr 1064757    19-321 /oracle/oradata/pri/jyc.dbf
  7    1  Incr 1064757    19-321 /oracle/oradata/pri/jyc2.dbf
  8    1  Incr 1064757    19-321 /oracle/oradata/pri/jyc3.dbf
  9    1  Incr 1064757    19-321 /oracle/oradata/pri/jyc4.dbf
  10   1  Incr 1064757    19-321 /oracle/oradata/pri/jyc5.dbf
  11   1  Incr 1064757    19-321 /oracle/oradata/pri/jyc6.dbf
  12   1  Incr 1064757    19-321 /oracle/oradata/pri/jyc7.dbf
  13   1  Incr 1064757    19-321 /oracle/oradata/pri/jyc8.dbf

RMAN> 

相关参考:

转载地址:http://tisof.baihongyu.com/

你可能感兴趣的文章
【托业】【跨栏】TEST04
查看>>
【托业】【跨栏】TEST05
查看>>
【托业】【全真题库】TEST1-语法题+阅读题
查看>>
【托业】【全真题库】TEST3-语法题+阅读题
查看>>
【托业】【跨栏】TEST06
查看>>
【托业】320题-语法题(03-04)(03-37、04-11)
查看>>
【日语】五十音图-一个好用的日语五十音图记忆方法
查看>>
linux下使用crontab实现定时PHP计划任务失败的原因分析
查看>>
linux环境下安装redis扩展
查看>>
一个简单大方的赞后+1,踩后-1js动画效果
查看>>
新手学习编程的最佳方式
查看>>
从json_encode过来的的字符串被返回到html页面时的解析
查看>>
linux虚拟机局域网网卡配置
查看>>
用js判断是否为手机浏览,如果是手机浏览就跳转到手机站
查看>>
每天一个linux命令(26):用SecureCRT来上传和下载文件(转载自竹子)
查看>>
定时启动计划任务(转载自网络)
查看>>
Javascript的RegExp对象(转载自网络)
查看>>
rwx对于文件和目录的意义
查看>>
借助csv用PHP生成excel文件
查看>>
使用SimpleXML解析xml文件数据
查看>>