【Oracle】81.生产环境CATALOG损坏修复及常用的RMAN LIST命令

已于 2024-02-22 14:31:58 修改
阅读量355 收藏 6
点赞数 7
分类专栏： 数据库运维-Oracle 文章标签： oracle list 数据库
于 2024-02-22 14:30:52 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43346403/article/details/136233259
版权

1.新建CATALOG使用的表空间 

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/oracle/app/oracle/oradata/fermdg/system01.dbf
/oracle/app/oracle/oradata/fermdg/sysaux01.dbf
/oracle/app/oracle/oradata/fermdg/undotbs01.dbf
/oracle/app/oracle/oradata/fermdg/users01.dbf
/oracle/app/oracle/oradata/fermdg/test01.dbf
/oracle/app/oracle/oradata/fermdg/perfstat.dbf

--生产环境使用5G;
create tablespace rman_tbs datafile '/oracle/app/oracle/oradata/fermdg/rman_tbs.dbf' size 50m autoextend off;     
Tablespace created.
create user rman identified by rman default tablespace rman_tbs;
User created.
SQL> grant connect,resource ,recovery_catalog_owner to rman;

Grant succeeded.
SQL> alter user rman quota unlimited on rman_tbs;

User altered.

2.创建CATALOG 

[oracle@oracle11gdg ~]$ rman target / catalog rman/rman

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 23 13:33:14 2024

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: FERMDB (DBID=1185704947)
connected to recovery catalog database

RMAN> create catalog tablespace rman_tbs ;

recovery catalog created

如果误执行 drop catalog; 只需要执行:create catalog tablespace rman_tbs ;就可以重建CATALOG;

3.注册需要管理的数据库 

SQL> show parameter db_name

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_name 			     string	 fermdb

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

查看是否有备份:如下还没有备份。
RMAN> list backup;
specification does not match any backup in the repository

3.查看注册的数据库的情况 

RMAN> report schema;

Report of database schema for database with db_unique_name FERMDG

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    750      SYSTEM               YES     /oracle/app/oracle/oradata/fermdg/system01.dbf
2    550      SYSAUX               NO      /oracle/app/oracle/oradata/fermdg/sysaux01.dbf
3    85       UNDOTBS1             YES     /oracle/app/oracle/oradata/fermdg/undotbs01.dbf
4    138      USERS                NO      /oracle/app/oracle/oradata/fermdg/users01.dbf
5    100      TEST                 NO      /oracle/app/oracle/oradata/fermdg/test01.dbf
6    200      PERFSTAT             NO      /oracle/app/oracle/oradata/fermdg/perfstat.dbf
7    50       RMAN_TBS             NO      /oracle/app/oracle/oradata/fermdg/rman_tbs.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    29       TEMP                 32767       /oracle/app/oracle/oradata/fermdg/temp01.dbf

4.关于CATALOG的使用 

如果使用CATALOG备份，则备份信息会在CATALOG里面,但是如果备份时没有使用CATALOG备份。
则我们可以通过手工注册的方式将备份的文件注册到CATALOG里面。

(1)NOCATALOG模式备份
backup format '/home/oracle/backup/ctl_%s_%p_%t' current controlfile;
backup format '/home/oracle/backup/pfile_%s_%p_%t'(spfile);
backup format '/home/oracle/backup/fermdb_%s_%p_%t' (database);
backup format '/home/oracle/backup/arch_%s_%p_%t'(archivelog all);

备份:spfile,controfile,archivelog,database;

[oracle@oracle11gdg ~]$ rman target / nocatalog 

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 23 13:59:48 2024

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: FERMDB (DBID=1185704947)
using target database control file instead of recovery catalog
rman> backup format '/home/oracle/backup/ctl_%s_%p_%t' current controlfile;

Starting backup at 2024-02-23 14:00:20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=14 device type=DISK
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 2024-02-23 14:00:21
channel ORA_DISK_1: finished piece 1 at 2024-02-23 14:00:22
piece handle=/home/oracle/backup/ctl_45_1_1161698420 tag=TAG20240223T140020 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2024-02-23 14:00:22


RMAN> backup format '/home/oracle/backup/pfile_%s_%p_%t'(spfile);


Starting backup at 2024-02-23 14:00:33
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 SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2024-02-23 14:00:33
channel ORA_DISK_1: finished piece 1 at 2024-02-23 14:00:35
piece handle=/home/oracle/backup/pfile_46_1_1161698433 tag=TAG20240223T140033 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 2024-02-23 14:00:35


RMAN> backup format '/home/oracle/backup/fermdb_%s_%p_%t' (database);

Starting backup at 2024-02-23 14:00:45
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/app/oracle/oradata/fermdg/system01.dbf
input datafile file number=00002 name=/oracle/app/oracle/oradata/fermdg/sysaux01.dbf
input datafile file number=00006 name=/oracle/app/oracle/oradata/fermdg/perfstat.dbf
input datafile file number=00004 name=/oracle/app/oracle/oradata/fermdg/users01.dbf
input datafile file number=00005 name=/oracle/app/oracle/oradata/fermdg/test01.dbf
input datafile file number=00003 name=/oracle/app/oracle/oradata/fermdg/undotbs01.dbf
input datafile file number=00007 name=/oracle/app/oracle/oradata/fermdg/rman_tbs.dbf
channel ORA_DISK_1: starting piece 1 at 2024-02-23 14:00:45
channel ORA_DISK_1: finished piece 1 at 2024-02-23 14:00:48
piece handle=/home/oracle/backup/fermdb_47_1_1161698445 tag=TAG20240223T140045 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
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
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2024-02-23 14:00:49
channel ORA_DISK_1: finished piece 1 at 2024-02-23 14:00:50
piece handle=/home/oracle/backup/fermdb_48_1_1161698448 tag=TAG20240223T140045 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2024-02-23 14:00:50


RMAN> backup format '/home/oracle/backup/arch_%s_%p_%t'(archivelog all);

Starting backup at 2024-02-23 14:01:02
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=19 RECID=22 STAMP=1159610855
input archived log thread=1 sequence=20 RECID=23 STAMP=1159610858
input archived log thread=1 sequence=21 RECID=24 STAMP=1159610862
input archived log thread=1 sequence=22 RECID=25 STAMP=1159693417
input archived log thread=1 sequence=23 RECID=26 STAMP=1159693420
input archived log thread=1 sequence=24 RECID=27 STAMP=1159779945
input archived log thread=1 sequence=25 RECID=28 STAMP=1159779950
input archived log thread=1 sequence=26 RECID=29 STAMP=1159781453
input archived log thread=1 sequence=27 RECID=30 STAMP=1159784841
input archived log thread=1 sequence=28 RECID=31 STAMP=1159889620
input archived log thread=1 sequence=29 RECID=32 STAMP=1159889623
input archived log thread=1 sequence=30 RECID=33 STAMP=1159891667
input archived log thread=1 sequence=31 RECID=34 STAMP=1159978634
input archived log thread=1 sequence=32 RECID=35 STAMP=1159978637
input archived log thread=1 sequence=33 RECID=36 STAMP=1159979202
input archived log thread=1 sequence=34 RECID=37 STAMP=1159985087
input archived log thread=1 sequence=35 RECID=38 STAMP=1160214820
input archived log thread=1 sequence=36 RECID=39 STAMP=1160214823
input archived log thread=1 sequence=37 RECID=40 STAMP=1160238542
input archived log thread=1 sequence=38 RECID=41 STAMP=1160238544
input archived log thread=1 sequence=39 RECID=42 STAMP=1160239243
input archived log thread=1 sequence=40 RECID=43 STAMP=1160240086
input archived log thread=1 sequence=41 RECID=44 STAMP=1161696488
input archived log thread=1 sequence=42 RECID=45 STAMP=1161696491
input archived log thread=1 sequence=43 RECID=46 STAMP=1161696804
input archived log thread=1 sequence=44 RECID=47 STAMP=1161698003
input archived log thread=1 sequence=45 RECID=48 STAMP=1161698289
input archived log thread=1 sequence=46 RECID=49 STAMP=1161698462
channel ORA_DISK_1: starting piece 1 at 2024-02-23 14:01:02
channel ORA_DISK_1: finished piece 1 at 2024-02-23 14:01:05
piece handle=/home/oracle/backup/arch_49_1_1161698462 tag=TAG20240223T140102 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 2024-02-23 14:01:05


(2)检查备份 
NOCATALOG 模式查看 
[oracle@oracle11gdg ~]$ rman target / nocatalog 

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 23 14:03:06 2024

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: FERMDB (DBID=1185704947)
using target database control file instead of recovery catalog

RMAN> list backup;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
6       Full    9.33M      DISK        00:00:01     2024-02-23 14:00:21
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140020
        Piece Name: /home/oracle/backup/ctl_45_1_1161698420
  Control File Included: Ckp SCN: 1362350      Ckp time: 2024-02-23 14:00:20

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
7       Full    80.00K     DISK        00:00:01     2024-02-23 14:00:34
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140033
        Piece Name: /home/oracle/backup/pfile_46_1_1161698433
  SPFILE Included: Modification time: 2024-02-23 13:28:45
  SPFILE db_unique_name: FERMDG

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
8       Full    1.31G      DISK        00:00:03     2024-02-23 14:00:48
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_47_1_1161698445
  List of Datafiles in backup set 8
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/system01.dbf
  2       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/sysaux01.dbf
  3       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/undotbs01.dbf
  4       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/users01.dbf
  5       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/test01.dbf
  6       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/perfstat.dbf
  7       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/rman_tbs.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
9       Full    9.36M      DISK        00:00:01     2024-02-23 14:00:49
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_48_1_1161698448
  SPFILE Included: Modification time: 2024-02-23 13:28:45
  SPFILE db_unique_name: FERMDG
  Control File Included: Ckp SCN: 1362406      Ckp time: 2024-02-23 14:00:48

BS Key  Size       Device Type Elapsed Time Completion Time    
------- ---------- ----------- ------------ -------------------
10      641.88M    DISK        00:00:01     2024-02-23 14:01:03
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140102
        Piece Name: /home/oracle/backup/arch_49_1_1161698462

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    19      1127294    2024-01-30 10:07:32 1128152    2024-01-30 10:07:35
  1    20      1128152    2024-01-30 10:07:35 1128899    2024-01-30 10:07:38
  1    21      1128899    2024-01-30 10:07:38 1129775    2024-01-30 10:07:41
  1    22      1129775    2024-01-30 10:07:41 1159106    2024-01-31 09:03:36
  1    23      1159106    2024-01-31 09:03:36 1159394    2024-01-31 09:03:40
  1    24      1159394    2024-01-31 09:03:40 1217749    2024-02-01 09:05:44
  1    25      1217749    2024-02-01 09:05:44 1218053    2024-02-01 09:05:50
  1    26      1218053    2024-02-01 09:05:50 1220585    2024-02-01 09:30:53
  1    27      1220585    2024-02-01 09:30:53 1225524    2024-02-01 10:27:21
  1    28      1225524    2024-02-01 10:27:21 1248977    2024-02-02 15:33:40
  1    29      1248977    2024-02-02 15:33:40 1249256    2024-02-02 15:33:43
  1    30      1249256    2024-02-02 15:33:43 1262547    2024-02-02 16:07:47
  1    31      1262547    2024-02-02 16:07:47 1277436    2024-02-03 16:17:14
  1    32      1277436    2024-02-03 16:17:14 1277720    2024-02-03 16:17:17
  1    33      1277720    2024-02-03 16:17:17 1292365    2024-02-03 16:26:42
  1    34      1292365    2024-02-03 16:26:42 1301724    2024-02-03 18:04:47
  1    35      1301724    2024-02-03 18:04:47 1313358    2024-02-06 09:53:40
  1    36      1313358    2024-02-06 09:53:40 1313670    2024-02-06 09:53:43
  1    37      1313670    2024-02-06 09:53:43 1343713    2024-02-06 16:29:00
  1    38      1343713    2024-02-06 16:29:00 1344004    2024-02-06 16:29:04
  1    39      1344004    2024-02-06 16:29:04 1346049    2024-02-06 16:40:43
  1    40      1346049    2024-02-06 16:40:43 1348798    2024-02-06 16:54:46
  1    41      1348798    2024-02-06 16:54:46 1352517    2024-02-23 13:28:08
  1    42      1352517    2024-02-23 13:28:08 1352865    2024-02-23 13:28:11
  1    43      1352865    2024-02-23 13:28:11 1356080    2024-02-23 13:33:24
  1    44      1356080    2024-02-23 13:33:24 1359883    2024-02-23 13:53:23
  1    45      1359883    2024-02-23 13:53:23 1361297    2024-02-23 13:58:09
  1    46      1361297    2024-02-23 13:58:09 1362435    2024-02-23 14:01:02

使用CATALOG模式查看 
[oracle@oracle11gdg ~]$ rman target / catalog rman/rman

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 23 14:03:54 2024

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: FERMDB (DBID=1185704947)
connected to recovery catalog database

RMAN> list backup;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
270     Full    9.33M      DISK        00:00:01     2024-02-23 14:00:21
        BP Key: 275   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140020
        Piece Name: /home/oracle/backup/ctl_45_1_1161698420
  Control File Included: Ckp SCN: 1362350      Ckp time: 2024-02-23 14:00:20

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
271     Full    80.00K     DISK        00:00:01     2024-02-23 14:00:34
        BP Key: 276   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140033
        Piece Name: /home/oracle/backup/pfile_46_1_1161698433
  SPFILE Included: Modification time: 2024-02-23 13:28:45
  SPFILE db_unique_name: FERMDG

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
272     Full    1.31G      DISK        00:00:03     2024-02-23 14:00:48
        BP Key: 277   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_47_1_1161698445
  List of Datafiles in backup set 272
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/system01.dbf
  2       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/sysaux01.dbf
  3       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/undotbs01.dbf
  4       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/users01.dbf
  5       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/test01.dbf
  6       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/perfstat.dbf
  7       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/rman_tbs.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
273     Full    9.36M      DISK        00:00:01     2024-02-23 14:00:49
        BP Key: 278   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_48_1_1161698448
  SPFILE Included: Modification time: 2024-02-23 13:28:45
  SPFILE db_unique_name: FERMDG
  Control File Included: Ckp SCN: 1362406      Ckp time: 2024-02-23 14:00:48

BS Key  Size       Device Type Elapsed Time Completion Time    
------- ---------- ----------- ------------ -------------------
274     641.88M    DISK        00:00:01     2024-02-23 14:01:03
        BP Key: 279   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140102
        Piece Name: /home/oracle/backup/arch_49_1_1161698462

  List of Archived Logs in backup set 274
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    19      1127294    2024-01-30 10:07:32 1128152    2024-01-30 10:07:35
  1    20      1128152    2024-01-30 10:07:35 1128899    2024-01-30 10:07:38
  1    21      1128899    2024-01-30 10:07:38 1129775    2024-01-30 10:07:41
  1    22      1129775    2024-01-30 10:07:41 1159106    2024-01-31 09:03:36
  1    23      1159106    2024-01-31 09:03:36 1159394    2024-01-31 09:03:40
  1    24      1159394    2024-01-31 09:03:40 1217749    2024-02-01 09:05:44
  1    25      1217749    2024-02-01 09:05:44 1218053    2024-02-01 09:05:50
  1    26      1218053    2024-02-01 09:05:50 1220585    2024-02-01 09:30:53
  1    27      1220585    2024-02-01 09:30:53 1225524    2024-02-01 10:27:21
  1    28      1225524    2024-02-01 10:27:21 1248977    2024-02-02 15:33:40
  1    29      1248977    2024-02-02 15:33:40 1249256    2024-02-02 15:33:43
  1    30      1249256    2024-02-02 15:33:43 1262547    2024-02-02 16:07:47
  1    31      1262547    2024-02-02 16:07:47 1277436    2024-02-03 16:17:14
  1    32      1277436    2024-02-03 16:17:14 1277720    2024-02-03 16:17:17
  1    33      1277720    2024-02-03 16:17:17 1292365    2024-02-03 16:26:42
  1    34      1292365    2024-02-03 16:26:42 1301724    2024-02-03 18:04:47
  1    35      1301724    2024-02-03 18:04:47 1313358    2024-02-06 09:53:40
  1    36      1313358    2024-02-06 09:53:40 1313670    2024-02-06 09:53:43
  1    37      1313670    2024-02-06 09:53:43 1343713    2024-02-06 16:29:00
  1    38      1343713    2024-02-06 16:29:00 1344004    2024-02-06 16:29:04
  1    39      1344004    2024-02-06 16:29:04 1346049    2024-02-06 16:40:43
  1    40      1346049    2024-02-06 16:40:43 1348798    2024-02-06 16:54:46
  1    41      1348798    2024-02-06 16:54:46 1352517    2024-02-23 13:28:08
  1    42      1352517    2024-02-23 13:28:08 1352865    2024-02-23 13:28:11
  1    43      1352865    2024-02-23 13:28:11 1356080    2024-02-23 13:33:24
  1    44      1356080    2024-02-23 13:33:24 1359883    2024-02-23 13:53:23
  1    45      1359883    2024-02-23 13:53:23 1361297    2024-02-23 13:58:09
  1    46      1361297    2024-02-23 13:58:09 1362435    2024-02-23 14:01:02

(3)总结
一旦数据库建立了CATALOG,备份时，无论是否使用CATALOG,还是使用NOCATALOG,
备份信息都会自动注册到CATALOG里面。

5.查看备份信息 

常用的几个LIST 命令。
list archivelog all;  --列出所有的归档。
list backup of spfile list backup;  --列出所有备份信息。
list backup of archivelog all; --仅列出ARCHIELOG信息。
list backup of controlfile;  --仅列出CONTROLFILE信息 
list backup of database;  --仅列出DATABASE信息 
list backup of spfile;  --仅列出SPFILE的信息。
list backup of datafile 1;  --查看单一的数据文件 
list backup of database  summary; --列出备份的数据库的标签。
list backup by file;    --查看所有的备份集标签。
list backup of tablespace users; --查看单一的表空间 
list expired backup;  --查看过期备份 
list copy;  --查看所有的COPY的信息,默认archivelog 是copy; 
list backup summary; --列出备份TAG; 


RMAN> list archivelog all; 

List of Archived Log Copies for database with db_unique_name FERMDG
=====================================================================

Key     Thrd Seq     S Low Time           
------- ---- ------- - -------------------
90      1    16      A 2024-01-30 10:03:08        Name: /oracle/app/arch/1_16_1154721004.dbf
91      1    17      A 2024-01-30 10:07:27        Name: /oracle/app/arch/1_17_1154721004.dbf
92      1    18      A 2024-01-30 10:07:29        Name: /oracle/app/arch/1_18_1154721004.dbf
93      1    19      A 2024-01-30 10:07:32        Name: /oracle/app/arch/1_19_1154721004.dbf
94      1    20      A 2024-01-30 10:07:35        Name: /oracle/app/arch/1_20_1154721004.dbf
95      1    21      A 2024-01-30 10:07:38        Name: /oracle/app/arch/1_21_1154721004.dbf
96      1    22      A 2024-01-30 10:07:41        Name: /oracle/app/arch/1_22_1154721004.dbf
97      1    23      A 2024-01-31 09:03:36        Name: /oracle/app/arch/1_23_1154721004.dbf
98      1    24      A 2024-01-31 09:03:40        Name: /oracle/app/arch/1_24_1154721004.dbf
99      1    25      A 2024-02-01 09:05:44        Name: /oracle/app/arch/1_25_1154721004.dbf
100     1    26      A 2024-02-01 09:05:50        Name: /oracle/app/arch/1_26_1154721004.dbf
101     1    27      A 2024-02-01 09:30:53        Name: /oracle/app/arch/1_27_1154721004.dbf
102     1    28      A 2024-02-01 10:27:21        Name: /oracle/app/arch/1_28_1154721004.dbf
103     1    29      A 2024-02-02 15:33:40        Name: /oracle/app/arch/1_29_1154721004.dbf
104     1    30      A 2024-02-02 15:33:43        Name: /oracle/app/arch/1_30_1154721004.dbf
105     1    31      A 2024-02-02 16:07:47        Name: /oracle/app/arch/1_31_1154721004.dbf
106     1    32      A 2024-02-03 16:17:14        Name: /oracle/app/arch/1_32_1154721004.dbf
107     1    33      A 2024-02-03 16:17:17        Name: /oracle/app/arch/1_33_1154721004.dbf
108     1    34      A 2024-02-03 16:26:42        Name: /oracle/app/arch/1_34_1154721004.dbf
109     1    35      A 2024-02-03 18:04:47        Name: /oracle/app/arch/1_35_1154721004.dbf
110     1    36      A 2024-02-06 09:53:40        Name: /oracle/app/arch/1_36_1154721004.dbf
111     1    37      A 2024-02-06 09:53:43        Name: /oracle/app/arch/1_37_1154721004.dbf
112     1    38      A 2024-02-06 16:29:00        Name: /oracle/app/arch/1_38_1154721004.dbf
113     1    39      A 2024-02-06 16:29:04        Name: /oracle/app/arch/1_39_1154721004.dbf
114     1    40      A 2024-02-06 16:40:43        Name: /oracle/app/arch/1_40_1154721004.dbf
115     1    41      A 2024-02-06 16:54:46        Name: /oracle/app/arch/1_41_1154721004.dbf
116     1    42      A 2024-02-23 13:28:08        Name: /oracle/app/arch/1_42_1154721004.dbf
117     1    43      A 2024-02-23 13:28:11        Name: /oracle/app/arch/1_43_1154721004.dbf
134     1    44      A 2024-02-23 13:33:24        Name: /oracle/app/arch/1_44_1154721004.dbf
203     1    45      A 2024-02-23 13:53:23        Name: /oracle/app/arch/1_45_1154721004.dbf
269     1    46      A 2024-02-23 13:58:09        Name: /oracle/app/arch/1_46_1154721004.dbf

RMAN> list backup;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
270     Full    9.33M      DISK        00:00:01     2024-02-23 14:00:21
        BP Key: 275   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140020
        Piece Name: /home/oracle/backup/ctl_45_1_1161698420
  Control File Included: Ckp SCN: 1362350      Ckp time: 2024-02-23 14:00:20

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
271     Full    80.00K     DISK        00:00:01     2024-02-23 14:00:34
        BP Key: 276   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140033
        Piece Name: /home/oracle/backup/pfile_46_1_1161698433
  SPFILE Included: Modification time: 2024-02-23 13:28:45
  SPFILE db_unique_name: FERMDG

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
272     Full    1.31G      DISK        00:00:03     2024-02-23 14:00:48
        BP Key: 277   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_47_1_1161698445
  List of Datafiles in backup set 272
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/system01.dbf
  2       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/sysaux01.dbf
  3       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/undotbs01.dbf
  4       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/users01.dbf
  5       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/test01.dbf
  6       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/perfstat.dbf
  7       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/rman_tbs.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
273     Full    9.36M      DISK        00:00:01     2024-02-23 14:00:49
        BP Key: 278   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_48_1_1161698448
  SPFILE Included: Modification time: 2024-02-23 13:28:45
  SPFILE db_unique_name: FERMDG
  Control File Included: Ckp SCN: 1362406      Ckp time: 2024-02-23 14:00:48

BS Key  Size       Device Type Elapsed Time Completion Time    
------- ---------- ----------- ------------ -------------------
274     641.88M    DISK        00:00:01     2024-02-23 14:01:03
        BP Key: 279   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140102
        Piece Name: /home/oracle/backup/arch_49_1_1161698462

  List of Archived Logs in backup set 274
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    19      1127294    2024-01-30 10:07:32 1128152    2024-01-30 10:07:35
  1    20      1128152    2024-01-30 10:07:35 1128899    2024-01-30 10:07:38
  1    21      1128899    2024-01-30 10:07:38 1129775    2024-01-30 10:07:41
  1    22      1129775    2024-01-30 10:07:41 1159106    2024-01-31 09:03:36
  1    23      1159106    2024-01-31 09:03:36 1159394    2024-01-31 09:03:40
  1    24      1159394    2024-01-31 09:03:40 1217749    2024-02-01 09:05:44
  1    25      1217749    2024-02-01 09:05:44 1218053    2024-02-01 09:05:50
  1    26      1218053    2024-02-01 09:05:50 1220585    2024-02-01 09:30:53
  1    27      1220585    2024-02-01 09:30:53 1225524    2024-02-01 10:27:21
  1    28      1225524    2024-02-01 10:27:21 1248977    2024-02-02 15:33:40
  1    29      1248977    2024-02-02 15:33:40 1249256    2024-02-02 15:33:43
  1    30      1249256    2024-02-02 15:33:43 1262547    2024-02-02 16:07:47
  1    31      1262547    2024-02-02 16:07:47 1277436    2024-02-03 16:17:14
  1    32      1277436    2024-02-03 16:17:14 1277720    2024-02-03 16:17:17
  1    33      1277720    2024-02-03 16:17:17 1292365    2024-02-03 16:26:42
  1    34      1292365    2024-02-03 16:26:42 1301724    2024-02-03 18:04:47
  1    35      1301724    2024-02-03 18:04:47 1313358    2024-02-06 09:53:40
  1    36      1313358    2024-02-06 09:53:40 1313670    2024-02-06 09:53:43
  1    37      1313670    2024-02-06 09:53:43 1343713    2024-02-06 16:29:00
  1    38      1343713    2024-02-06 16:29:00 1344004    2024-02-06 16:29:04
  1    39      1344004    2024-02-06 16:29:04 1346049    2024-02-06 16:40:43
  1    40      1346049    2024-02-06 16:40:43 1348798    2024-02-06 16:54:46
  1    41      1348798    2024-02-06 16:54:46 1352517    2024-02-23 13:28:08
  1    42      1352517    2024-02-23 13:28:08 1352865    2024-02-23 13:28:11
  1    43      1352865    2024-02-23 13:28:11 1356080    2024-02-23 13:33:24
  1    44      1356080    2024-02-23 13:33:24 1359883    2024-02-23 13:53:23
  1    45      1359883    2024-02-23 13:53:23 1361297    2024-02-23 13:58:09
  1    46      1361297    2024-02-23 13:58:09 1362435    2024-02-23 14:01:02
RMAN> list backup of archivelog all;


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


BS Key  Size       Device Type Elapsed Time Completion Time    
------- ---------- ----------- ------------ -------------------
274     641.88M    DISK        00:00:01     2024-02-23 14:01:03
        BP Key: 279   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140102
        Piece Name: /home/oracle/backup/arch_49_1_1161698462

  List of Archived Logs in backup set 274
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    19      1127294    2024-01-30 10:07:32 1128152    2024-01-30 10:07:35
  1    20      1128152    2024-01-30 10:07:35 1128899    2024-01-30 10:07:38
  1    21      1128899    2024-01-30 10:07:38 1129775    2024-01-30 10:07:41
  1    22      1129775    2024-01-30 10:07:41 1159106    2024-01-31 09:03:36
  1    23      1159106    2024-01-31 09:03:36 1159394    2024-01-31 09:03:40
  1    24      1159394    2024-01-31 09:03:40 1217749    2024-02-01 09:05:44
  1    25      1217749    2024-02-01 09:05:44 1218053    2024-02-01 09:05:50
  1    26      1218053    2024-02-01 09:05:50 1220585    2024-02-01 09:30:53
  1    27      1220585    2024-02-01 09:30:53 1225524    2024-02-01 10:27:21
  1    28      1225524    2024-02-01 10:27:21 1248977    2024-02-02 15:33:40
  1    29      1248977    2024-02-02 15:33:40 1249256    2024-02-02 15:33:43
  1    30      1249256    2024-02-02 15:33:43 1262547    2024-02-02 16:07:47
  1    31      1262547    2024-02-02 16:07:47 1277436    2024-02-03 16:17:14
  1    32      1277436    2024-02-03 16:17:14 1277720    2024-02-03 16:17:17
  1    33      1277720    2024-02-03 16:17:17 1292365    2024-02-03 16:26:42
  1    34      1292365    2024-02-03 16:26:42 1301724    2024-02-03 18:04:47
  1    35      1301724    2024-02-03 18:04:47 1313358    2024-02-06 09:53:40
  1    36      1313358    2024-02-06 09:53:40 1313670    2024-02-06 09:53:43
  1    37      1313670    2024-02-06 09:53:43 1343713    2024-02-06 16:29:00
  1    38      1343713    2024-02-06 16:29:00 1344004    2024-02-06 16:29:04
  1    39      1344004    2024-02-06 16:29:04 1346049    2024-02-06 16:40:43
  1    40      1346049    2024-02-06 16:40:43 1348798    2024-02-06 16:54:46
  1    41      1348798    2024-02-06 16:54:46 1352517    2024-02-23 13:28:08
  1    42      1352517    2024-02-23 13:28:08 1352865    2024-02-23 13:28:11
  1    43      1352865    2024-02-23 13:28:11 1356080    2024-02-23 13:33:24
  1    44      1356080    2024-02-23 13:33:24 1359883    2024-02-23 13:53:23
  1    45      1359883    2024-02-23 13:53:23 1361297    2024-02-23 13:58:09
  1    46      1361297    2024-02-23 13:58:09 1362435    2024-02-23 14:01:02
RMAN> list backup of controlfile;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
270     Full    9.33M      DISK        00:00:01     2024-02-23 14:00:21
        BP Key: 275   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140020
        Piece Name: /home/oracle/backup/ctl_45_1_1161698420
  Control File Included: Ckp SCN: 1362350      Ckp time: 2024-02-23 14:00:20

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
273     Full    9.36M      DISK        00:00:01     2024-02-23 14:00:49
        BP Key: 278   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_48_1_1161698448
  Control File Included: Ckp SCN: 1362406      Ckp time: 2024-02-23 14:00:48
RMAN> list backup of database;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
272     Full    1.31G      DISK        00:00:03     2024-02-23 14:00:48
        BP Key: 277   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_47_1_1161698445
  List of Datafiles in backup set 272
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/system01.dbf
  2       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/sysaux01.dbf
  3       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/undotbs01.dbf
  4       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/users01.dbf
  5       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/test01.dbf
  6       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/perfstat.dbf
  7       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/rman_tbs.dbf

RMAN> list backup of spfile;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
271     Full    80.00K     DISK        00:00:01     2024-02-23 14:00:34
        BP Key: 276   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140033
        Piece Name: /home/oracle/backup/pfile_46_1_1161698433
  SPFILE Included: Modification time: 2024-02-23 13:28:45
  SPFILE db_unique_name: FERMDG

BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
273     Full    9.36M      DISK        00:00:01     2024-02-23 14:00:49
        BP Key: 278   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_48_1_1161698448
  SPFILE Included: Modification time: 2024-02-23 13:28:45
  SPFILE db_unique_name: FERMDG
RMAN> list backup of datafile 1;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
272     Full    1.31G      DISK        00:00:03     2024-02-23 14:00:48
        BP Key: 277   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_47_1_1161698445
  List of Datafiles in backup set 272
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/system01.dbf
RMAN> list backup of database  summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time     #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
272     B  F  A DISK        2024-02-23 14:00:48 1       1       NO         TAG20240223T140045
RMAN> list backup by file;


List of Datafile Backups
========================

File Key     TY LV S Ckp SCN    Ckp Time            #Pieces #Copies Compressed Tag
---- ------- -  -- - ---------- ------------------- ------- ------- ---------- ---
1    272     B  F  A 1362404    2024-02-23 14:00:45 1       1       NO         TAG20240223T140045
2    272     B  F  A 1362404    2024-02-23 14:00:45 1       1       NO         TAG20240223T140045
3    272     B  F  A 1362404    2024-02-23 14:00:45 1       1       NO         TAG20240223T140045
4    272     B  F  A 1362404    2024-02-23 14:00:45 1       1       NO         TAG20240223T140045
5    272     B  F  A 1362404    2024-02-23 14:00:45 1       1       NO         TAG20240223T140045
6    272     B  F  A 1362404    2024-02-23 14:00:45 1       1       NO         TAG20240223T140045
7    272     B  F  A 1362404    2024-02-23 14:00:45 1       1       NO         TAG20240223T140045

List of Archived Log Backups
============================

Thrd Seq     Low SCN    Low Time            BS Key  S #Pieces #Copies Compressed Tag
---- ------- ---------- ------------------- ------- - ------- ------- ---------- ---
1    19      1127294    2024-01-30 10:07:32 274     A 1       1       NO         TAG20240223T140102
1    20      1128152    2024-01-30 10:07:35 274     A 1       1       NO         TAG20240223T140102
1    21      1128899    2024-01-30 10:07:38 274     A 1       1       NO         TAG20240223T140102
1    22      1129775    2024-01-30 10:07:41 274     A 1       1       NO         TAG20240223T140102
1    23      1159106    2024-01-31 09:03:36 274     A 1       1       NO         TAG20240223T140102
1    24      1159394    2024-01-31 09:03:40 274     A 1       1       NO         TAG20240223T140102
1    25      1217749    2024-02-01 09:05:44 274     A 1       1       NO         TAG20240223T140102
1    26      1218053    2024-02-01 09:05:50 274     A 1       1       NO         TAG20240223T140102
1    27      1220585    2024-02-01 09:30:53 274     A 1       1       NO         TAG20240223T140102
1    28      1225524    2024-02-01 10:27:21 274     A 1       1       NO         TAG20240223T140102
1    29      1248977    2024-02-02 15:33:40 274     A 1       1       NO         TAG20240223T140102
1    30      1249256    2024-02-02 15:33:43 274     A 1       1       NO         TAG20240223T140102
1    31      1262547    2024-02-02 16:07:47 274     A 1       1       NO         TAG20240223T140102
1    32      1277436    2024-02-03 16:17:14 274     A 1       1       NO         TAG20240223T140102
1    33      1277720    2024-02-03 16:17:17 274     A 1       1       NO         TAG20240223T140102
1    34      1292365    2024-02-03 16:26:42 274     A 1       1       NO         TAG20240223T140102
1    35      1301724    2024-02-03 18:04:47 274     A 1       1       NO         TAG20240223T140102
1    36      1313358    2024-02-06 09:53:40 274     A 1       1       NO         TAG20240223T140102
1    37      1313670    2024-02-06 09:53:43 274     A 1       1       NO         TAG20240223T140102
1    38      1343713    2024-02-06 16:29:00 274     A 1       1       NO         TAG20240223T140102
1    39      1344004    2024-02-06 16:29:04 274     A 1       1       NO         TAG20240223T140102
1    40      1346049    2024-02-06 16:40:43 274     A 1       1       NO         TAG20240223T140102
1    41      1348798    2024-02-06 16:54:46 274     A 1       1       NO         TAG20240223T140102
1    42      1352517    2024-02-23 13:28:08 274     A 1       1       NO         TAG20240223T140102
1    43      1352865    2024-02-23 13:28:11 274     A 1       1       NO         TAG20240223T140102
1    44      1356080    2024-02-23 13:33:24 274     A 1       1       NO         TAG20240223T140102
1    45      1359883    2024-02-23 13:53:23 274     A 1       1       NO         TAG20240223T140102
1    46      1361297    2024-02-23 13:58:09 274     A 1       1       NO         TAG20240223T140102

List of Control File Backups
============================

CF Ckp SCN Ckp Time            BS Key  S #Pieces #Copies Compressed Tag
---------- ------------------- ------- - ------- ------- ---------- ---
1362406    2024-02-23 14:00:48 273     A 1       1       NO         TAG20240223T140045
1362350    2024-02-23 14:00:20 270     A 1       1       NO         TAG20240223T140020
List of SPFILE Backups
======================

Modification Time   BS Key  S #Pieces #Copies Compressed Tag
------------------- ------- - ------- ------- ---------- ---
2024-02-23 13:28:45 273     A 1       1       NO         TAG20240223T140045
2024-02-23 13:28:45 271     A 1       1       NO         TAG20240223T140033

RMAN> list backup of tablespace users;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time    
------- ---- -- ---------- ----------- ------------ -------------------
272     Full    1.31G      DISK        00:00:03     2024-02-23 14:00:48
        BP Key: 277   Status: AVAILABLE  Compressed: NO  Tag: TAG20240223T140045
        Piece Name: /home/oracle/backup/fermdb_47_1_1161698445
  List of Datafiles in backup set 272
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4       Full 1362404    2024-02-23 14:00:45 /oracle/app/oracle/oradata/fermdg/users01.dbf
RMAN> list expired backup;

specification does not match any backup in the repository
RMAN> list copy;

specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
List of Archived Log Copies for database with db_unique_name FERMDG
=====================================================================

Key     Thrd Seq     S Low Time           
------- ---- ------- - -------------------
90      1    16      A 2024-01-30 10:03:08
        Name: /oracle/app/arch/1_16_1154721004.dbf

91      1    17      A 2024-01-30 10:07:27
        Name: /oracle/app/arch/1_17_1154721004.dbf

92      1    18      A 2024-01-30 10:07:29
        Name: /oracle/app/arch/1_18_1154721004.dbf

93      1    19      A 2024-01-30 10:07:32
        Name: /oracle/app/arch/1_19_1154721004.dbf

94      1    20      A 2024-01-30 10:07:35
        Name: /oracle/app/arch/1_20_1154721004.dbf

95      1    21      A 2024-01-30 10:07:38
        Name: /oracle/app/arch/1_21_1154721004.dbf

96      1    22      A 2024-01-30 10:07:41
        Name: /oracle/app/arch/1_22_1154721004.dbf

97      1    23      A 2024-01-31 09:03:36
        Name: /oracle/app/arch/1_23_1154721004.dbf

98      1    24      A 2024-01-31 09:03:40
        Name: /oracle/app/arch/1_24_1154721004.dbf

99      1    25      A 2024-02-01 09:05:44
        Name: /oracle/app/arch/1_25_1154721004.dbf

100     1    26      A 2024-02-01 09:05:50
        Name: /oracle/app/arch/1_26_1154721004.dbf

101     1    27      A 2024-02-01 09:30:53
        Name: /oracle/app/arch/1_27_1154721004.dbf

102     1    28      A 2024-02-01 10:27:21
        Name: /oracle/app/arch/1_28_1154721004.dbf

103     1    29      A 2024-02-02 15:33:40
        Name: /oracle/app/arch/1_29_1154721004.dbf

104     1    30      A 2024-02-02 15:33:43
        Name: /oracle/app/arch/1_30_1154721004.dbf

105     1    31      A 2024-02-02 16:07:47
        Name: /oracle/app/arch/1_31_1154721004.dbf

106     1    32      A 2024-02-03 16:17:14
        Name: /oracle/app/arch/1_32_1154721004.dbf

107     1    33      A 2024-02-03 16:17:17
        Name: /oracle/app/arch/1_33_1154721004.dbf

108     1    34      A 2024-02-03 16:26:42
        Name: /oracle/app/arch/1_34_1154721004.dbf

109     1    35      A 2024-02-03 18:04:47
        Name: /oracle/app/arch/1_35_1154721004.dbf

110     1    36      A 2024-02-06 09:53:40
        Name: /oracle/app/arch/1_36_1154721004.dbf

111     1    37      A 2024-02-06 09:53:43
        Name: /oracle/app/arch/1_37_1154721004.dbf

112     1    38      A 2024-02-06 16:29:00
        Name: /oracle/app/arch/1_38_1154721004.dbf

113     1    39      A 2024-02-06 16:29:04
        Name: /oracle/app/arch/1_39_1154721004.dbf

114     1    40      A 2024-02-06 16:40:43
        Name: /oracle/app/arch/1_40_1154721004.dbf

115     1    41      A 2024-02-06 16:54:46
        Name: /oracle/app/arch/1_41_1154721004.dbf

116     1    42      A 2024-02-23 13:28:08
        Name: /oracle/app/arch/1_42_1154721004.dbf

117     1    43      A 2024-02-23 13:28:11
        Name: /oracle/app/arch/1_43_1154721004.dbf

134     1    44      A 2024-02-23 13:33:24
        Name: /oracle/app/arch/1_44_1154721004.dbf

203     1    45      A 2024-02-23 13:53:23
        Name: /oracle/app/arch/1_45_1154721004.dbf

269     1    46      A 2024-02-23 13:58:09
        Name: /oracle/app/arch/1_46_1154721004.dbf
RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time     #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
270     B  F  A DISK        2024-02-23 14:00:21 1       1       NO         TAG20240223T140020
271     B  F  A DISK        2024-02-23 14:00:34 1       1       NO         TAG20240223T140033
272     B  F  A DISK        2024-02-23 14:00:48 1       1       NO         TAG20240223T140045
273     B  F  A DISK        2024-02-23 14:00:49 1       1       NO         TAG20240223T140045
274     B  A  A DISK        2024-02-23 14:01:03 1       1       NO         TAG20240223T140102

6.总结

只要当前库建立了CATALOG,无论是否指定CATALOG,还是NOCATALOG,都会将备份信息注册到CATALOG里面。而远程没有建立CATALOG的数据库，则可以通过CATALOG rman/rman@rman关键词连接到CATALOG服务器的CATALOG目录。

戒掉贪嗔痴(薛双奇)
关注
  • 7
    点赞
  • 踩
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle OCP 11g 常见单词（不定期更新）
debimeng
02-20 5160
Oracle OCP 11g 常见单词（不定期更新）数据库常见单词，不定期更新至考完ocp证（初步想法），现已收集807个单词；最后一次更新时间为20180301。1, ACCUMULATED  [ə'kjʊ:mju,leɪtɪd]adj. 累积的；累计的；达到v. 累积（accumulate的过去分词）2, CUST  [CUST]abbr. 海关（Customs）n. (Cust)人名；(英)...
oracle19c容器数据库rman备份特性-----性能优化（三）
m0_70247753的博客
01-03 1267
如果一个数据文件很大，可以设置多通道并行备份，提高备份性能。# default# default# default# default//设置3个通道并行备份# default# default# default# default# default# default# default# default# default。
Oracle--DBV命令行工具用法详解及坏块修复
Z14523299999的博客
05-13 1022
一，介绍 DBV(DBVERIFY)是Oracle提供的一个命令行工具，它可以对数据文件物理和逻辑两种一致性检查。但是这个工具不会检查索引记录和数据记录的匹配关系，这种检查必须使用analyze validate structure命令。 这个工具有如下特点： 以只读的方式打开数据文件，在检查过程中不会修改数据文件的内容。 可以在线检查数据文件，而不需要关闭数据库。 不能检...
oracle日常运维及应急故障处理手册
热门推荐
Vic的博客
10-06 2万+
常见问题及处理方案 CPU使用率高的问题 通过操作系统命令toptopas glance等查看top进程号，确认是系统进程还是oracle应用进程，查询当前top进程执行的操作和sql语句进行分析。   根据进程号获取正在执行的sql   SELECT a.osuser, a.username,b.address,b.hash_value, b.sql_text fromv$sessi
oracle rman常用维护命令（全）
06-28
oracle rman常用维护命令（全）
rman配置及rman常用命令操作
09-10
在本文中，我们将深入探讨RMAN的配置及其常用命令，包括如何校验备份信息、查看备份以及删除备份。 首先，配置RMAN是使用RMAN进行有效备份与恢复的基础。以下是一些关键的RMAN配置步骤： 1. 进入RMAN：在CMD环境下...
rman.rar_8YA_oracle_oracle windows环境备份脚本_rman
09-24
Oracle数据库在Windows环境下的备份是数据库管理中的重要环节，RMAN（Recovery Manager）是Oracle提供的一款强大的数据库备份和恢复工具。"rman.rar_8YA_oracle_oracle windows环境备份脚本_rman"这个压缩包文件显然...
Oracle_Rman_命令详解.doc
09-28
最后，数据库的恢复和还原通常涉及一系列步骤，包括关闭数据库、移动或删除损坏的数据文件，然后使用RMAN的恢复命令来还原备份数据文件。一旦数据文件被恢复，数据库可以重新启动并恢复正常服务。 总结来说，Oracle...
oracle asm常用维护命令
06-28
oracle asm常用维护命令
Spring 事务管理 04
程序员进阶之路
07-23 781
事务Transaction）是数据库管理系统（DBMS）中的一个重要概念，它确保数据库操作的**一致性**、**完整性**和**持久性**。在软件开发中，特别是涉及到多个数据库操作或者复杂的数据更新过程时，使用事务能够有效地保证数据操作的正确性和可靠性。以下是几个需要事务的主要原因：
Oracle系统表空间的加解密
In-Memory Computing Technology
07-23 468
对于临时表空间，只能新建一个加密的临时表空间，然后指定其为默认临时表空间。解密当然也可以在线，但为了涵盖加解密功能，此处使用离线解密。就剩下临时表空间了，按照文档。
记一次Mycat分库分表实践
最新发布
天之道居同文。
07-25 872
例如博客的冷数据表，假如分为100个表，当同时有100万个用户在浏览时，如果是单表的话，会进行100万次请求，而现在分表后，就可能是每个表进行1万个数据的请求（因为，不可能绝对的平均，只是假设），这样压力就降低了很多。顾名思义，就是数据分散，将一台主机上的数据分摊到多台，减轻单台主机的负载压力，有两种切分方式，一种是分库，即按照业务模块分多个库，每个库中的表不一样，还有一种就是分表，按照一定的业务规则或者逻辑将数据拆分到不同的主机上，每个主机上的表是一样的，这个有点类似于Oracle的表分区。
自动化测试之python操作Oracle遇到的问题：Oracle-Error-Message: DPI-1047
weixin_43726471的博客
07-23 631
自动化测试需要连接数据库，进行一些增删改查的操作，那么针对python语言，如何才能够通过程序完成连接数据库并且进行操作呢？可以通过cx_oracle这个模块来实现。
数据库DDL | 增 删 改 操作 | 对数据库数据表
m0_48851832的博客
07-23 585
数据库DDL,增删改操作，对数据库数据表进行操作
攻坚克难岁月长，自主腾飞世界强——回顾近代中国数据库的发展与飞跃
qq_44373268的博客
07-23 1253
中国数据库技术发展历程自1950年代初具雏形，至2024年已蔚然成风。1956年，中国制定《十二年科学技术发展规划》，选定计算机为四项紧急措施之一，奠定信息技术基石。1958年，首台电子计算机103机问世，标志着中国计算机时代的开启。至1960年代，中国已能自行设计计算机，并涉足数据库领域研究。1970年代，关系型数据库之父Codd的论文启发全球数据库革新，而中国虽受冷战影响，仍于1977年黄山会议拉开数据库研究序幕，萨师煊教授成为领军人物，开启中国数据库教育与研究。
数据库之数据表基本操作
m0_73514785的博客
07-22 1129
目录一、创建数据表1.创建表的语法形式2.使用SQL语句设置约束条件1.设置主键约束2.设置自增约束3.设置非空约束4.设置唯一性约束5.设置无符号约束6.设置默认约束7.设置外键约束8.设置表的存储引擎二、查看表结构1.查看表基本结构2.查看建表语句三、修改表1.修改表名2.修改字段数据类型3.修改字段名4.添加字段5.删除字段6.修改字段顺序7.修改存储引擎四、删除表1.删除没有被关联的表2.删除被其他表关联的主表创建数据表，实际上是规定列属性和实现数据完整性约束的过程，基本语法形式如下：注：一行叫做一
MySQL(1)
yajunjiao的专栏
07-22 1772
数据库这节开始写，好久没写数据库，觉得有点陌生了，现在复习下，顺便记录下。重新学习一遍，每一遍都有不一样的体会，可能就是刻意练习里的心理表征吧。
oracle 数据库存储过程
qq_22201881的博客
07-23 410
表和视图具有SELECT, INSERT, UPDATE, DELETE 这样的特权，而过程具有EXECUTE特权。我们可以命名我们的PL/SQL块，并为他们确定参数，存储在数据库中。Procedure有0或多个参数，参数可是(IN), output (OUT), (IN OUT)其实我们可以将比较复杂的查询写成函数.然后到存储过程中去调用这些函数.这些命名的PL/SQL块成为存储过程和函数，他们的集合、称为程序包。1.存储于数据库中的函数，过程是数据库对象。活性，可以完成复杂的判断和较复杂的运算。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值