TS - Rman restore control file backup info with Catalog

最新推荐文章于 2021-04-02 21:54:54 发布
最新推荐文章于 2021-04-02 21:54:54 发布
阅读量114 收藏
点赞数
文章标签： 数据库
1 DB env

Basic:
-----------------------------------------
OS: Linux
DB: 10.2.0.5.5  RAC (4 nodes)
DB Name: jzywk
-----------------------------------------

Backup Backgroud:
--------------------------------------------------
NFS Server:          backup
Full Backup FS:    1 /nfsbackup
                                2  /backds5100nfs

DB Script. Backup Node:  jzywk2 
--------------------------------------------------

2  Problem

Rman backup file exists in full backup file system /nfsbackup  but backup info disappear in controlfile  after running backup scripts to another full backup file system /backds5100nfs

3 Toubleshooting

--1) Backup file in Backup file system  /nfsbackup

[root@backup ~]# df -h|grep nfsbackup
                       24T   17T  6.5T  72% /nfsbackup
[root@backup ~]# ls -lth /nfsbackup
total 17T
-rw-r----- 1 110 110  37G Dec  2 02:06 jzywk_arch_20121202_800935065_sdnrqj4p_1_1
-rw-r----- 1 110 110  38G Dec  2 01:58 jzywk_arch_20121202_800934365_sbnrqiet_1_1
-rw-r----- 1 110 110  37G Dec  2 01:57 jzywk_arch_20121202_800934365_scnrqiet_1_1
-rw-r----- 1 110 110 195G Dec  2 01:45 jzywk_full_20121202_800911363_s8nrps03_4_1
-rw-r----- 1 110 110  96K Dec  2 01:28 jzywk_full_20121202_800933318_sanrqhe6_1_1
-rw-r----- 1 110 110  28M Dec  2 01:28 jzywk_full_20121202_800933316_s9nrqhe4_1_1
-rw-r----- 1 110 110 173G Dec  2 01:28 jzywk_full_20121202_800910496_s7nrpr50_4_1
-rw-r----- 1 110 110 500G Dec  2 01:00 jzywk_full_20121201_800911363_s8nrps03_3_1
-rw-r----- 1 110 110 500G Dec  2 00:44 jzywk_full_20121201_800910496_s7nrpr50_3_1
-rw-r----- 1 110 110 500G Dec  1 23:15 jzywk_full_20121201_800911363_s8nrps03_2_1
-rw-r----- 1 110 110 500G Dec  1 22:57 jzywk_full_20121201_800910496_s7nrpr50_2_1
-rw-r----- 1 110 110 500G Dec  1 21:36 jzywk_full_20121201_800911363_s8nrps03_1_1
-rw-r----- 1 110 110 500G Dec  1 21:19 jzywk_full_20121201_800910496_s7nrpr50_1_1
-rw-r----- 1 110 110 199G Dec  1 19:22 jzywk_full_20121201_800887703_s6nrp4sn_4_1
-rw-r----- 1 110 110 186G Dec  1 19:08 jzywk_full_20121201_800886856_s5nrp428_4_1
-rw-r----- 1 110 110 500G Dec  1 18:26 jzywk_full_20121201_800887703_s6nrp4sn_3_1
-rw-r----- 1 110 110 500G Dec  1 18:15 jzywk_full_20121201_800886856_s5nrp428_3_1
-rw-r----- 1 110 110 500G Dec  1 16:34 jzywk_full_20121201_800887703_s6nrp4sn_2_1
-rw-r----- 1 110 110 500G Dec  1 16:15 jzywk_full_20121201_800886856_s5nrp428_2_1
-rw-r----- 1 110 110 500G Dec  1 14:48 jzywk_full_20121201_800887703_s6nrp4sn_1_1
-rw-r----- 1 110 110 500G Dec  1 14:34 jzywk_full_20121201_800886856_s5nrp428_1_1
-rw-r----- 1 110 110 194G Dec  1 12:48 jzywk_full_20121201_800863723_s4nrodfb_4_1
-rw-r----- 1 110 110 166G Dec  1 12:34 jzywk_full_20121201_800863507_s3nrod8j_4_1
-rw-r----- 1 110 110 500G Dec  1 11:53 jzywk_full_20121201_800863723_s4nrodfb_3_1
-rw-r----- 1 110 110 500G Dec  1 11:49 jzywk_full_20121201_800863507_s3nrod8j_3_1
-rw-r----- 1 110 110 500G Dec  1 10:08 jzywk_full_20121201_800863723_s4nrodfb_2_1
-rw-r----- 1 110 110 500G Dec  1 10:01 jzywk_full_20121201_800863507_s3nrod8j_2_1
-rw-r----- 1 110 110 500G Dec  1 08:12 jzywk_full_20121201_800863723_s4nrodfb_1_1
-rw-r----- 1 110 110 500G Dec  1 08:08 jzywk_full_20121201_800863507_s3nrod8j_1_1
-rw-r----- 1 110 110 199G Dec  1 06:08 jzywk_full_20121201_800745611_s2nrkq4b_4_1
-rw-r----- 1 110 110 215G Dec  1 06:05 jzywk_full_20121201_800744915_s1nrkpej_4_1
-rw-r----- 1 110 110 500G Dec  1 05:10 jzywk_full_20121201_800745611_s2nrkq4b_3_1
-rw-r----- 1 110 110 500G Dec  1 05:03 jzywk_full_20121201_800744915_s1nrkpej_3_1
-rw-r----- 1 110 110 500G Dec  1 03:05 jzywk_full_20121201_800745611_s2nrkq4b_2_1
-rw-r----- 1 110 110 500G Dec  1 02:49 jzywk_full_20121201_800744915_s1nrkpej_2_1
-rw-r----- 1 110 110 500G Dec  1 00:51 jzywk_full_20121130_800745611_s2nrkq4b_1_1
-rw-r----- 1 110 110 500G Dec  1 00:18 jzywk_full_20121130_800744915_s1nrkpej_1_1
-rw-r----- 1 110 110 191G Nov 30 21:20 jzywk_full_20121130_800722863_s0nrk3tf_4_1
-rw-r----- 1 110 110 159G Nov 30 21:08 jzywk_full_20121130_800722862_rvnrk3te_4_1
-rw-r----- 1 110 110 500G Nov 30 20:35 jzywk_full_20121130_800722862_rvnrk3te_3_1
-rw-r----- 1 110 110 500G Nov 30 20:34 jzywk_full_20121130_800722863_s0nrk3tf_3_1
-rw-r----- 1 110 110 500G Nov 30 18:47 jzywk_full_20121130_800722862_rvnrk3te_2_1
-rw-r----- 1 110 110 500G Nov 30 18:46 jzywk_full_20121130_800722863_s0nrk3tf_2_1
-rw-r----- 1 110 110 500G Nov 30 16:55 jzywk_full_20121130_800722862_rvnrk3te_1_1
-rw-r----- 1 110 110 500G Nov 30 16:54 jzywk_full_20121130_800722863_s0nrk3tf_1_1

--2)  Backup info not exist in DB control file

[oracle@jzyw-r2 ~]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Fri Dec 7 13:46:31 2012

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

connected to target database: JZYWK (DBID=3843034140)

RMAN> list backup summary;

using target database control file instead of recovery catalog

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
709     B  A  A DISK        05-DEC-12       1       1       NO         TAG20121205T210017
710     B  A  A DISK        05-DEC-12       1       1       NO         TAG20121205T210017
711     B  A  A DISK        05-DEC-12       1       1       NO         TAG20121205T210017
712     B  A  A DISK        05-DEC-12       1       1       NO         TAG20121205T210017
713     B  A  A DISK        06-DEC-12       1       1       NO         TAG20121206T210018
714     B  A  A DISK        06-DEC-12       1       1       NO         TAG20121206T210018
715     B  A  A DISK        06-DEC-12       1       1       NO         TAG20121206T210018

RMAN> exit


Recovery Manager complete.


--3) Full backup scripts

#!/bin/bash

if [ -f $HOME/.bash_profile ];
then
     . $HOME/.bash_profile
fi

export ORACLE_USER=/u01/home/oracle
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/database

export ORACLE_SID=jzywk2

export PATH=$ORACLE_HOME/bin:$PATH

DATE=`date +%Y%m%d`
DBNAME=jzywk
BAKDIR=$1


<
crosscheck backup;
delete noprompt expired backup;

run {
allocate channel t1 type disk maxpiecesize=500g;
allocate channel t2 type disk maxpiecesize=500g;
sql 'alter system archive log current';
backup incremental level 0 format "${BAKDIR}/${DBNAME}_full_%T_%t_%U"
database include current controlfile;
sql 'alter system archive log current';
backup format "${BAKDIR}/${DBNAME}_arch_%T_%t_%U" archivelog all;
report obsolete;
release channel t1;
release channel t2;
}
EOF

--4) Cause:  Rman crosscheck  miss backup info due to  /nfsbackup FORGET to mount on DB server Before running backup to another file system /backds5100nfs

[root@jzyw-r2 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3              29G  5.9G   22G  22% /
/dev/sda5              66G   20G   43G  32% /u01
/dev/sda1              99M   12M   82M  13% /boot
tmpfs                  63G     0   63G   0% /dev/shm
10.148.65.70:/backds5100nfs
                       22T  201G   22T   1% /backds5100nfs
10.148.65.70:/ds5100bakinc
                      4.0T  277G  3.7T   7% /ds5100bakinc
[root@jzyw-r2 ~]# df -h |grep /nfsbackup

No return


--5) DB Server remount  backup file system /nfsbackup

[oracle@jzyw-r2 ~]$ su - root
Password:
[root@jzyw-r2 ~]# mount -t nfs -o wsize=32768,rsize=32768 10.148.65.xx:/nfsbackup /nfsbackup
[root@jzyw-r2 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda3              29G  5.9G   22G  22% /
/dev/sda5              66G   20G   43G  32% /u01
/dev/sda1              99M   12M   82M  13% /boot
tmpfs                  63G     0   63G   0% /dev/shm
10.148.65.xx:/backds5100nfs
                       22T   78G   22T   1% /backds5100nfs
10.148.65.xx:/ds5100bakinc
                      4.0T  277G  3.7T   7% /ds5100bakinc
10.148.65.xx:/nfsbackup
                       24T   17T  6.5T  72% /nfsbackup


--6) Use catalog rman command to restore backup info to control file

[oracle@jzyw-r2 ~]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Fri Dec 7 13:48:40 2012

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

connected to target database: JZYWK (DBID=3843034140)

RMAN> crosscheck backup
2> ;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=6041 instance=jzywk2 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ds5100bakinc/jzywk_arhc_20121205_801262827_sfns4j7b_1_1 recid=1400 stamp=801262829
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ds5100bakinc/jzywk_arhc_20121205_801262827_sens4j7b_1_1 recid=1401 stamp=801262828
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ds5100bakinc/jzywk_arhc_20121205_801264277_shns4kkl_1_1 recid=1402 stamp=801264280
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ds5100bakinc/jzywk_arhc_20121205_801264250_sgns4kjq_1_1 recid=1403 stamp=801264278
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ds5100bakinc/jzywk_arhc_20121206_801349222_sjns77j6_1_1 recid=1404 stamp=801349224
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ds5100bakinc/jzywk_arhc_20121206_801350177_skns78h1_1_1 recid=1405 stamp=801350178
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ds5100bakinc/jzywk_arhc_20121206_801349222_sins77j6_1_1 recid=1406 stamp=801349223
Crosschecked 7 objects


RMAN> catalog start with '/nfsbackup';

searching for all files that match the pattern /nfsbackup
no files found to be unknown to the database

RMAN> catalog start with '/nfsbackup/jzywk';

searching for all files that match the pattern /nfsbackup/jzywk

List of Files Unknown to the Database
=====================================
File Name: /nfsbackup/jzywk_full_20121130_800722862_rvnrk3te_1_1
File Name: /nfsbackup/jzywk_full_20121130_800722863_s0nrk3tf_1_1
File Name: /nfsbackup/jzywk_full_20121130_800722863_s0nrk3tf_2_1
File Name: /nfsbackup/jzywk_full_20121130_800722862_rvnrk3te_2_1
File Name: /nfsbackup/jzywk_full_20121130_800722863_s0nrk3tf_3_1
File Name: /nfsbackup/jzywk_full_20121130_800722862_rvnrk3te_3_1
File Name: /nfsbackup/jzywk_full_20121130_800722863_s0nrk3tf_4_1
File Name: /nfsbackup/jzywk_full_20121130_800722862_rvnrk3te_4_1
File Name: /nfsbackup/jzywk_full_20121130_800744915_s1nrkpej_1_1
File Name: /nfsbackup/jzywk_full_20121130_800745611_s2nrkq4b_1_1
File Name: /nfsbackup/jzywk_full_20121201_800744915_s1nrkpej_2_1
File Name: /nfsbackup/jzywk_full_20121201_800745611_s2nrkq4b_2_1
File Name: /nfsbackup/jzywk_full_20121201_800744915_s1nrkpej_3_1
File Name: /nfsbackup/jzywk_full_20121201_800745611_s2nrkq4b_3_1
File Name: /nfsbackup/jzywk_full_20121201_800744915_s1nrkpej_4_1
File Name: /nfsbackup/jzywk_full_20121201_800745611_s2nrkq4b_4_1
File Name: /nfsbackup/jzywk_full_20121201_800863507_s3nrod8j_1_1
File Name: /nfsbackup/jzywk_full_20121201_800863723_s4nrodfb_1_1
File Name: /nfsbackup/jzywk_full_20121201_800863507_s3nrod8j_2_1
File Name: /nfsbackup/jzywk_full_20121201_800863723_s4nrodfb_2_1
File Name: /nfsbackup/jzywk_full_20121201_800863507_s3nrod8j_3_1
File Name: /nfsbackup/jzywk_full_20121201_800863723_s4nrodfb_3_1
File Name: /nfsbackup/jzywk_full_20121201_800863507_s3nrod8j_4_1
File Name: /nfsbackup/jzywk_full_20121201_800863723_s4nrodfb_4_1
File Name: /nfsbackup/jzywk_full_20121201_800886856_s5nrp428_1_1
File Name: /nfsbackup/jzywk_full_20121201_800887703_s6nrp4sn_1_1
File Name: /nfsbackup/jzywk_full_20121201_800886856_s5nrp428_2_1
File Name: /nfsbackup/jzywk_full_20121201_800887703_s6nrp4sn_2_1
File Name: /nfsbackup/jzywk_full_20121201_800886856_s5nrp428_3_1
File Name: /nfsbackup/jzywk_full_20121201_800887703_s6nrp4sn_3_1
File Name: /nfsbackup/jzywk_full_20121201_800886856_s5nrp428_4_1
File Name: /nfsbackup/jzywk_full_20121201_800887703_s6nrp4sn_4_1
File Name: /nfsbackup/jzywk_full_20121201_800910496_s7nrpr50_1_1
File Name: /nfsbackup/jzywk_full_20121201_800911363_s8nrps03_1_1
File Name: /nfsbackup/jzywk_full_20121201_800910496_s7nrpr50_2_1
File Name: /nfsbackup/jzywk_full_20121201_800911363_s8nrps03_2_1
File Name: /nfsbackup/jzywk_full_20121201_800910496_s7nrpr50_3_1
File Name: /nfsbackup/jzywk_full_20121201_800911363_s8nrps03_3_1
File Name: /nfsbackup/jzywk_full_20121202_800910496_s7nrpr50_4_1
File Name: /nfsbackup/jzywk_full_20121202_800911363_s8nrps03_4_1
File Name: /nfsbackup/jzywk_full_20121202_800933316_s9nrqhe4_1_1
File Name: /nfsbackup/jzywk_full_20121202_800933318_sanrqhe6_1_1
File Name: /nfsbackup/jzywk_arch_20121202_800934365_sbnrqiet_1_1
File Name: /nfsbackup/jzywk_arch_20121202_800934365_scnrqiet_1_1
File Name: /nfsbackup/jzywk_arch_20121202_800935065_sdnrqj4p_1_1

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /nfsbackup/jzywk_full_20121130_800722862_rvnrk3te_1_1
File Name: /nfsbackup/jzywk_full_20121130_800722863_s0nrk3tf_1_1
File Name: /nfsbackup/jzywk_full_20121130_800722863_s0nrk3tf_2_1
File Name: /nfsbackup/jzywk_full_20121130_800722862_rvnrk3te_2_1
File Name: /nfsbackup/jzywk_full_20121130_800722863_s0nrk3tf_3_1
File Name: /nfsbackup/jzywk_full_20121130_800722862_rvnrk3te_3_1
File Name: /nfsbackup/jzywk_full_20121130_800722863_s0nrk3tf_4_1
File Name: /nfsbackup/jzywk_full_20121130_800722862_rvnrk3te_4_1
File Name: /nfsbackup/jzywk_full_20121130_800744915_s1nrkpej_1_1
File Name: /nfsbackup/jzywk_full_20121130_800745611_s2nrkq4b_1_1
File Name: /nfsbackup/jzywk_full_20121201_800744915_s1nrkpej_2_1
File Name: /nfsbackup/jzywk_full_20121201_800745611_s2nrkq4b_2_1
File Name: /nfsbackup/jzywk_full_20121201_800744915_s1nrkpej_3_1
File Name: /nfsbackup/jzywk_full_20121201_800745611_s2nrkq4b_3_1
File Name: /nfsbackup/jzywk_full_20121201_800744915_s1nrkpej_4_1
File Name: /nfsbackup/jzywk_full_20121201_800745611_s2nrkq4b_4_1
File Name: /nfsbackup/jzywk_full_20121201_800863507_s3nrod8j_1_1
File Name: /nfsbackup/jzywk_full_20121201_800863723_s4nrodfb_1_1
File Name: /nfsbackup/jzywk_full_20121201_800863507_s3nrod8j_2_1
File Name: /nfsbackup/jzywk_full_20121201_800863723_s4nrodfb_2_1
File Name: /nfsbackup/jzywk_full_20121201_800863507_s3nrod8j_3_1
File Name: /nfsbackup/jzywk_full_20121201_800863723_s4nrodfb_3_1
File Name: /nfsbackup/jzywk_full_20121201_800863507_s3nrod8j_4_1
File Name: /nfsbackup/jzywk_full_20121201_800863723_s4nrodfb_4_1
File Name: /nfsbackup/jzywk_full_20121201_800886856_s5nrp428_1_1
File Name: /nfsbackup/jzywk_full_20121201_800887703_s6nrp4sn_1_1
File Name: /nfsbackup/jzywk_full_20121201_800886856_s5nrp428_2_1
File Name: /nfsbackup/jzywk_full_20121201_800887703_s6nrp4sn_2_1
File Name: /nfsbackup/jzywk_full_20121201_800886856_s5nrp428_3_1
File Name: /nfsbackup/jzywk_full_20121201_800887703_s6nrp4sn_3_1
File Name: /nfsbackup/jzywk_full_20121201_800886856_s5nrp428_4_1
File Name: /nfsbackup/jzywk_full_20121201_800887703_s6nrp4sn_4_1
File Name: /nfsbackup/jzywk_full_20121201_800910496_s7nrpr50_1_1
File Name: /nfsbackup/jzywk_full_20121201_800911363_s8nrps03_1_1
File Name: /nfsbackup/jzywk_full_20121201_800910496_s7nrpr50_2_1
File Name: /nfsbackup/jzywk_full_20121201_800911363_s8nrps03_2_1
File Name: /nfsbackup/jzywk_full_20121201_800910496_s7nrpr50_3_1
File Name: /nfsbackup/jzywk_full_20121201_800911363_s8nrps03_3_1
File Name: /nfsbackup/jzywk_full_20121202_800910496_s7nrpr50_4_1
File Name: /nfsbackup/jzywk_full_20121202_800911363_s8nrps03_4_1
File Name: /nfsbackup/jzywk_full_20121202_800933316_s9nrqhe4_1_1
File Name: /nfsbackup/jzywk_full_20121202_800933318_sanrqhe6_1_1
File Name: /nfsbackup/jzywk_arch_20121202_800934365_sbnrqiet_1_1
File Name: /nfsbackup/jzywk_arch_20121202_800934365_scnrqiet_1_1
File Name: /nfsbackup/jzywk_arch_20121202_800935065_sdnrqj4p_1_1


4 Verify

RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
694     B  0  A DISK        30-NOV-12       4       1       NO         TAG20121130T150100
695     B  0  A DISK        30-NOV-12       4       1       NO         TAG20121130T150100
696     B  0  A DISK        01-DEC-12       4       1       NO         TAG20121130T150100
697     B  0  A DISK        01-DEC-12       4       1       NO         TAG20121130T150100
698     B  0  A DISK        01-DEC-12       4       1       NO         TAG20121130T150100
699     B  0  A DISK        01-DEC-12       4       1       NO         TAG20121130T150100
700     B  0  A DISK        01-DEC-12       4       1       NO         TAG20121130T150100
701     B  0  A DISK        01-DEC-12       4       1       NO         TAG20121130T150100
702     B  0  A DISK        02-DEC-12       4       1       NO         TAG20121130T150100
703     B  0  A DISK        02-DEC-12       1       1       NO         TAG20121130T150100
704     B  0  A DISK        02-DEC-12       1       1       NO         TAG20121130T150100
705     B  0  A DISK        02-DEC-12       4       1       NO         TAG20121130T150100
706     B  A  A DISK        02-DEC-12       1       1       NO         TAG20121202T014601
707     B  A  A DISK        02-DEC-12       1       1       NO         TAG20121202T014601
708     B  A  A DISK        02-DEC-12       1       1       NO         TAG20121202T014601
709     B  A  A DISK        05-DEC-12       1       1       NO         TAG20121205T210017
710     B  A  A DISK        05-DEC-12       1       1       NO         TAG20121205T210017
711     B  A  A DISK        05-DEC-12       1       1       NO         TAG20121205T210017
712     B  A  A DISK        05-DEC-12       1       1       NO         TAG20121205T210017
713     B  A  A DISK        06-DEC-12       1       1       NO         TAG20121206T210018
714     B  A  A DISK        06-DEC-12       1       1       NO         TAG20121206T210018
715     B  A  A DISK        06-DEC-12       1       1       NO         TAG20121206T210018

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27064837/viewspace-750753/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27064837/viewspace-750753/

cuixu4254
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle catalog start with,catalog start with报错，求解
weixin_36078737的博客
04-10 833
RMAN> catalog start with '/archive1/';using target database control file instead of recovery catalogsearching for all files that match the pattern /archive1/List of Files Unknown to the Database===...
oracle rman权限不足,rman恢复过程中遇到问题的总结
weixin_42358733的博客
04-10 724
rman对于新手来说是一个难题，然而对我来说同样如此。因此在这里我把我使用rman过程中遇到的问题进行总结以及给出解决的方法。希望给那些同样和我一样的菜了一些宝贵的经验。1、首先就是关于备份后的备份集存放位置的问题错误背景：对于全备份来说当在机器A上面进行备份后如果在机器B上进行恢复的时候。备份集存放在B机器什么目录下这个问题困扰了我这个菜了。现在我在这里肯定的告诉大家，放在哪个目录都行，只要恢复...
catalog with无法识别所有的备份copy
liuzhilong的博客
06-07 1627
在dg搭建的时候，经常会有路径不一致的问题 restore完成后数据文件在新的目录，但是controlfile从主库来的，不知道新目录在哪，所以需要catalog with让rman去发现备份文件或copy 我start with '+data'后，switch datafile to copy无法转换 RMAN> list copy; specification does not match any archive log in the recovery catalog List of.
RMAN catalog和switch参数解读
fanzhuozhuo的博客
11-23 1299
RMAN catalog和switch参数解读backup as copy概念catalogcatalog datafilecopy注意点catalog start with注意点：catalog backuppiececatalog archivelog总结SWITCH 以前一直用backuppiece即备份集的方式，因为backup默认不加参数就为backuppiece。今天客户需要使用datafilecopy，没想到翻车了，对此形式的备份恢复不是很熟悉，特此做以实验测试。 backup as copy
rac迁移到单实例实验
dcwnb1的专栏
04-09 661
从RAC数据库恢复到单实例的数据库，需要DBA做的工作还是有一些的---我是指除了常规恢复操作之外。  环境如下 服务端：192.168.75.11(12) 目标端：192.168.75.130，机器名standby  目标端已安装好数据库软件，并升级至与源端相同的版本，参数配置合理并且磁盘空间充足，源端创建的备份集也已复制至目标端。  别的就不废话了，接下来小跑进入实战演练部分
Oracle 12c备份恢复-RMAN工具技术手册
12-27
Oracle 12c 备份恢复-RMAN 工具技术手册 本文档旨在提供 Oracle 12c 备份恢复的技术手册，主要介绍 RMAN 工具的概念、架构、备份类型和使用方法。 一、RMAN 概念 RMAN（Recovery Manager）是 Oracle 推荐的备份和...
Oracle-RMAN增量备份恢复测试记录.docx
11-16
Oracle-RMAN增量备份恢复测试记录 Oracle-RMAN增量备份恢复测试记录是对Oracle数据库进行增量备份和恢复的测试记录，旨在记录增量备份和恢复的过程、命令和结果。下面是该测试记录的详细说明和知识点： 1. 概述： ...
Oracle-RMAN快速入门指南.doc
11-21
* 建立复原名目表空间和用户：需要创建一个名为 rman_ts 的表空间和一个名为 rman 的用户，并授予该用户相应的权限 * 配置并启动 OEM 有关服务：需要配置并启动 OracleOraHome81ManagementServer 以及 OracleOraHome...
MetaLink-RMAN RAC Backup and Recovery using RMAN
03-17
MetaLink-RMAN RAC Backup and Recovery using RMAN 希望对ORACLE使用者有点作用
Oracle-Rman备份详细讲解
07-19
1. **恢复数据文件**：使用`RESTORE DATAFILE`命令恢复特定数据文件。 2. **恢复控制文件**：在控制文件损坏的情况下，使用`RESTORE CONTROLFILE`命令。 3. **恢复表空间**：通过`RESTORE TABLESPACE`恢复整个表空间...
[20140627]rman下catalog的使用.txt
06-27 154
[20140627]rman下catalog的使用.txt 前几天有人问rman的catalog的使用问题,主要是后面的/.自己做一些记录: --我建立一个目录testtes # ls -l | grep testtes ...
ORACLE11G RMAN备份恢复到异机数据库
技术成就梦想
08-17 6407
orapwd file='/u01/app/oracle/product/11.2.0.4/db_1/dbs/orapwprb' password=oracle entries=10 force=y backup format '/u01/prb/rmanbk/fulldb_%d_%U' database include current controlfile plus archivelog d
oracle11g异机备份,ORACLE11G RMAN备份恢复到异机数据库
weixin_33746819的博客
04-02 401
2016-08-17 17:28 1594人阅读 评论(0) 收藏 举报 分类： Oracle备份与恢复(19) 版权声明：本文为博主原创文章，未经博主允许不得转载。1. 源数据库环境操作系统版本:Centos6.7x64数据库版本:Oracle11.2.0.4x64数据库名: prb数据库SID :prbdb_unique_name : prbinstance_name : p...
RMAN异机恢复步骤及故障处理
aaron8219's Oracle&Linux Technology Blog
10-12 5739
一、测试机安装OS+Oracle Software，包括配置oracle用户组和环境变量（略） 二、开始异机恢复 1. 复制源库最新备份集、初始化参数、密码文件到测试机 [oracle@ora10g backupsets]$ scp *20141012* 192.168.1.213:/tmp The authenticity of host '192.168.1.213
RMAN单机恢复
hayata的专栏
03-09 916
场景介绍：         单机oracle11R2(11.2.0.4)版本，模拟在全备份以后，用户sec添加一张表(说明：新建表记录不在全备中)，归档2次， 使记录(用户sec新建表的记录)保存到归档文件中，然后删除控制文件|数据文件，模拟回复数据库。在模拟过程中，也模 拟了重新注册备份集的过程(把备份集换存放里面，达到与全备控制文件中记录备份集不一致的效果)。 在最后我
System Error Codes
热门推荐
snail8384的专栏
08-13 8万+
From: http://msdn.microsoft.com/en-us/library/windows/desktop/ms681382%28v=vs.85%29.aspx Applies to: desktop apps only Note   The information on this page is intended to be used by programm
postgresql 物理备份 pg_rman 之二 backup
一名数据库爱好者的专栏
12-03 715
os: centos 7.4 postgresql: 9.6.9 pg_rman: REL9_6_STABLE pg_rman 备份有全量备份和增量备份，没错，pg_rman 实现了增量备份。 备份的目录通过 init 时指定一个路径，一般来说，会首先备份在本地的某个路径下，然后再通过 scp 或者 rsync 传输到异机上。 $ pg_rman --help pg_rman manage bac...
rman restore datafile 命令
最新发布
05-30
rman restore datafile 命令用于在Oracle数据库中恢复一个数据文件。该命令的语法如下： ``` RESTORE DATAFILE '<datafile_path>' [FROM TAG '<backup_tag>' | UNTIL TIME '<recovery_time>']; ``` 其中，`<data...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值