Oracle 19c rman 备份命令汇总
rman target /
RMAN> show all;
SQL> alter database archivelog;
SQL> select log_mode from v$database;
RMAN> backup database;
RMAN> list backup of database summary;
List of Backups
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
备份 类型 备份 设备 完成时间 片数 镜像数 是否压缩 标签
片号 级别 类型
1 B F A DISK 17-JAN-21 1 1 NO TAG20210117T201351
2 B F A DISK 17-JAN-21 1 1 NO TAG20210117T201351
3 B F A DISK 17-JAN-21 1 1 NO TAG20210117T201351
RMAN> list backup of database;
List of Backup Sets
BS Key Type LV Size Device Type Elapsed Time Completion Time
备份集号 备份类型 备份级别
1级备、0级份
1 Full 1.19G DISK 00:00:31 17-JAN-21
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20210117T201351
##BP Key:备份片号 Status: 备份状态,AVAILABLE代表可用 Compressed: 是否压缩,YES代表已经压缩
##Tag:标签,默认会以时间格式列出
Piece Name: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/01vksojv_1_1
##Piece Name: 备份片的物理路径
List of Datafiles in backup set 1
##List of Datafilesin backup set 1:列出1号备份片备份的数据文件信息
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
##Ckp SCN:数据文件的scn号
##Ckp Time:生产检查点时间
1 Full 2398632 17-JAN-21 NO /u01/app/oracle/oradata/ORCL/system01.dbf
3 Full 2398632 17-JAN-21 NO /u01/app/oracle/oradata/ORCL/sysaux01.dbf
4 Full 2398632 17-JAN-21 NO /u01/app/oracle/oradata/ORCL/undotbs01.dbf
7 Full 2398632 17-JAN-21 NO /u01/app/oracle/oradata/ORCL/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
2 Full 499.68M DISK 00:00:13 17-JAN-21
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20210117T201351
Piece Name: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/02vksol3_1_1
List of Datafiles in backup set 2
Container ID: 3, PDB Name: PDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
9 Full 2398652 17-JAN-21 NO /u01/app/oracle/oradata/ORCL/pdb/system01.dbf
10 Full 2398652 17-JAN-21 NO /u01/app/oracle/oradata/ORCL/pdb/sysaux01.dbf
11 Full 2398652 17-JAN-21 NO /u01/app/oracle/oradata/ORCL/pdb/undotbs01.dbf
12 Full 2398652 17-JAN-21 NO /u01/app/oracle/oradata/ORCL/pdb/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
3 Full 554.86M DISK 00:00:18 17-JAN-21
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20210117T201351
Piece Name: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/03vksoli_1_1
List of Datafiles in backup set 3
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
5 Full 2156315 11-JUL-20 NO /u01/app/oracle/oradata/ORCL/pdbseed/system01.dbf
6 Full 2156315 11-JUL-20 NO /u01/app/oracle/oradata/ORCL/pdbseed/sysaux01.dbf
8 Full 2156315 11-JUL-20 NO /u01/app/oracle/oradata/ORCL/pdbseed/undotbs01.dbf
SQL> alter session set container=PDB;
SQL> create table scott.emp1 as select * from scott.emp;
SQL> insert into scott.emp1 select * from scott.emp1;
14 rows created.
SQL> /
28 rows created.
SQL> /
56 rows created.
SQL> /
112 rows created.
SQL> commit;
Commit complete.
SQL> select GROUP#,THREAD#,SEQUENCE#,BYTES/1024/1024,ARCHIVED,STATUS,FIRST_CHANGE# from v$log;
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database
SQL> conn / as sysdba
SQL> alter system switch logfile;
SQL> alter system archive log current;
RMAN> backup archivelog all;
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
RMAN> list backup of archivelog all;
RMAN> list backup of controlfile;
RMAN> list copy;
RMAN> list backup of spfile;
RMAN> report schema;
RMAN> report need backup;
RMAN> report obsolete;
RMAN> list backup of archivelog untiltime =‘sysdate-3’;
RMAN> backup tablespace SYSTEM;
RMAN> list backup of tablespace system;
RMAN> list backup of datafile 1;
相关文章
- Oracle数据库:oracle用命令定义非空not null,unique唯一性,主键primary key,外键foreign key,check检查,启用enable,禁用disable约束
- Oracle数据库:oracle嵌套分组函数(聚合函数),组函数的练习题,挺复杂的,用好decode函数,很有趣
- Oracle数据库:oracle外连接left/right/full outer join on,oracle扩展的左右外连接展示符号(+)
- Oracle数据库:oracle启动,oracle客户端工具plsql安装教程和使用方法
- Oracle官方并发教程之一个同步类的例子
- Oracle数据库备份恢复的概念:错误类型、实例恢复方法等
- [转]ORACLE 中ROWNUM用法总结!
- oracle 列的归档,Oracle 开启或关闭归档模式
- Oracle监控指标
- 详解Oracle多种表连接方式
- 【Oracle】ORACLE SQL Developer不支持JAVA版本
- oracle收集ash和awr性能报告方法
- Oracle数据库备份还原相关语句
- oracle备份表和数据
- 转 ORACLE 查看RMAN的备份信息总结
- oracle数据库单表查询
- Oracle-创建新表,创建备份表,对表中插入多条数据
- Oracle-累加功能,累加百分比
- Oracle数据库 | Oracle备份实例
- [Oracle工程师手记] 记一次 transport lag 的解析
- 在Oracle中,RMAN中关于备份或归档文件状态OBSOLETE和EXPIRED的区别是什么?
- oracle备份和升级数据库
- ORACLE触发器具体解释
- JDBC读取Oracle的US7ASCII编码中文乱码及不同编码下汉字占用字节的问题
- 去了下 sun的 首页.之间被跳转到 oracle .进去一片红.
- MyBatis+Oracle时出现的错误: Method oracle/jdbc/driver/OracleResultSetImpl.isClosed()Z is abstract