标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (103)
- 数据库 (1,734)
- DB2 (22)
- MySQL (75)
- Oracle (1,585)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (160)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (68)
- Oracle Bug (8)
- Oracle RAC (54)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (580)
- Oracle安装升级 (95)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (82)
- PostgreSQL (27)
- pdu工具 (5)
- PostgreSQL恢复 (9)
- SQL Server (28)
- SQL Server恢复 (9)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- win平台19c 打patch遭遇2个小问题汇总
- pg单个数据库目录恢复-pdu恢复单个数据库目录数据
- pg删除数据恢复—pdu恢复pg delete数据
- .[OnlyBuy@cyberfear.com].REVRAC勒索mysql恢复
- 表dml操作权限授权给public,导致只读用户失效
- 21c数据库恢复遭遇ora-600 ktugct: corruption detected
- pg_control丢失/损坏处理
- 当前主流数据库版本服务支持周期-202503
- pg启动报invalid checkpoint record处理
- 删除redo导致ORA-00313 ORA-00312故障处理
- Navicat连接postgresql时出现column “datlastsysoid” does not exist错误解决
- aix磁盘损坏oracle数据库恢复
- pg误删除数据恢复(PostgreSQL delete数据恢复)
- PostgreSQL表文件损坏恢复—pdu恢复损坏的表文件
- linux rm -rf 删除数据文件恢复
- PostgreSQL恢复工具—pdu恢复单个表文件
- PostgreSQL恢复工具—pdu工具介绍
- 近1万个数据文件的恢复case
- 不当使用_allow_resetlogs_corruption参数引起ORA-600 2662错误
- CSSD signal 11 in thread clssnmRcfgMgrThread故障处理
分类目录归档:Oracle ASM
asm数据文件迁移(os–>asm)
--添加测试表空间 SQL> create tablespace xff datafile '/u01/oradata/xifenfei.dbf' size 10m autoextend on maxsize 100m; Tablespace created. --查看数据文件位置 SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- +DATA/tasm/system01.dbf +DATA/tasm/undotbs01.dbf +DATA/tasm/sysaux01.dbf +DATA/tasm/users01.dbf +DATA/tasm/example01.dbf /u01/oradata/xifenfei.dbf 6 rows selected. --创建测试表 SQL> create table hr.a tablespace xff 2 as 3 select * from dba_tables; Table created. SQL> select count(*) from hr.a; COUNT(*) ---------- 1580 --转移数据文件位置 [oracle@localhost oradata]$ rman target / Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jun 27 04:30:22 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: TASM (DBID=3032096031) RMAN> sql 'alter tablespace xff offline'; using target database control file instead of recovery catalog sql statement: alter tablespace xff offline RMAN> backup as copy tablespace xff format '+DATA'; Starting backup at 27-JUN-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=132 devtype=DISK channel ORA_DISK_1: starting datafile copy input datafile fno=00006 name=/u01/oradata/xifenfei.dbf output filename=+DATA/tasm/datafile/xff.269.754893121 tag=TAG20110627T043200 recid=2 stamp=754893123 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 27-JUN-11 RMAN> switch tablespace xff to copy; datafile 6 switched to datafile copy "+DATA/tasm/datafile/xff.269.754893121" RMAN> sql 'alter tablespace xff online'; sql statement: alter tablespace xff online --查看转移后的数据文件位置 SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- +DATA/tasm/system01.dbf +DATA/tasm/undotbs01.dbf +DATA/tasm/sysaux01.dbf +DATA/tasm/users01.dbf +DATA/tasm/example01.dbf +DATA/tasm/datafile/xff.269.754893121 6 rows selected. --测试其中数据是否存在 SQL> select count(*) from hr.a; COUNT(*) ---------- 1580 --创建asm中文件别名 ASMCMD> mkalias +DATA/tasm/datafile/xff.269.754893121 +DATA/tasm/xff01.dbf --文件重命名 SQL> alter tablespace xff offline; Tablespace altered. SQL> alter database rename file '+DATA/tasm/datafile/xff.269.754893121' to '+DATA/tasm/xff01.dbf'; Database altered. SQL> alter tablespace xff online; Tablespace altered. SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- +DATA/tasm/system01.dbf +DATA/tasm/undotbs01.dbf +DATA/tasm/sysaux01.dbf +DATA/tasm/users01.dbf +DATA/tasm/example01.dbf +DATA/tasm/xff01.dbf 6 rows selected. --手工删除原来数据 [oracle@localhost oradata]$ rm xifenfei.dbf
说明:可以在rman移植数据文件位置的时候,同时处理好别名,然后对表空间重命名,实现只需要表空间离线一次
发表在 Oracle ASM, rman备份/恢复
评论关闭
ASM简单管理(2)
1、磁盘组卸载/挂载
--查看当前磁盘组状态 SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup; GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB ------------ -------------------- ---------------------- ---------- ---------- 1 ARCHIVELOG MOUNTED 12637 12585 2 DATA MOUNTED 10228 7644 3 FLASHBACK MOUNTED 7836 7786 4 DG2 MOUNTED 5114 5012 --卸载dg2磁盘组 SQL> alter diskgroup dg2 dismount; Diskgroup altered. SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup; GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB ------------ -------------------- ---------------------- ---------- ---------- 1 ARCHIVELOG MOUNTED 12637 12585 2 DATA MOUNTED 10228 7644 3 FLASHBACK MOUNTED 7836 7786 0 DG2 DISMOUNTED 0 0 --挂载dg2磁盘组 SQL> alter diskgroup dg2 mount; Diskgroup altered. SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup; GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB ------------ -------------------- ---------------------- ---------- ---------- 1 ARCHIVELOG MOUNTED 12637 12585 2 DATA MOUNTED 10228 7644 3 FLASHBACK MOUNTED 7836 7786 4 DG2 MOUNTED 5114 5012 --卸载所有磁盘组 SQL> alter diskgroup all dismount; Diskgroup altered. SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup; GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB ------------ -------------------- ---------------------- ---------- ---------- 0 DATA DISMOUNTED 0 0 0 DG2 DISMOUNTED 0 0 0 FLASHBACK DISMOUNTED 0 0 0 ARCHIVELOG DISMOUNTED 0 0 --挂载所有磁盘组 SQL> alter diskgroup all mount; Diskgroup altered. SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup; GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB ------------ -------------------- ---------------------- ---------- ---------- 2 DATA MOUNTED 10228 7644 3 DG2 MOUNTED 5114 5012 4 FLASHBACK MOUNTED 7836 7786 1 ARCHIVELOG MOUNTED 12637 12585 --如果当前磁盘组有实例在访问,则不能被卸载 SQL> alter diskgroup data dismount; alter diskgroup data dismount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15027: active use of diskgroup "DATA" precludes its dismount
2、磁盘组目录
--创建目录 SQL> alter diskgroup dg2 add directory '+DG2/CHENGFEI'; Diskgroup altered. --使用asmcmd查看(export ORACLE_SID=+ASM;asmcmd进入) ASMCMD> pwd +DG2 ASMCMD> ls -l Type Redund Striped Time Sys Name N CHENGFEI/ --目录重命名 SQL> alter diskgroup dg2 rename directory '+DG2/CHENGFEI' TO '+DG2/XIFENFEI'; Diskgroup altered. ASMCMD> ls XIFENFEI/ --删除目录 SQL> alter diskgroup dg2 drop directory '+DG2/xifenfei'; Diskgroup altered. ASMCMD> ls ASMCMD>
3、文件别名
--添加别名 SQL> alter diskgroup dg2 add alias '+dg2/XIFENFEI' for '+dg2/tasm/datafile/XFF.256.754832383'; Diskgroup altered. --使用asmcmd查看别名是否成功 ASMCMD> pwd +dg2 ASMCMD> ls -l Type Redund Striped Time Sys Name Y TASM/ N XIFENFEI => +DG2/TASM/DATAFILE/XFF.256.754832383 --别名重命名 SQL> alter diskgroup dg2 rename alias '+DG2/XIFENFEI' TO '+DG2/FEIFEI.DBF'; Diskgroup altered. N XIFENFEI => +DG2/TASM/DATAFILE/XFF.256.754832383 ASMCMD> ls -l Type Redund Striped Time Sys Name N FEIFEI.DBF => +DG2/TASM/DATAFILE/XFF.256.754832383 Y TASM/ --删除别名 SQL> alter diskgroup dg2 drop alias '+dg2/feifei.dbf'; Diskgroup altered. ASMCMD> ls -l Type Redund Striped Time Sys Name Y TASM/
说明:
1)asmcmd命令行操作中,目录文件名不区分大小写,命令关键字区分大小写
2)磁盘组中的一个文件,最多只能建立一个别名可以通过v$asm_alias视图查看别名的相关信息
ASM简单管理(1)
发表在 Oracle ASM
评论关闭
ASMCMD常用命令
1、显示指定的ASM目录下ASM文件占用的所有磁盘空间
du
2、列出ASM目录下的内容及其属性
ls -ls
3、查看当前路径
pwd
4、打开目录
cd ../DATA
5、列出当前ASM客户端的信息
lsct
6、列出所有磁盘组及其属性
lsdg
7、列出数据文件信息
lsof
8、列出盘的信息
lsdsk
Note:大小写敏感
发表在 Oracle ASM
评论关闭