RMAN-06817: Pluggable Database CHARLESPDB cannot be backed up in NOARCHIVELOG mode.
来源:互联网 发布:centos7端口聚合 编辑:程序博客网 时间:2024/06/04 18:20
1.错误现象[oracle@localhost ~]$ rman target /Recovery Manager: Release 12.2.0.1.0 - Production on Wed Mar 15 10:09:49 2017Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.connected to target database: CHARLES (DBID=1208806606)RMAN> backup database charlespdb;Starting backup at 15-MAR-17using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=65 device type=DISKRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of backup command at 03/15/2017 10:10:12RMAN-06817: Pluggable Database CHARLESPDB cannot be backed up in NOARCHIVELOG mode.RMAN> exit2.解决步骤因为只有cdb才有redo,所以非归档模式与归档模式也应该在cdb里修改
[oracle@localhost ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Wed Mar 15 10:24:17 2017Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionSQL> show con_name;CON_NAME------------------------------CDB$ROOTSQL> SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup mount;ORACLE instance started.Total System Global Area 771751936 bytesFixed Size 8797536 bytesVariable Size 608174752 bytesDatabase Buffers 46137344 bytesRedo Buffers 3784704 bytesIn-Memory Area 104857600 bytesDatabase mounted.SQL> alter database archivelog;Database altered.SQL> alter database open;Database altered.3.再次备份成功RMAN> backup database charlespdb;Starting backup at 15-MAR-17using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=63 device type=DISKchannel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00013 name=/u01/app/oralce/oradata/charles/charlespdb/test01.dbfinput datafile file number=00010 name=/u01/app/oralce/oradata/charles/charlespdb/sysaux01.dbfinput datafile file number=00009 name=/u01/app/oralce/oradata/charles/charlespdb/system01.dbfinput datafile file number=00011 name=/u01/app/oralce/oradata/charles/charlespdb/undotbs01.dbfinput datafile file number=00012 name=/u01/app/oralce/oradata/charles/charlespdb/users01.dbfchannel ORA_DISK_1: starting piece 1 at 15-MAR-17channel ORA_DISK_1: finished piece 1 at 15-MAR-17piece handle=/u01/app/oralce/product/12.2.0/dbhome_1/dbs/01rv6efs_1_1 tag=TAG20170315T102252 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:03Finished backup at 15-MAR-17Starting Control File and SPFILE Autobackup at 15-MAR-17piece handle=/u01/app/oralce/product/12.2.0/dbhome_1/dbs/c-1208806606-20170315-00 comment=NONEFinished Control File and SPFILE Autobackup at 15-MAR-17
0 0
- RMAN-06817: Pluggable Database CHARLESPDB cannot be backed up in NOARCHIVELOG mode.
- cannot mount database in EXCLUSIVE mode
- cannot mount database in EXCLUSIVE mode
- cannot mount database in EXCLUSIVE mode .
- cannot mount database in EXCLUSIVE mode .
- ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
- 【转】解决:ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
- ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
- ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
- 75.Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS
- 4.Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type of
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in exclusive mode
- ORA-01102: cannot mount database in EXCLUSIVE mode - Linux Servers
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- JDBC整合c3p0数据库连接池 解决Too many connections错误
- 鸡与蛋问题(先有Class还是先有Object)
- Angela.js 通用方法集
- HTTP中的GET与POST
- js封装ajax函数
- RMAN-06817: Pluggable Database CHARLESPDB cannot be backed up in NOARCHIVELOG mode.
- 导航跳转后保持选中状态 jquery高亮当前选中菜单
- c++实验3——个人所得税计算器
- 创建COM对象大全
- HashMap的设计原理和实现分析
- 每个Java类都有的equals方法
- zencart Fatal error: Call to a member function add_current_page()
- Spring事务Transaction配置的五种注入方式详解
- Win7使用附件中的远程桌面连接Ubuntu(xrdp方法)