11grac恢复到单机中

已于 2023-07-02 22:09:01 修改
阅读量336 收藏
点赞数
分类专栏： OracleDB 文章标签： oracle 数据库 服务器
于 2023-04-02 21:33:44 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kevinyu998/article/details/129917697
版权

今年2月，客户有个需求把 11g rac环境的数据恢复到单机测试环境，业务准备升级时测试使用。有要求就立刻行动，直接上log不解释

[root@testdb ~]# su - oracle
Last login: Thu Feb  2 21:54:12 CST 2023 on pts/2
orcl:/home/oracle@testdb> cat /u01/orcl.pfile
orcl.__db_cache_size=8086618112
orcl.__java_pool_size=33554432
orcl.__large_pool_size=67108864
orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=3221225472
orcl.__sga_target=9663676416
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=1409286144
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/data/orcl/control01.ctl','/data/orcl/control02.ctl'
*.db_block_size=8192
*.db_create_file_dest='/data'
*.db_create_online_log_dest_1='/data/orcl'
*.db_create_online_log_dest_2='/data/orcl'
*.db_domain=''
*.db_name='orcl'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.log_archive_dest_1='LOCATION=/data/archivelog'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=3221225472
*.processes=1000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=1105
*.sga_target=9663676416
*.undo_tablespace='UNDOTBS1'
orcl:/home/oracle@testdb>mkdir -p /u01/app/oracle/diag/rdbms/orcl/orcl/{incident,incpkg,ir,lck,metadata,metadata_dgif,metadata_pv,sweep,stage,trace}
orcl:/home/oracle@testdb>mkdir -p /u01/app/oracle/admin/orcl/{adump,adump,dpdump,hdump,pfile}
orcl:/home/oracle@testdb>mkdir -p /data/orcl /data/archivelog
orcl:/home/oracle@testdb>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 3 09:39:16 2023

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

Connected to an idle instance.

SQL> create spfile from pfile='/u01/orcl.pfile';

File created.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 9620525056 bytes
Fixed Size            2261368 bytes
Variable Size         1912606344 bytes
Database Buffers     7683964928 bytes
Redo Buffers           21692416 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
orcl:/home/oracle@testdb>rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Feb 3 09:39:42 2023

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

connected to target database: ORCL (not mounted)

RMAN> set dbid=1002255058

executing command: SET DBID

RMAN> restore controlfile from '/data/backup/orcl/c-1002255058-20230127-00';

Starting restore at 2023-02-03 09:40:07
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=958 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/data/orcl/control01.ctl
output file name=/data/orcl/control02.ctl
Finished restore at 2023-02-03 09:40:09

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> crosscheck backup;
..............................
RMAN> delete noprompt EXPIRED backup;
..............................

RMAN> catalog start with '/data/backup/orcl' noprompt;

searching for all files that match the pattern /data/backup/orcl

List of Files Unknown to the Database
=====================================
File Name: /data/backup/orcl/FULLBAK_ORCL_20230127_11874_1
File Name: /data/backup/orcl/FULLBAK_ORCL_20230127_11875_1
File Name: /data/backup/orcl/FULLBAK_ORCL_20230127_11876_1
File Name: /data/backup/orcl/c-1002233058-20230127-00
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230127_11878_1
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230127_11879_1
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230127_11880_1
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230127_11881_1
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230128_11885
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230128_11886
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230128_11887
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230128_11888
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230128_11889
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230129_11891
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230129_11892
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230129_11893
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230129_11894
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230130_11896
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230130_11897
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230130_11898
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230130_11899
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230131_11901
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230131_11902
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230131_11903
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230131_11904
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230131_11905
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230201_11907
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230201_11908
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230201_11909
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230201_11910
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /data/backup/orcl/FULLBAK_ORCL_20230127_11874_1
File Name: /data/backup/orcl/FULLBAK_ORCL_20230127_11875_1
File Name: /data/backup/orcl/FULLBAK_ORCL_20230127_11876_1
File Name: /data/backup/orcl/c-1002233058-20230127-00
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230127_11878_1
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230127_11879_1
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230127_11880_1
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230127_11881_1
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230128_11885
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230128_11886
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230128_11887
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230128_11888
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230128_11889
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230129_11891
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230129_11892
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230129_11893
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230129_11894
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230130_11896
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230130_11897
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230130_11898
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230130_11899
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230131_11901
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230131_11902
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230131_11903
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230131_11904
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230131_11905
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230201_11907
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230201_11908
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230201_11909
File Name: /data/backup/orcl/ARCHBAK_ORCL_20230201_11910

RMAN> run{

allocate channel c1 type disk;
allocate channel c2 type disk;
set until time "to_date('2023-01-30 08:00:00','yyyy-mm-dd hh24:mi:ss')";
set newname for datafile 1 to '/data/orcl/system.534.856709121';
set newname for datafile 2 to '/data/orcl/sysaux.530.856709121';
set newname for datafile 3 to '/data/jwdb/undotbs1.526.856709121';
set newname for datafile 4 to '/data/orcl/users.522.856709121';
set newname for datafile 5 to '/data/orcl/undotbs2.501.856709317';
set newname for datafile 6 to '/data/orcl/fwpt.dbf';
set newname for datafile 7 to '/data/orcl/tsp_monitor.dbf';
set newname for datafile 8 to '/data/orcl/sysaux.408.973008757';
set newname for datafile 9 to '/data/orcl/eams.376.1053705005';
set newname for tempfile 1 to '/data/orcl/temp.505.856709225';
set newname for tempfile 2 to '/data/orcl/tsp_monitor_temp.dbf';
RESTORE DATABASE;
SWITCH datafile ALL;
SWITCH tempfile ALL;

recover database delete archivelog;

release channel c1;
release channel c2;

}   

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 2023-02-03 09:43:33
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /data/orcl/system.534.856709121
channel ORA_DISK_1: restoring datafile 00004 to /data/orcl/users.522.856709121
channel ORA_DISK_1: restoring datafile 00006 to /data/orcl/fwpt.dbf
channel ORA_DISK_1: reading from backup piece /data/backup/orcl/FULLBAK_ORCL_20230127_11876_1
channel ORA_DISK_1: piece handle=/data/backup/orcl/FULLBAK_ORCL_20230127_11876_1 tag=DB_FULL_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /data/orcl/sysaux.530.856709121
channel ORA_DISK_1: restoring datafile 00003 to /data/orcl/undotbs1.526.856709121
channel ORA_DISK_1: restoring datafile 00009 to /data/orcl/eams.376.1053705005
channel ORA_DISK_1: reading from backup piece /data/backup/orcl/FULLBAK_ORCL_20230127_11874_1
channel ORA_DISK_1: piece handle=/data/backup/orcl/FULLBAK_ORCL_20230127_11874_1 tag=DB_FULL_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:26
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00005 to /data/orcl/undotbs2.501.856709317
channel ORA_DISK_1: restoring datafile 00007 to /data/orcl/tsp_monitor.dbf
channel ORA_DISK_1: restoring datafile 00008 to /data/orcl/sysaux.408.973008757
channel ORA_DISK_1: reading from backup piece /data/backup/orcl/FULLBAK_ORCL_20230127_11875_1
channel ORA_DISK_1: piece handle=/data/backup/orcl/FULLBAK_ORCL_20230127_11875_1 tag=DB_FULL_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
Finished restore at 2023-02-03 09:46:49

datafile 1 switched to datafile copy
input datafile copy RECID=10 STAMP=1127814409 file name=/data/orcl/system.534.856709121
datafile 2 switched to datafile copy
input datafile copy RECID=11 STAMP=1127814409 file name=/data/orcl/sysaux.530.856709121
datafile 3 switched to datafile copy
input datafile copy RECID=12 STAMP=1127814409 file name=/data/orcl/undotbs1.526.856709121
datafile 4 switched to datafile copy
input datafile copy RECID=13 STAMP=1127814409 file name=/data/orcl/users.522.856709121
datafile 5 switched to datafile copy
input datafile copy RECID=14 STAMP=1127814409 file name=/data/orcl/undotbs2.501.856709317
datafile 6 switched to datafile copy
input datafile copy RECID=15 STAMP=1127814409 file name=/data/orcl/fwpt.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=16 STAMP=1127814409 file name=/data/orcl/tsp_monitor.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=17 STAMP=1127814409 file name=/data/orcl/sysaux.408.973008757
datafile 9 switched to datafile copy
input datafile copy RECID=18 STAMP=1127814409 file name=/data/orcl/eams.376.1053705005

renamed tempfile 1 to /data/orcl/temp.505.856709225 in control file
renamed tempfile 2 to /data/orcl/tsp_monitor_temp.dbf in control file

Starting recover at 2023-02-03 09:46:49
using channel ORA_DISK_1

starting media recovery

....................................

channel ORA_DISK_1: reading from backup piece /data/backup/orcl/ARCHBAK_ORCL_20230131_11901
channel ORA_DISK_1: piece handle=/data/backup/orcl/ARCHBAK_ORCL_20230131_11901 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/data/archivelog/1_26599_856709220.dbf thread=1 sequence=26599
channel default: deleting archived log(s)
archived log file name=/data/archivelog/2_17966_856709220.dbf RECID=44555 STAMP=1127814514
archived log file name=/data/archivelog/2_17967_856709220.dbf thread=2 sequence=17967
channel default: deleting archived log(s)
archived log file name=/data/archivelog/1_26599_856709220.dbf RECID=44561 STAMP=1127814520
channel default: deleting archived log(s)
archived log file name=/data/archivelog/2_17967_856709220.dbf RECID=44560 STAMP=1127814520
media recovery complete, elapsed time: 00:00:02
Finished recover at 2023-02-03 09:48:42

RMAN> exit


Recovery Manager complete.
orcl:/home/oracle@testdb>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 3 09:57:39 2023

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>  alter database rename file '+DATA/orcl/onlinelog/group_1.514.856709221' to '/data/orcl/group_1.514.856709221';
Database altered.

SQL> alter database rename file '+DATA/orcl/onlinelog/group_2.510.856709221' to '/data/orcl/group_2.510.856709221';
Database altered.

SQL> alter database rename file '+DATA/orcl/onlinelog/group_3.497.856709411' to '/data/orcl/group_3.497.856709411';
Database altered.

SQL> alter database rename file '+ARCH/orcl/onlinelog/group_3.469.856709411' to '/data/orcl/group_3.469.856709411';
Database altered.

SQL> alter database rename file '+DATA/orcl/onlinelog/group_4.492.856709411' to '/data/orcl/group_4.492.856709411';
Database altered.

SQL> alter database rename file '+ARCH/orcl/onlinelog/group_4.478.856709413' to '/data/orcl/group_4.478.856709413';
Database altered.

SQL> alter database rename file '+ARCH/orcl/onlinelog/group_1.564.856709221' to '/data/orcl/group_1.564.856709221';
Database altered.

SQL> col MEMBER for a60;
SQL> select GROUP#, member from v$logfile;

    GROUP# MEMBER
---------- ------------------------------------------------------------
     2 /data/orcl/group_2.510.856709221
     2 /data/orcl/group_2.466.856709221
     1 /data/orcl/group_1.514.856709221
     1 /data/orcl/group_1.564.856709221
     3 /data/orcl/group_3.497.856709411
     3 /data/orcl/group_3.469.856709411
     4 /data/orcl/group_4.492.856709411
     4 /data/orcl/group_4.478.856709413

8 rows selected.

SQL> alter database open resetlogs;

Database altered.


SQL> select name,open_mode from v$database;

NAME         OPEN_MODE
------      ---------------
ORCL        READ WRITE

原环境中的数据文件和临时文件、redo文件查看

$sqlplus / as sysdba
 set pagesize 199;
 set linesize 199;
 col name for a50;
 select file#,name from v$datafile;
 select FILE#,name from v$tempfile;

col MEMBER for a60;
select GROUP#, member from v$logfile;

清除未使用线程的redo日志组，操作如下：
alter database disable thread 2;
alter database drop logfile group 3;
alter database drop logfile group 4;

.。。。。

清除多余的undo文件。
select name from v$tablespace where name like 'UNDO%';
show parameter undo_tablespace;
drop tablespace UNDOTBS2 including contents and datafiles;

bestsun999
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle RAC恢复到单机方案-仅有一个全备
05-04
目标：Oracle RAC只有一个历史全备（热备），无增量备份和归档备份，现需恢复到单机上。文档给出具体步骤和可能遇到的错误。
oracle10g rac环境Rman备份恢复至单机方案
09-18
Oracle 10g RAC 环境下的RMAN（Recovery Manager）备份恢复至单机环境是一项复杂但重要的任务，特别是在灾难恢复或系统迁移的场景中。以下将详细阐述这个过程的关键步骤和注意事项。 首先，RMAN是Oracle数据库管理...
RAC生产数据库RMAN方式恢复到异地单机
jnrjian的博客
03-26 2232
---10g set dbid 源端环境介绍： 生产数据库是包含两个节点的Oracle 10g 10.2.0.3 RAC数据库： ASM管理+裸设备 数据库名：racdb 第一节点的sid：racdb1 第一节点的sid：racdb2 异地单机数据库（恢复Server）介绍： 下面将详细记录整个从RAC到单机的详细恢复过程。 【实验BEGIN】 1.将源端的RMAN备份的所有文件拷贝到恢复Server上 脚本如下，注意这里使用了一个保证scp不会中断的小技巧（sleep） racdb1@te..
Oracle RAC 数据库备份恢复至单机oracle
最新发布
gaoda00136的博客
06-16 534
查看监听状态并配置，编辑tnsname.ora文件。查看undo表空间，并删除节点2（在此不使用）的undo表空间。通过以下命令创建密码文件，注意密码文件的位置（mos文档没有）查看redo log 信息，并删除无效日志组（节点2日志）检查并标记控制文件中存在，但是实际已经不存在的备份文件。清理控制文件中存在，但是实际已经不存在的备份文件。创建pfile文件并修改传送到单机环境对应目录下。查看redo log 信息，并删除无效日志组。--重命名tempfile文件。确定备份路径，并赋予属组。
Oracle11g RAC集群环境备份恢复到单机环境
weixin_52444902的博客
11-25 2269
Oracle11g RAC集群环境备份恢复到单机
oracle 用户权限之执行存储过程权限不足
热门推荐
www_xue_xi的博客
06-20 1万+
ORACLE 执行revoke dba from user_name后需要细粒度赋权限，否则用户没有在指定表空间创建表的权限、执行dml的权限以及执行存储过程的权限。
Oracle迁移(RAC变单机模式)
小5哥的专栏
11-10 869
Oracle备份迁移恢复（RAC变单机模式）
11g rac赋予sys对sysasm的权限，默认无权限，修改asm密码
sqlora的专栏
10-12 992
ASMCMD> orapwusr --modify --password sys Enter password: ******jycjyc ASMCMD> exit [root@rac1 ~]# su - grid Last login: Tue Oct 12 15:52:27 CST 2021 on pts/0 [grid@rac1 ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 12
AIX6.1两节点的ORACLE10.2.0.5RAC恢复到单机
09-20
AIX6.1两节点的ORACLE10.2.0.5RAC+RAW恢复到单机JFS2，仅供参考！
ORACLE 10G单机转RAC
07-11
Oracle 10G单机转RAC的过程是一个复杂的操作，涉及到数据库架构的转换、网络配置、存储设置等多个方面。在进行这种转换时，首先要确保原始单机环境的稳定性和数据完整性，然后再逐步构建RAC环境。 1. **单机环境...
oracle 11g RAC<-->单机 高可用dataguard 主备正确切换步骤
12-07
本文将详细介绍Oracle 11g RAC高可用Dataguard 主备正确切换步骤，涵盖RAC切单机、单机切换回RAC、切换失败强制升级备机到主用、不同步、重新同步等步骤。 一、RAC切单机 在进行高可用Dataguard 主备切换前，需要...
一键超级智能脚本支持单机和Rac支持11g 12c 19c
10-16
作为一名Oracle DBA，工作中无可避免的需要安装部署Oracle数据库，例如生产建库，恢复测试，容灾搭建等等。
12.2RAC环境从RAC转为单机模式的问题处理
还不算晕的专栏
09-08 437
一开始只是将数据库软件通过make -f ins_rdbms.mk rac_off 和 make -f ins_rdbms.mk ioracle关闭RAC模式；然后在启动数据库（sqlplus / as sysdba登录后startup时报错：ORA-00600: internal error code, arguments: [kgfz_getDiskAccessMode:ntyp], [0], [], [], [], [], [], [], [], [], [], []2.启动数据库实例时的报错。
sysdba用户远程启停oracle数据库ORA-12514: TNS:listener does not currently know of service requested
sqlora的专栏
11-24 477
满足如下条件即可远程启停库1.创建sysdba用户，赋予connect和sysdba权限 2.remote_login_passwordfile为 EXCLUSIVE 3.加入静态监听 Last login: Tue Nov 3 11:01:16 2020 from 192.168.52.1 [root@saperp ~]# su - oracle Last login: Fri Oct 30 14:44:06 CST 2020 on pts/0 [oracle@saperp ~]$ sqlplus /.
Oracle database 12cRAC异地恢复至单机
zhangyongze_z的博客
01-03 1189
系统版本：Red Hat Enterprise Linux Server release 6.5软件版本：Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit。
oracle 11g2,ORACLE 11g从 11.2.0.1升级到11.2.0.4 详细实战教程
weixin_42311000的博客
04-08 513
1、准备安装@H_404_3@查看当前oracle版本，确定是比较旧的11.2.0.1exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning,Data Mining and Real Application Test...
Oracle RAC 转换为单实例
Database、Code
02-11 2990
OS：redhat 5.8 DB:Oracle RAC 10.2.0.5.0（raw devices） 背景：由于存储IO瓶颈，客户voting disk磁盘写入速度为几kb每秒，导致两节点宕机。只要启动crs就宕机，由于白天业务需要正常运行。所以将rac临时转换为单实例用 总体步骤： 1、创建pfile 2、relink oracle 3、pfile启动数据库
oracle 11g 延迟验证,取消 11G延迟密码验证
weixin_30744857的博客
04-13 320
新特性在提供方便，安全的同时，也会带来相应的bug.11G引入了延迟密码验证，在输入错误的密码后，后续如果还是采用错误的密码登陆，将会导致密码延迟验证，而且会导致失败登陆延长。我们通过一个小例子来看看11G引入了延迟密码验证新特性。该特性提供个更加安全的同时，也容易产生相应的bug，在真实的环境中，我们遭遇到了bug.请查看我的上一篇文章《》我们使用SQLPLUS 的静默链接，把相应的时间SQL&...
oracle 11g升级步骤,Oracle 11g升级PSU详细步骤
weixin_35851508的博客
04-02 600
Oracle 每个季度都会发布最新的补丁。对于生产运维人员来说，定期升级系统、打补丁是日常工作中不可缺少的部分。相对于过去的版本，Oracle打补丁的方式已经变得比较简单，处理PSU的方法也发生了一些变化。在11g中，对于一些小bug的修复，我们可以使用OPatch工具进行补丁修复。对于大的版本升级，Oracle的PSU实际上就是一系列全新的安装文件，从MOS上下载之后就可以直接进行安装。1、关闭...
Oracle11g RAC for Linux 安装教程
"这是一份关于在Linux环境下安装Oracle 11g RAC的详细指南，涵盖了系统网络配置、硬件需求、操作系统安装、数据库安装包及补丁等关键步骤。" 在部署Oracle 11g Real Application Clusters (RAC)时，系统网络资源的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值