RE: RMAN-NetBackup without an RMAN Catalog

From: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Tue, 12 Oct 2004 16:30:33 +0100
Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F6301C5CFDE@UKWMXM04>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hemant K Chitale Sent: Tuesday, October 12, 2004 4:10 PM
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 12 2004 - 10:26:36 CDT