标签云
asm 恢复 asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 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)
- 操作系统 (100)
- 数据库 (1,597)
- DB2 (22)
- MySQL (70)
- Oracle (1,463)
- Data Guard (49)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (47)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (530)
- Oracle安装升级 (84)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (17)
- PostgreSQL恢复 (5)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- Oracle 19c/21c最新patch信息-202404
- PostgreSQL恢复系列:pg_filedump批量处理
- PostgreSQL部分主要字典信息
- PostgreSQL恢复系列:pg_filedump恢复字典构造
- PostgreSQL 16 源码安装
- ORA-00742 ORA-00312 恢复
- 数据库open成功后报ORA-00353 ORA-00354错误引起的一系列问题(本质ntfs文件系统异常)
- ORA-600 ktsiseginfo1故障
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
- Oracle 19C 备库DML重定向—DML Redirection
月归档:八月 2010
oracle 之rman备份数据库
1、备份整个数据库
backup database format ‘c:\rman\all_%U.bak’;
2、备份表空间
backup tablespace abc format ‘c:\rman\t_%U.bak’;
3、备份数据文件
1)backup datafile 5 format ‘c:\rman\d_%U.bak’;
2)backup datafile ‘C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ABC.DBF’
format ‘c:\rman\d_%U.bak’;
4、备份控制文件
backup current controlfile format ‘c:\rman\ctr_%U.ctl’;
5、备份数据文件同时备份控制文件
backup datafile 5 format ‘c:\rman\d_c_%U.bak’
include current controlfile;
6、备份spfile文件
backup spfile format ‘c:\rman\sp_%U.sp’;
7、备份日志文件
backup archivelog sequence between 38 and 41 format ‘c:\rman\ar_%U.log’
delete all input(可选项,表示备份日志文件后,删除原来日志文件);
8、备份数据库和日志文件
backup database plus archivelog format ‘c:\rman \d_ar_%U.d_a’;
9、copy功能(相当于用户管理备份)
backup as copy database format ‘c:\rman\%U.cy’;
copy datafile 5 to ‘c:\rman\d_%U.cy’;
note:backup as copy可以备份整个数据库
copy只能备份current controlfile、datafile、tablespace等,这个数据库不支持
发表在 Oracle备份恢复, rman备份/恢复
评论关闭
oracle之用户管理备份
一、冷备份
1、shutdown immedate
2、copy datafile/redofile/contorfile/spfile(pfile)/pwdfile
3、startup
--备份脚本(没备份spfile/pwdfile等文件) sqlplus / as sysdba set feedback off heading off verify off trimspool off set pagesize 0 linesize 200 define dir='c:\user' define ws='c:\user\user.sql' spool &ws select 'host copy '||name|| ' &dir' from v$datafile order by 1; select 'host copy '||name|| ' &dir' from v$controlfile order by 1; select 'host copy '||name|| ' &dir' from v$tempfile order by 1; select 'host copy '||member|| ' &dir' from v$logfile order by 1; select 'host copy '||value' &dir' from v$parameter where name like '%spfile%';--backup spfile spool off shutdown immediate @&ws startup
二、热备份
1)备份表空间
alter tablespace tabalepsacename begin backup;
copy
alter tablespace tabalepsacename endbackup;
2)备份整个数据库
alter database begin backup;
copy
alter database end backup;
--脚本备份表空间 set feedback off heading off verify off trimspool off set pagesize 0 linesize 200 define dir='c:\user' define ws='c:\user\user.sql' define ts=&tablespace alter tablespace &ts begin backup; spool &ws select 'host copy '|| file_name || ' &dir' from dba_data_files where tablespace_name =UPPER('&ts'); spool off @&ws alter tablespace &ts end backup; --脚本备份整个数据库 set feedback off heading off verify off trimspool off set pagesize 0 linesize 200 define dir='c:\user' define ws='c:\user\user.sql' alter database begin backup; spool &ws select 'host copy '||name|| ' &dir' from v$datafile order by 1; select 'host copy '||name|| ' &dir' from v$controlfile order by 1; select 'host copy '||name|| ' &dir' from v$tempfile order by 1; select 'host copy '||member|| ' &dir' from v$logfile order by 1; select 'host copy '||value' &dir' from v$parameter where name like '%spfile%';--backup spfile spool off @&ws alter database end backup;
3)备份数据文件
alter datafile 4 begin backup;
copy
alter datafile 4 end backup;
三、查看backup状态
select * from v$backup;
发表在 Oracle备份恢复
评论关闭
oracle之rman(1)
1、连接rman
1)nocatalog模式访问
rman target sys/xifenfei@orcl nocatalog
2)启用日志文件
rman target sys/xifenfei@orcl nocatalog append log ‘c:\rman.log’
2、查看rman configure 信息
所有信息 show all;
查看相关信息:show device type;
3、rman参数设置
1)设置参数
configure controlfile autobackup off;
2)恢复为默认参数
configure controlfile autobackup clear;
发表在 rman备份/恢复
评论关闭