ADSM-L
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

Re: [ADSM-L] JR- RMAN

2008-08-12 15:11:30
Subject: Re: [ADSM-L] JR- RMAN
From: Jiangxi Wazi <jiangxiwazi AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 12 Aug 2008 15:09:54 -0400 
JR,

Did you add auxiliary database: RESTORE1 infomation into tnsnames.ora and
listenner.ora file?

Are you able to use sqlplus to "startup nomount" RESTORE1?

Jiangxi wazi

On 8/7/08, JR Trimark <j.r.trimark AT aurora DOT org> wrote:
>
> We are backing up our Oracle 10G database using TSM TDP and LAN Free 5.5.1
> clients via a TSM 5.5. server.
> We are getting the following error upon restore.
> Any ideas?
> ***********log file results **************
>
> Recovery Manager: Release 10.2.0.3.0 - Production on Thu Aug 7 20:45:25
> 2008
>
> Copyright (c) 1982, 2005, Oracle.  All rights reserved.
>
> connected to target database: CERT (DBID=2144641495)
> connected to recovery catalog database
> connected to auxiliary database: RESTORE1 (not mounted)
>
> RMAN>
> new RMAN configuration parameters:
> CONFIGURE AUXILIARY CHANNEL DEVICE TYPE 'SBT_TAPE' MAXOPENFILES 24 PARMS
>
> 'BLKSIZE=1048576,ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'
> FORMAT   'CERT_rman_%d_%t_%U.bck';
> new RMAN configuration parameters are successfully stored
> starting full resync of recovery catalog
> full resync complete
>
> RMAN>
> RMAN configuration parameters are:
> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
> CONFIGURE BACKUP OPTIMIZATION ON;
> CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
> CONFIGURE CONTROLFILE AUTOBACKUP ON;
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F';
> # default
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; #
> default
> CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 9 BACKUP TYPE TO BACKUPSET;
> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; #
> default
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; #
> default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXOPENFILES 24 PARMS
>
> 'BLKSIZE=524288,ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'
> FORMAT   'CERT_rman_%d_%t_%U.bck';
> CONFIGURE AUXILIARY CHANNEL DEVICE TYPE 'SBT_TAPE' MAXOPENFILES 24 PARMS
>
> 'BLKSIZE=1048576,ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'
> FORMAT   'CERT_rman_%d_%t_%U.bck';
> CONFIGURE MAXSETSIZE TO UNLIMITED; # default
> CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
> CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
> CONFIGURE SNAPSHOT CONTROLFILE NAME TO
> '/u01/oracle/product/10.2.0.3/db/dbs/snapcf_cert1.f'; # default
>
> RMAN> 2> 3> 4>
> Starting Duplicate Db at 07-AUG-08
> allocated channel: ORA_AUX_SBT_TAPE_1
> channel ORA_AUX_SBT_TAPE_1: sid=1310 devtype=SBT_TAPE
> channel ORA_AUX_SBT_TAPE_1: Data Protection for Oracle: version 5.5.1.0
> allocated channel: ORA_AUX_SBT_TAPE_2
> channel ORA_AUX_SBT_TAPE_2: sid=1309 devtype=SBT_TAPE
> channel ORA_AUX_SBT_TAPE_2: Data Protection for Oracle: version 5.5.1.0
> allocated channel: ORA_AUX_SBT_TAPE_3
> channel ORA_AUX_SBT_TAPE_3: sid=1304 devtype=SBT_TAPE
> channel ORA_AUX_SBT_TAPE_3: Data Protection for Oracle: version 5.5.1.0
> allocated channel: ORA_AUX_SBT_TAPE_4
> channel ORA_AUX_SBT_TAPE_4: sid=1306 devtype=SBT_TAPE
> channel ORA_AUX_SBT_TAPE_4: Data Protection for Oracle: version 5.5.1.0
> allocated channel: ORA_AUX_SBT_TAPE_5
> channel ORA_AUX_SBT_TAPE_5: sid=1312 devtype=SBT_TAPE
> channel ORA_AUX_SBT_TAPE_5: Data Protection for Oracle: version 5.5.1.0
> allocated channel: ORA_AUX_SBT_TAPE_6
> channel ORA_AUX_SBT_TAPE_6: sid=1303 devtype=SBT_TAPE
> channel ORA_AUX_SBT_TAPE_6: Data Protection for Oracle: version 5.5.1.0
> allocated channel: ORA_AUX_SBT_TAPE_7
> channel ORA_AUX_SBT_TAPE_7: sid=1305 devtype=SBT_TAPE
> channel ORA_AUX_SBT_TAPE_7: Data Protection for Oracle: version 5.5.1.0
> allocated channel: ORA_AUX_SBT_TAPE_8
> channel ORA_AUX_SBT_TAPE_8: sid=1307 devtype=SBT_TAPE
> channel ORA_AUX_SBT_TAPE_8: Data Protection for Oracle: version 5.5.1.0
> allocated channel: ORA_AUX_SBT_TAPE_9
> channel ORA_AUX_SBT_TAPE_9: sid=1300 devtype=SBT_TAPE
> channel ORA_AUX_SBT_TAPE_9: Data Protection for Oracle: version 5.5.1.0
> allocated channel: ORA_AUX_DISK_1
> channel ORA_AUX_DISK_1: sid=1301 devtype=DISK
>
> contents of Memory Script:
> {
>   set newname for datafile  1 to
> "/dev/rcert_systm_001";
>   set newname for datafile  2 to
> "/dev/rcert_undo1_001";
>   set newname for datafile  3 to
> "/dev/rcert_syaux_001";
>   set newname for datafile  4 to
> "/dev/rcert_misc_001";
>   set newname for datafile  5 to
> "/dev/rdcert_00000001";
>   set newname for datafile  6 to
> "/dev/rdcert_00000002";
>   set newname for datafile  7 to
> "/dev/rdcert_00000003";
>   set newname for datafile  8 to
> "/dev/rdcert_00000004";
>   set newname for datafile  9 to
> "/dev/rdcert_00000005";
>   set newname for datafile  10 to
> "/dev/rdcert_00000006";
>   set newname for datafile  11 to
> "/dev/rdcert_00000007";
>   set newname for datafile  12 to
> "/dev/rdcert_00000008";
>   set newname for datafile  13 to
> "/dev/rdcert_00000009";
>   set newname for datafile  14 to
> "/dev/rdcert_00000010";
>   set newname for datafile  15 to
> "/dev/rdcert_00000011";
>   set newname for datafile  16 to
> "/dev/rdcert_00000012";
>   set newname for datafile  17 to
> "/dev/rdcert_00000013";
>   set newname for datafile  18 to
> "/dev/rdcert_00000014";
>   set newname for datafile  19 to
> "/dev/rdcert_00000015";
>   set newname for datafile  20 to
> "/dev/rdcert_00000016";
>   set newname for datafile  21 to
> "/dev/rdcert_00000017";
>   set newname for datafile  22 to
> "/dev/rdcert_00000018";
>   set newname for datafile  23 to
> "/dev/rdcert_00000019";
>   set newname for datafile  24 to
> "/dev/rdcert_00000020";
>   restore
>   check readonly
>   clone database
>   ;
> }
> executing Memory Script
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
> executing command: SET NEWNAME
>
>
> Starting restore at 07-AUG-08
> using channel ORA_AUX_SBT_TAPE_1
> using channel ORA_AUX_SBT_TAPE_2
> using channel ORA_AUX_SBT_TAPE_3
> using channel ORA_AUX_SBT_TAPE_4
> using channel ORA_AUX_SBT_TAPE_5
> using channel ORA_AUX_SBT_TAPE_6
> using channel ORA_AUX_SBT_TAPE_7
> using channel ORA_AUX_SBT_TAPE_8
> using channel ORA_AUX_SBT_TAPE_9
> using channel ORA_AUX_DISK_1
>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of Duplicate Db command at 08/07/2008 20:46:26
> RMAN-03015: error occurred in stored script Memory Script
> RMAN-06136: ORACLE error from auxiliary database: ORA-03114: not connected
> to ORACLE
>
> RMAN>
>
> Recovery Manager complete.
>
> ***********log file results **************
>
>
>
> Thanks in advance
> JR
>
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: [ADSM-L] LTO4 encryption in an I2000?, Strand, Neil B.
Next by Date:  [ADSM-L] DSMC return codes broken in 5.4?, Norrgard
Previous by Thread:  [ADSM-L] JR- RMAN, JR Trimark
Next by Thread:  [ADSM-L] DB2 Restore / Rollforward, Herrmann, Boris
Indexes:  [Date] [Thread] [Top] [All Lists]