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
原创粉丝点击