Oracle 启用归档
2024-10-17 01:31:24
[applprod@erp10 ~]$ watch ps -fu applprod
[applprod@erp10 ~]$ kill -9 82902 84923
[applprod@erp10 ~]$ watch ps -fu applprod
[applprod@erp10 ~]$ cd
You have new mail in /var/spool/mail/applprod
[applprod@erp10 ~]$ kill -9 82902 84923
[applprod@erp10 ~]$ watch ps -fu applprod
[applprod@erp10 ~]$ cd
You have new mail in /var/spool/mail/applprod
[oraprod@erp10 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 27 18:35:31 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
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
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> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /erp/prod/db/data/archive
Oldest online log sequence 55
Current log sequence 56
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oraprod@erp10 ~]$ ls /erp/prod/db/data/archive
[oraprod@erp10 ~]$ ls
startdb.sh stopdb.sh
[oraprod@erp10 ~]$ sqlplus / as sysdba
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /erp/prod/db/data/archive
Oldest online log sequence 55
Current log sequence 56
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oraprod@erp10 ~]$ ls /erp/prod/db/data/archive
[oraprod@erp10 ~]$ ls
startdb.sh stopdb.sh
[oraprod@erp10 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 27 18:38:08 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
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
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;
Database closed.
Database dismounted.
ORACLE instance shut down.
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> SQL>
SQL>
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
SQL>
SQL> startup mount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 7654304 bytes
Variable Size 2751464544 bytes
Database Buffers 1.8656E+10 bytes
Redo Buffers 59453440 bytes
Database mounted.
SQL> alter database archivelog;
Fixed Size 7654304 bytes
Variable Size 2751464544 bytes
Database Buffers 1.8656E+10 bytes
Redo Buffers 59453440 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oraprod@erp10 ~]$ ls /erp/prod/db/data/archive
1_56_943217062.dbf
[oraprod@erp10 ~]$
[oraprod@erp10 ~]$
[oraprod@erp10 ~]$
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oraprod@erp10 ~]$ ls /erp/prod/db/data/archive
1_56_943217062.dbf
[oraprod@erp10 ~]$
[oraprod@erp10 ~]$
[oraprod@erp10 ~]$
最新文章
- Mysql(Mariadb) 基础操作语句 (持续更新)
- angular2 - content projection-
- Java导出数据为EXCEL的两种方式JXL和POI
- CSS 绝对定位和相对定位
- WordPress添加网站图标
- Unity3d项目合作 场景的合并和还原
- SignalR的实时高频通讯
- Windows server 2008 r2上安装MySQL
- Flask Session 使用和源码分析 —— (6)
- python 2解决编码问题
- MySQL5.7: sql script demo
- Windows 10文件夹Shirt+鼠标右键出现“在此处打开命令窗口”
- Spring_使用XML文件的方式配置事务
- OpenCV开发环境搭建-并测试一个图像灰度处理程序
- 【bzoj2878】 Noi2012—迷失游乐园
- tablix“Tablix1”有一个具有内部成员的详细信息成员
- POJ 2425 A Chess Game(有向图SG函数)题解
- kettle--变量的使用
- JSP九大对象
- Backup--完整备份会打破现有的日志备份链么?