RE: RMAN-NetBackup without an RMAN Catalog
- From: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 12 Oct 2004 16:30:33 +0100
The following worked for me, to answer your restore question
I am sure there are better methods=20
John
export NSR_SERVER=3Dxxxxx NSR_CLIENT=3Dyyyyyyyyy NSR_POOL=3Dzzzzzzzzz
RMAN>
@rec.sql
restore controlfile first
rec.sql
run
{
sql "alter session set nls_date_format=3D''YYYY-MM-DD:HH24:MI:SS''";
set until time =3D '2004-09-24:11:30:00';
allocate channel ch_a type 'SBT_TAPE' format "%d_arch_%s_%p_%t" parms =
'ENV=3D(NSR_CLIENT=3Dxxxxxx)';
allocate channel ch_b type 'SBT_TAPE' format "%d_arch_%s_%p_%t" =
parms 'ENV=3D(NSR_CLIENT=3Dxxxxxxx)' ;
restore controlfile to '/tmp/controlfile_01.ctl';
}
move controlfile to proper loaction and replicate the multiple copies
RMAN>
@rec1.sql
run
{
sql "alter session set nls_date_format=3D''YYYY-MM-DD:HH24:MI:SS''";
set until time =3D '2004-09-24:11:30:00';
allocate channel ch_a type 'SBT_TAPE' format "%d_arch_%s_%p_%t" parms =
'ENV=3D(NSR_CLIENT=3Dxxxxxx)';
allocate channel ch_b type 'SBT_TAPE' format "%d_arch_%s_%p_%t" =
parms 'ENV=3D(NSR_CLIENT=3Dxxxxxxx)' ;
restore database ;
}
RMAN>
@rec2.sql
run {
allocate channel ch_a type 'SBT_TAPE' parms =
'ENV=3D(NSR_CLIENT=3Dxxxxxx)';
allocate channel ch_b type 'SBT_TAPE' parms =
'ENV=3D(NSR_CLIENT=3Dxxxxxx)';
restore archivelog from logseq 1358 until logseq 1399 thread 1 ;
}
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hemant K Chitale
Sent: Tuesday, October 12, 2004 4:10 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RMAN-NetBackup without an RMAN Catalog
When using RMAN and Netbackup without a RMAN Catalog database,
how do you set retention for 5 years -- eg if the controlfile is =
backed-up
as autobackup.
How do you restore a database as of a specific day [e.g. 3 months ago] ?
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
=20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
