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!

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,857 views