随笔分类 - oracle->备份和恢复
摘要:场景:完全备份后创建新的表空间之后没有备份,所有的控制文件丢失,但是归档日志和在线重做日志的都是正常的环境:OS:Centos 7DB:11.2.0.41.完全备份#!/bin/shbackup_date=`date +%Y-%m-%d`rman target / log=/home/oracle/
阅读全文
摘要:recover database using backup controlfile 并不是使用rman备份的控制文件的scn恢复,而是以当前redo的记录的scn进行恢复 recover database using backup controlfile实际上是告诉数据库,我要联机日志的最大scn为
阅读全文
摘要:注意表恢复只能恢复pdb本地用户下的表 直接恢复表 RMAN>recover table hxl.tb_objects of pluggable database ORA12CPDB1 until sequence 34 auxiliary destination '/u01/temp/res/'
阅读全文
摘要:环境: OS:Centos 7 DB:12.2.0.1 数据库做不完全恢复1.首先做个全备run{allocate channel ch1 device type disk;backup as compressed backupset full filesperset 5 database form
阅读全文
摘要:环境: OS:Centos 7 DB:12.2.0.1 1.备份数据库run{allocate channel ch1 device type disk;backup as compressed backupset full filesperset 5 database format '/u01/r
阅读全文
摘要:我在模拟归档日志丢失,不完全恢复的时候,无法打开数据,最后采用_allow_resetlogs_corruption进行打开 SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01
阅读全文
摘要:delete obsolete; 发现出现报错 ORA-19606: Cannot copy or restore to snapshot control file 解决办法:CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/produc
阅读全文
摘要:1.convert tablespaceconvert tablespace源端库执行:convert tablespace 'TPS_DATA' to platform 'AIX-Based Systems (64-bit)' db_file_name_convert '/u01/app/orac
阅读全文
摘要:1.db_file_name_convert备份保持原来文件名一致 backup as copy db_file_name_convert=('/u01/app/oracle/oradata/slnngk/','/home/oracle/image_copy/') database; 2.list相
阅读全文
摘要:1.从备份集恢复某个归档日志到指定的目录 run{allocate channel ci type disk;set archivelog destination to '/home/oracle/myarchlog';restore archivelog sequence 299;release
阅读全文
摘要:1.全备份例子 #!/bin/sh RMAN_OUTPUT_LOG=/home/oracle/rman_output.logRMAN_ERROR_LOG=/home/oracle/rman_error.logrman target / log=/home/oracle/rman_output.log
阅读全文