rman 异地恢复过程日志

最新推荐文章于 2023-01-08 17:27:06 发布
最新推荐文章于 2023-01-08 17:27:06 发布
阅读量284 收藏
点赞数
文章标签： 数据库
原文链接：http://blog.51cto.com/860143/2399420
版权

[oracle@169_test ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 24 10:07:51 2019

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@169_test ~]$ cd $ORACLE_HOME/dbs
[oracle@169_test dbs]$ ll
总用量 20892
-rw-r----- 1 oracle oinstall 7143424 5月 22 19:19 c-1190123479-20190522-07
-rw-r----- 1 oracle oinstall 7143424 5月 23 11:08 c-1190123479-20190523-03
-rw-rw---- 1 oracle oinstall 1552 5月 24 10:08 hc_TSH1.dat
-rw-rw---- 1 oracle oinstall 12920 5月 3 2001 initdw.ora
-rw-rw---- 1 oracle oinstall 8387 5月 22 19:08 init.ora
-rw-rw---- 1 oracle oinstall 24 5月 22 19:16 lkORCL10G
-rw-r----- 1 oracle oinstall 1536 5月 22 19:00 orapworcl
-rw-r----- 1 oracle oinstall 7061504 5月 23 11:08 snapcf_TSH1.f
-rw-r----- 1 oracle oinstall 3584 5月 23 11:04 spfileTSH1.ora
[oracle@169_test dbs]$ rm c-1190123479-2019052
c-1190123479-20190522-07 c-1190123479-20190523-03
[oracle@169_test dbs]$ rm c-1190123479-2019052*
[oracle@169_test dbs]$ rm spfileTSH1.ora
[oracle@169_test dbs]$ rm snapcf_TSH1.f
[oracle@169_test dbs]$ ll
总用量 40
-rw-rw---- 1 oracle oinstall 1552 5月 24 10:08 hc_TSH1.dat
-rw-rw---- 1 oracle oinstall 12920 5月 3 2001 initdw.ora
-rw-rw---- 1 oracle oinstall 8387 5月 22 19:08 init.ora
-rw-rw---- 1 oracle oinstall 24 5月 22 19:16 lkORCL10G
-rw-r----- 1 oracle oinstall 1536 5月 22 19:00 orapworcl
[oracle@169_test dbs]$ rm hc_TSH1.dat
[oracle@169_test dbs]$ ll
总用量 36
-rw-rw---- 1 oracle oinstall 12920 5月 3 2001 initdw.ora
-rw-rw---- 1 oracle oinstall 8387 5月 22 19:08 init.ora
-rw-rw---- 1 oracle oinstall 24 5月 22 19:16 lkORCL10G
-rw-r----- 1 oracle oinstall 1536 5月 22 19:00 orapworcl
[oracle@169_test dbs]$ cat lkORCL10G
DO NOT DELETE THIS FILE![oracle@169_test dbs]$
[oracle@169_test dbs]$ ll
总用量 36
-rw-rw---- 1 oracle oinstall 12920 5月 3 2001 initdw.ora
-rw-rw---- 1 oracle oinstall 8387 5月 22 19:08 init.ora
-rw-rw---- 1 oracle oinstall 24 5月 22 19:16 lkORCL10G
-rw-r----- 1 oracle oinstall 1536 5月 22 19:00 orapworcl
[oracle@169_test dbs]$ cd $ORACL_BASE
[oracle@169_test ~]$ ll
总用量 782848
-rw-r--r-- 1 oracle oinstall 801603584 4月 16 09:09 10201_database_linux_x86_64.cpio
drwxr-xr-x 6 oracle oinstall 101 10月 23 2005 database
-rw-r--r-- 1 oracle oinstall 16444 4月 16 11:45 dbca.rsp
-rw-r--r-- 1 oracle oinstall 920 4月 16 11:24 enterprise01.rsp
-rw-r--r-- 1 oracle oinstall 5742 4月 16 11:49 netca.rsp
[oracle@169_test ~]$ cd /u01/app/oracle/
admin/ flash_recovery_area/ oradata/ oraInventory/ product/
[oracle@169_test ~]$ cd /u01/app/oracle/oradata/
[oracle@169_test oradata]$ ll
总用量 0
drwxr-xr-x 2 oracle oinstall 221 5月 23 11:08 orcl10g
[oracle@169_test oradata]$ cd orcl10g/
[oracle@169_test orcl10g]$ ll
总用量 1078636
-rw-r----- 1 oracle oinstall 7061504 5月 24 10:08 control01.ctl
-rw-r----- 1 oracle oinstall 7061504 5月 24 10:08 control02.ctl
-rw-r----- 1 oracle oinstall 7061504 5月 24 10:08 control03.ctl
-rw-r----- 1 oracle oinstall 52429312 5月 24 10:08 redo01.log
-rw-r----- 1 oracle oinstall 52429312 5月 23 11:08 redo02.log
-rw-r----- 1 oracle oinstall 52429312 5月 24 01:00 redo03.log
-rw-r----- 1 oracle oinstall 367009792 5月 24 10:08 sysaux01.dbf
-rw-r----- 1 oracle oinstall 513810432 5月 24 10:08 system01.dbf
-rw-r----- 1 oracle oinstall 20979712 5月 23 22:00 temp01.dbf
-rw-r----- 1 oracle oinstall 26222592 5月 24 10:08 undotbs01.dbf
-rw-r----- 1 oracle oinstall 18358272 5月 24 10:08 users01.dbf
[oracle@169_test orcl10g]$ rm -f .
[oracle@169_test orcl10g]$ ll
总用量 0
[oracle@169_test orcl10g]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Fri May 24 10:12:31 2019

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

connected to target database (not started)

RMAN> startup nomount;

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initTSH1.ora'

starting Oracle instance without parameter file for retrival of spfile
Oracle instance started

Total System Global Area 159383552 bytes

Fixed Size 2019224 bytes
Variable Size 67108968 bytes
Database Buffers 83886080 bytes
Redo Buffers 6369280 bytes

RMAN> restore spfile from '/u01/app/backup/c-1190123479-20190523-02';

Starting restore at 24-MAY-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK

channel ORA_DISK_1: autobackup found: /u01/app/backup/c-1190123479-20190523-02
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 24-MAY-19

RMAN> shutdown immediate;

Oracle instance shut down

RMAN> startup nomount;

connected to target database (not started)
Oracle instance started

Total System Global Area 1224736768 bytes

Fixed Size 2020384 bytes
Variable Size 369101792 bytes
Database Buffers 838860800 bytes
Redo Buffers 14753792 bytes

RMAN> restore controlfile from '/u01/app/backup/rman_control_3iu28plf_1_1.ctl';

Starting restore at 24-MAY-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output filename=/u01/app/oracle/oradata/orcl10g/control01.ctl
output filename=/u01/app/oracle/oradata/orcl10g/control02.ctl
output filename=/u01/app/oracle/oradata/orcl10g/control03.ctl
Finished restore at 24-MAY-19

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> crosscheck backup ;

Starting implicit crosscheck backup at 24-MAY-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
Crosschecked 7 objects
Finished implicit crosscheck backup at 24-MAY-19

Starting implicit crosscheck copy at 24-MAY-19
using channel ORA_DISK_1
Finished implicit crosscheck copy at 24-MAY-19

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files

File Name: /u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2019_05_24/o1_mf_1_1ggfng8rt.arc

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/backup/rman_db_ORCL10G_108_20190523_1_3cu28pkm_1_1.bkupset recid=127 stamp=1009018518
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/backup/rman_db_ORCL10G_107_20190523_1_3bu28pkm_1_1.bkupset recid=128 stamp=1009018518
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/backup/rman_control_3du28pl5_1_1.ctl recid=129 stamp=1009018533
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/skoda_spfile_3eu28pl6_1_1 recid=130 stamp=1009018534
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/c-1190123479-20190523-01 recid=131 stamp=1009018536
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/backup/rman_arch_ORCL10G_112_20190523_1_3gu28plc_1_1.bkupset recid=132 stamp=1009018541
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/backup/rman_arch_ORCL10G_113_20190523_1_3hu28plc_1_1.bkupset recid=133 stamp=1009018541
Crosschecked 7 objects

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
validation succeeded for archived log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2019_05_24/o1_mf_1_1ggfng8rt.arc recid=41 stamp=1009102680
Crosschecked 1 objects

RMAN> run{
2>
3> restore database;
4>
5> recover database;
6>
7> }

Starting restore at 24-MAY-19
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/app/oracle/oradata/orcl10g/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/orcl10g/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/backup/rman_db_ORCL10G_108_20190523_1_3cu28pkm_1_1.bkupset
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/backup/rman_db_ORCL10G_108_20190523_1_3cu28pkm_1_1.bkupset tag=TAG20190523T105518
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/orcl10g/system01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/orcl10g/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/backup/rman_db_ORCL10G_107_20190523_1_3bu28pkm_1_1.bkupset
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/backup/rman_db_ORCL10G_107_20190523_1_3bu28pkm_1_1.bkupset tag=TAG20190523T105518
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 24-MAY-19

Starting recover at 24-MAY-19
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 1 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2019_05_24/o1_mf_1_1ggfng8rt.arc
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=65
channel ORA_DISK_1: reading from backup piece /u01/app/backup/rman_arch_ORCL10G_112_20190523_1_3gu28plc_1_1.bkupset
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/backup/rman_arch_ORCL10G_112_20190523_1_3gu28plc_1_1.bkupset tag=TAG20190523T105540
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2019_05_24/o1_mf_1_65gggo7r1s.arc thread=1 sequence=65
channel default: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2019_05_24/o1_mf_1_65gggo7r1s.arc recid=42 stamp=1009102840
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=66
channel ORA_DISK_1: reading from backup piece /u01/app/backup/rman_arch_ORCL10G_113_20190523_1_3hu28plc_1_1.bkupset
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/backup/rman_arch_ORCL10G_113_20190523_1_3hu28plc_1_1.bkupset tag=TAG20190523T105540
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2019_05_24/o1_mf_1_66gggo7t5o.arc thread=1 sequence=66
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2019_05_24/o1_mf_1_1ggfng8rt.arc thread=1 sequence=1
channel default: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL10G/archivelog/2019_05_24/o1_mf_1_66gggo7t5o.arc recid=43 stamp=1009102842
unable to find archive log
archive log thread=1 sequence=2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/24/2019 10:21:09
RMAN-06054: media recovery requesting unknown log: thread 1 seq 2 lowscn 2003505

RMAN> alter database open resetlogs;

database opened

RMAN> exit

Recovery Manager complete.
[oracle@169_test orcl10g]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 24 10:22:44 2019

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> conn test/test;
Connected.
SQL> *select from test;**

    ID

NAME

     2

美国

     3

德国

     4

英国

    ID

NAME

     1

中国

SQL> shutdown immediate;
ORA-01031: insufficient privileges
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@169_test orcl10g]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 24 10:23:44 2019

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size 2020384 bytes
Variable Size 369101792 bytes
Database Buffers 838860800 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

转载于:https://blog.51cto.com/860143/2399420

weixin_34113237
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
rman 恢复部分归档日志
weixin_33904756的博客
08-21 2577
rac环境下恢复部分归档日志。 恢复全部归档日志文件restore archivelog all 恢复从第5个归档日志起restore archivelog from logseq 5;只恢复 5到10这四个归档日志文件restore archivelog from logseq 5 until logseq 10;恢复7天内的归档日志--默认恢复所有线...
rman迁移及异地恢复
我爱海
11-12 4426
<br />/u01/app/oracle/product/10.1/bin/rman target sys/sys123<br />一、在数据库没有改变的情况下<br />1、备份全库及控制文件<br />run {<br />  configure controlfile autobackup on;<br />  configure controlfile autobackup format for device type disk to '/opt/rmanbak/%F';<br />  alloc
oracle rman 异地恢复,Oraclerman恢复到异地、异机
weixin_35282085的博客
04-10 403
原来的Oracle数据库服务器使用rman进行全库的备份，然后再异地的服务器上恢复一模一样的数据库原来的Oracle数据库服务器使用rman进行全库的备份，，然后再异地的服务器上恢复一模一样的数据库1.1 原服务器备份数据库第一步，查看数据库的实例名和DBIDconnected to target database: DB3 (DBID=2060124769, not open)第二步，...
oracle rman 异地恢复,RMAN异地恢复
weixin_39943370的博客
04-10 424
一、源服务器备份数据库1，查看数据库的实例名和DBIDconnected to target database: DB3 (DBID=2060124769, not open)2，进行全备份backup AS COMPRESSED BACKUPSET databaseinclude current controlfile format '/orabak/db_%d_%T_%s'plus archi...
Oracle rman异地全库恢复
mm15922520865的博客
11-07 1997
Oracle rman异地全库恢复
RMAN异地恢复
03-10
### RMAN异地恢复详解 #### 一、背景与概述 在企业级数据库管理中，确保数据的安全性和可恢复性至关重要。对于Oracle数据库来说，RMAN（Recovery Manager）是一种非常强大的工具，它不仅可以帮助管理员执行数据库...
RMAN异地恢复操作步骤
10-29
### RMAN异地恢复操作步骤详解 #### 一、前言 在数据库管理中，数据的安全性和可用性至关重要。为了确保数据安全，企业通常会采用多种备份策略和技术来防止数据丢失。RMAN（Recovery Manager）是Oracle提供的一种...
手把手教你ORACLE RMAN异地备份
08-19
"手把手教你ORACLE RMAN异地备份" 该教程旨在教你如何使用ORACLE RMAN实现异地备份，解决了由于数据量急剧增加、...该教程提供了一个详细的ORACLE RMAN异地备份解决方案，解决了服务器空间不足和备份恢复的困难问题。
Rman全备份异地恢复过程
08-22
### Rman全备份异地恢复过程详解 #### 一、引言 在数据库管理领域，RMAN（Recovery Manager）是Oracle提供的一种强大的备份与恢复工具。本文将详细讲解如何使用RMAN进行全备份数据的异地恢复操作。此过程不涉及重建...
rman 异地恢复，备份路径不一样时数据库恢复
10-26
RMAN 异地恢复、备份路径不...RMAN 异地恢复需要多个步骤，包括创建软连接、恢复控制文件、重命名数据文件和日志文件、恢复数据库、Switch 数据文件、恢复主机、FTP 文件传输、创建软连接的上级目录和启动数据库等。
RMAN备份恢复（日志文件）
congwei2855的博客
03-16 490
如果日志文件丢失会有几种情况 ...
Oracle利用RMAN做异地恢复实验-针对数据库量小的情况
雅冰石的专栏
10-22 2431
一：实验介绍 把一台机器上面的某个数据库恢复到另一台机器上（相当于，建个测试环境，以便进行相关操作） 二：实验环境 操作系统 IP 数据库环境 数据库实例名称 主机名称 source端 RedHat 192.168.8.225 单实例 ORCL sourc
RMAN恢复操作
zhenglib18的专栏
02-21 546
一、RMAN恢复综述   1、RMAN完全恢复     是指当数据文件出现介质失败时，使用RESTORE命令转储数据文件备份，并使用RECOVER命令将数据文件恢复到失败点的状态。当数据库处于ARCHIVELOG模式时，在进行日志切换时会自动生成归档日志，并且会将所有重做历史记录存放到归档日志中。   2、RMAN不完全恢复     是指当数据库出现介质失败或逻辑失败时，使用RESTORE
RMAN异地恢复-适用于数据库量比较大的场景
最新发布
雅冰石的专栏
01-08 1156
如果数据库比较大，可以提前几天将全备文件拷贝过来，在目标端restore database，然后每天增量拷贝归档日志的备份，直到真正迁移的时候，只拷贝最近的归档日志的备份，最后在目标端recover database，可大大缩短业务停止时间。
RMAN的备份与恢复-重读日志文件恢复
lufei051的专栏
10-31 455
C:/Documents and Settings/Administrator>sqlplus /nolog  SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 6月 30 14:21:20 2011  Copyright (c) 1982, 2007, Oracle.  All rights reserved.  SQL> conn / as sy
RMAN异机恢复步骤
XavierSuen的博客
05-28 6081
RMAN是DBA日常工作非常常用的工具，RMAN的应用场景大概有数据备份恢复、数据迁移等。我们不常用本机RMAN恢复，因为在实际生产中RMAN备份通常是用于异机恢复，比如数据迁移，DG搭建，恢复备份库等操作。 最近做RMAN异机恢复比较多，所以就总结下步骤，先说下重要的几点： 1. 如果恢复的那台数据库是单机库的话，那么在创建这台单机库的时候可以不用dbca创建实例。如果是RAC库的话就需要d...
oracle rman异地备份,Rman 异地备份 - markGao的个人空间 - OSCHINA - 中文开源技术交流社区...
weixin_35723352的博客
04-03 275
因为我们数据库服务器的空间有限，同时也考虑到异地备份的好处，虽说异地备份操作比同机备份繁琐，但是我们还是推荐使用Rman 的异地备份。1．在备份以前请确认数据库的归档方式RMANCMDC:\Documents and Settings\cpnuser>sqlplus /nologSQL*Plus: Release 11.1.0.7.0 - Production on Tue Jul 16 1...
RMAN 备份异机恢复流程总结
crrcoo9093的博客
12-17 91
RMAN 备份异机恢复流程总结 测试环境信息： 源服务器： IP地址：10.130.160.200 OS：RedHat as 5.5 Oracle：10.2.0.4 x64 ORAC...
Rman 异地备份
weixin_33801856的博客
11-28 157
2019独角兽企业重金招聘Python工程师标准>>> ...
RMAN异地备份解决方案：Oracle数据库备份至远程服务器
在这种情况下，RMAN（Recovery Manager）提供了一种高效且灵活的解决方案，即通过异地备份来解决存储和恢复的难题。 RMAN是Oracle数据库自带的备份和恢复工具，支持多种备份策略，包括完整数据库备份、增量备份和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值