Catalog archivelog from file system to Asmdg;

yyp2009發表於2015-07-17
原文網址 : http://blog.itpub.net/13750068/viewspace-1736532/
HiveASM
[root@sscp-db2 arch2]# scp 2_9204_844882031.dbf  root@135.149.48.95:/u01
The authenticity of host '135.149.48.95 (135.149.48.95)' can't be established.
RSA key fingerprint is b2:c4:b7:54:46:05:dd:d5:e5:bf:b0:66:b7:12:06:7f.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '135.149.48.95' (RSA) to the list of known hosts.
root@135.149.48.95's password: 
2_9204_844882031.dbf                                                                                                           0% 5520KB   2.7MB/s   05:10 ETA
2_9204_844882031.dbf                                                                                                         100%  844MB   5.6MB/s   02:30    
[root@sscp-db2 arch2]# 

[root@sscp-db2 u01]# chown oracle.asmadmin *.dbf
[root@sscp-db2 u01]# ls -l
total 862644
-rw-r-----  1 oracle asmadmin 883316736 Jul 17 16:37 1_8696_844882031.dbf
drwxr-xr-x  6 root   oinstall      4096 Jun 29 16:37 app
drwxrwxr-x. 2 grid   oinstall     16384 May 31 10:40 lost+found
drwxrwxr-x  8 grid   oinstall      4096 Jul  7 00:15 soft

[oracle@sscp-db2 ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 17 17:02:08 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SSCPDB (DBID=233800172, not open)

RMAN>  catalog archivelog '/u01/1_8696_844882031.dbf';

using target database control file instead of recovery catalog
cataloged archived log
archived log file name=/u01/1_8696_844882031.dbf RECID=17955 STAMP=885315775

RMAN> copy archivelog  '/u01/1_8696_844882031.dbf'      to '+arch/SSCPDB/archivelog/2015_07_17/1_8696_844882031.dbf';

Starting backup at 17-JUL-2015 17:05:00
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5 instance=sscpdb2 device type=DISK
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=8696 RECID=17955 STAMP=885315775
output file name=+ARCH/sscpdb/archivelog/2015_07_17/1_8696_844882031.dbf RECID=17956 STAMP=885315906
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:07
Finished backup at 17-JUL-2015 17:05:10
RMAN-06497: WARNING: control file is not current, control file AUTOBACKUP skipped

RMAN> catalog archivelog  '+arch/SSCPDB/archivelog/2015_07_17/1_8696_844882031.dbf';

cataloged archived log
archived log file name=+ARCH/sscpdb/archivelog/2015_07_17/1_8696_844882031.dbf RECID=17957 STAMP=885315960

目標異機recover完成：

RMAN> run {
2> allocate channel c0 type 'sbt_tape';
3> allocate channel c1 type 'sbt_tape';
4> send 'NB_ORA_SERV=vnbumaster,NB_ORA_CLIENT=sscp-db2';
5> set until time "TO_DATE('07/17/15 00:03','MM/DD/YY hh24:mi')";
6> recover database;
7> release channel ch00;
8> release channel ch01;
9> }

allocated channel: c0
channel c0: SID=853 instance=sscpdb2 device type=SBT_TAPE
channel c0: Veritas NetBackup for Oracle - Release 7.6 (2014042414)

allocated channel: c1
channel c1: SID=1142 instance=sscpdb2 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 7.6 (2014042414)

sent command to channel: c0
sent command to channel: c1
executing command: SET until clause
Starting recover at 17-JUL-2015 17:16:45
starting media recovery

archived log for thread 1 with sequence 8696 is already on disk as file +ARCH/sscpdb/archivelog/2015_07_17/1_8696_844882031.dbf
archived log for thread 2 with sequence 9204 is already on disk as file +ARCH/sscpdb/archivelog/2015_07_17/2_9204_844882031.dbf
archived log file name=+ARCH/sscpdb/archivelog/2015_07_17/2_9204_844882031.dbf thread=2 sequence=9204
archived log file name=+ARCH/sscpdb/archivelog/2015_07_17/1_8696_844882031.dbf thread=1 sequence=8696
media recovery complete, elapsed time: 00:00:01
Finished recover at 17-JUL-2015 17:16:49


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/13750068/viewspace-1736532/，如需轉載，請註明出處，否則將追究法律責任。

相關文章