Oracle Enterprise Manager 11.2.0.3.0 VALID
OLAP Catalog 11.2.0.3.0 VALID
Oracle Multimedia 11.2.0.3.0 VALID
Oracle XML Database 11.2.0.3.0 VALID
Oracle Text 11.2.0.3.0 VALID
Oracle Expression Filter 11.2.0.3.0 VALID
Oracle Rules Manager 11.2.0.3.0 VALID
Oracle Workspace Manager 11.2.0.3.0 VALID
Oracle Database Catalog Views 11.2.0.3.0 VALID
Oracle Database Packages and Types 11.2.0.3.0 VALID
JServer JAVA Virtual Machine 11.2.0.3.0 VALID
Oracle XDK 11.2.0.3.0 VALID
Oracle Database Java Packages 11.2.0.3.0 VALID
OLAP Analytic Workspace 11.2.0.3.0 VALID
Oracle OLAP API 11.2.0.3.0 VALID
SQL> SELECT name, value FROM v$parameter WHERE name = 'compatible';
[oracle@PYBiz /home/oracle]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jul 25 23:37:07 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PYBIZ (DBID=3305572884)
RMAN> backup database plus archivelog delete input format '/home/bak/full_%U.dbf';
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/25/2019 23:39:16
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
从理论上来说不需要,但是noachivelog 时rman 只能备份mount 状态下的database.
所以,在实际应用中,为了达到能用 热备份,还是要求db处于achivelog
Expdp huhuan directory=expdp dumpfile=pybiz0725.dmp schemas=PYBiz logfile=0725.log
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@PYBiz /home]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 26-JUL-2019 00:28:23
Copyright (c) 1991, 2011, Oracle. All rights reserved.
分区 数据库升级(11.2.0.3-11.2.0.4) 的第 2 页
评论