Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to change archive log mode in 12c

Venkadesh Sivalingam-OracleMay 4 2015 — edited May 4 2015

Hi,

[oracle@localhost Desktop]$ rman

Recovery Manager: Release 12.1.0.2.0 - Production on Mon May 4 00:38:33 2015

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

RMAN> connect target sys/oracle@cdb1

connected to target database: CDB1 (DBID=828012650)

RMAN> backup database;

Starting backup at 04-MAY-15

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=284 device type=DISK

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 05/04/2015 00:38:51

RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode

RMAN> exit

Recovery Manager complete.

[oracle@localhost Desktop]$ sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Mon May 4 00:38:57 2015

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

Enter user-name: sys as sysdba

Enter password:

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> shutdown immediate;

Pluggable Database closed.

SQL> startup nomount;

SQL> startup;

Pluggable Database opened.

SQL>

Please tell me how to change archive log mode in oracle 12.1.0.2.0 db

This post has been answered by unknown-7404 on May 4 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2015
Added on May 4 2015
10 comments
73,435 views