Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to tell RMAN to look at different location for ARCH_LOG backup piece.

Re: how to tell RMAN to look at different location for ARCH_LOG backup piece.

From: Joel Garry <joel-garry_at_home.com>
Date: 19 Jan 2006 11:16:38 -0800
Message-ID: <1137698198.887398.44810@o13g2000cwo.googlegroups.com>


You mean,
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/rmanreco.htm#436862 ?

run {

     allocate channel ch1 type disk;

# Set a new location for logs 1 through 10.
set archivelog destination to '/disk1/oracle/temp_restore'; restore archivelog from logseq 1 until logseq 10;
# Set a new location for logs 11 through 20.
set archivelog destination to '/disk1/oracle/arch'; restore archivelog from logseq 11 until logseq 20;
# Set a new location for logs 21 through 30.
set archivelog destination to '/disk2/oracle/temp_restore'; restore archivelog from logseq 21 until logseq 30; . . . recover database;

}

jg

--
@home.com is bogus.
"What is a wazoo and how much do you have to have before something
starts coming out of it?" - Paul Baumberger
Received on Thu Jan 19 2006 - 13:16:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US