Hello Jack
The RMAN command recover database;
is changed to be recover database until time '1999-03-05:11:33:00';
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tue, January 29, 2002 12:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Rman again. Long screen output included
>
>
>
> Hi ,
>
>
> I copied jay's line for duplication until time exactly into my test script
> but recovering errors out in the end.
>
> I looked in the documentation for another example of the until time clause
> but no luck. Can anybody explain why this won't work.
> (the double single quotes to which it translates looks fishy to me, but so
> does the whole RMAN thing at the moment)
>
> If I remove the until time clause it works fine.
>
> following is the screen output of my RMAN commands
>
>
> **************************************************************************
> **********************
> ep3[/data/oracle8/BACKUP]$ cat rmanClone.sh
> export ORACLE_SID=TEST3
> sqlplus /nolog <<EOF
> connect sys/rman_oracledba as sysdba
> shutdown abort
> startup nomount
> exit
> EOF
> rm /data/oracle8/TEST3/*
> rman <<EOF
> connect target rman/rman_oracledba@test2
> connect catalog rman/rman_oracledba@test1
> connect auxiliary sys/rman_oracledba@test3
> run {
> set until time "to_date('29012002094700','ddmmyyyyhh24miss')";
> allocate auxiliary channel d1 type disk;
> allocate auxiliary channel d2 type disk;
> duplicate target database to test3;
> }
> EOF
> ep3[/data/oracle8/BACKUP]$ rmanClone.sh
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jan 29 11:03:27 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> SQL> Connected.
> SQL> ORACLE instance shut down.
> SQL> ORACLE instance started.
>
> Total System Global Area 74919828 bytes
> Fixed Size 73620 bytes
> Variable Size 33808384 bytes
> Database Buffers 40960000 bytes
> Redo Buffers 77824 bytes
> SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 -
> Production
> With the Partitioning option
> JServer Release 8.1.7.2.0 - Production
>
> Recovery Manager: Release 8.1.7.2.0 - Production
>
> RMAN>
> RMAN-06005: connected to target database: TEST2 (DBID=536102344)
>
> RMAN>
> RMAN-06008: connected to recovery catalog database
>
> RMAN>
> RMAN-06020: connected to auxiliary database
>
> RMAN> 2> 3> 4> 5> 6>
> RMAN-03022: compiling command: set
>
> RMAN-03022: compiling command: allocate
> RMAN-03023: executing command: allocate
> RMAN-08030: allocated channel: d1
> RMAN-08500: channel d1: sid=11 devtype=DISK
>
> RMAN-03022: compiling command: allocate
> RMAN-03023: executing command: allocate
> RMAN-08030: allocated channel: d2
> RMAN-08500: channel d2: sid=12 devtype=DISK
>
> RMAN-03022: compiling command: Duplicate Db
>
> RMAN-03027: printing stored script: Memory Script
> {
> set until scn 95275;
> set newname for datafile 1 to
> "/data/oracle8/TEST3/systemTEST3.dbf";
> set newname for datafile 2 to
> "/data/oracle8/TEST3/rbsTEST3.dbf";
> set newname for datafile 3 to
> "/data/oracle8/TEST3/tempTEST3.dbf";
> set newname for datafile 4 to
> "/data/oracle8/TEST3/dataTEST3.dbf";
> restore
> check readonly
> clone database
> ;
> }
> RMAN-03021: executing script: Memory Script
>
> RMAN-03022: compiling command: set
>
> RMAN-03022: compiling command: set
>
> RMAN-03022: compiling command: set
>
> RMAN-03022: compiling command: set
>
> RMAN-03022: compiling command: set
>
> RMAN-03022: compiling command: restore
>
> RMAN-03022: compiling command: IRESTORE
> RMAN-03023: executing command: IRESTORE
> RMAN-08016: channel d1: starting datafile backupset restore
> RMAN-08502: set_count=42 set_stamp=452362933 creation_time=28-JAN-02
> RMAN-08089: channel d1: specifying datafile(s) to restore from backup set
> RMAN-08523: restoring datafile 00002 to /data/oracle8/TEST3/rbsTEST3.dbf
> RMAN-08523: restoring datafile 00004 to /data/oracle8/TEST3/dataTEST3.dbf
> RMAN-08016: channel d2: starting datafile backupset restore
> RMAN-08502: set_count=43 set_stamp=452362949 creation_time=28-JAN-02
> RMAN-08089: channel d2: specifying datafile(s) to restore from backup set
> RMAN-08523: restoring datafile 00003 to /data/oracle8/TEST3/tempTEST3.dbf
> RMAN-08023: channel d2: restored backup piece 1
> RMAN-08511: piece
> handle=/data/oracle8/BACKUP/rman_LVL0_TEST2.452362949.1.1.bus tag=null
> params=NULL
> RMAN-08024: channel d2: restore complete
> RMAN-08016: channel d2: starting datafile backupset restore
> RMAN-08502: set_count=44 set_stamp=452362964 creation_time=28-JAN-02
> RMAN-08089: channel d2: specifying datafile(s) to restore from backup set
> RMAN-08523: restoring datafile 00001 to
> /data/oracle8/TEST3/systemTEST3..dbf
> RMAN-08023: channel d1: restored backup piece 1
> RMAN-08511: piece
> handle=/data/oracle8/BACKUP/rman_LVL0_TEST2.452362933.1.1.bus tag=null
> params=NULL
> RMAN-08024: channel d1: restore complete
> RMAN-08023: channel d2: restored backup piece 1
> RMAN-08511: piece
> handle=/data/oracle8/BACKUP/rman_LVL0_TEST2.452362964.1.1.bus tag=null
> params=NULL
> RMAN-08024: channel d2: restore complete
> RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "test3"
> RESETLOGS ARCHIVELOG
> MAXLOGFILES 32
> MAXLOGMEMBERS 2
> MAXDATAFILES 30
> MAXINSTANCES 8
> MAXLOGHISTORY 907
> LOGFILE
> GROUP 1 ( '/data/oracle8/TEST3/redoTEST301.log' ) SIZE 512000
> REUSE,
> GROUP 2 ( '/data/oracle8/TEST3/redoTEST302.log' ) SIZE 512000
> REUSE,
> GROUP 3 ( '/data/oracle8/TEST3/redoTEST303.log' ) SIZE 512000
> REUSE
> DATAFILE
> '/data/oracle8/TEST3/systemTEST3.dbf'
> CHARACTER SET WE8ISO8859P1
>
>
> RMAN-03027: printing stored script: Memory Script
> {
> switch clone datafile all;
> }
> RMAN-03021: executing script: Memory Script
>
> RMAN-03022: compiling command: switch
> RMAN-03023: executing command: switch
> RMAN-08015: datafile 2 switched to datafile copy
> RMAN-08507: input datafilecopy recid=1 stamp=452430271
> filename=/data/oracle8/TEST3/rbsTEST3.dbf
> RMAN-08015: datafile 3 switched to datafile copy
> RMAN-08507: input datafilecopy recid=2 stamp=452430271
> filename=/data/oracle8/TEST3/tempTEST3.dbf
> RMAN-08015: datafile 4 switched to datafile copy
> RMAN-08507: input datafilecopy recid=3 stamp=452430271
> filename=/data/oracle8/TEST3/dataTEST3.dbf
>
> RMAN-03027: printing stored script: Memory Script
> {
> set until time 'to_date(''29012002094700'',''ddmmyyyyhh24miss'')';
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-00601: fatal error in recovery manager
> RMAN-03012: fatal error during compilation of command
> RMAN-03028: fatal error code: 600
> RMAN-03013: command type: Duplicate Db
> RMAN-00600: internal error, arguments [15120] [] [] [] []
> RMAN-01005: syntax error: found "single-quoted-string": expecting one of:
> ";"
> RMAN-01007: at line 2 column 30 file: Memory Script
>
>
> **************************************************************************
> ********END..
>
>
> TIA
>
>
> Jack
>
>
> ==================================================================
> De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
> vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
> derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
> Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
> volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
> voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
> verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
> worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden..
>
> Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
> vriendelijk doch dringend het e-mailbericht te retourneren aan de
> verzender
> en het origineel en eventuele kopieen te verwijderen en te vernietigen.
>
> Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
> voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
> algemene voorwaarden worden u op verzoek kosteloos toegezonden.
> =====================================================================
> The information contained in this communication is confidential and is
> intended solely for the use of the individual or entity to whom it is
> addressed. You should not copy, disclose or distribute this communication
> without the authority of Ernst & Young. Ernst & Young is neither liable
> for
> the proper and complete transmission of the information contained in this
> communication nor for any delay in its receipt. Ernst & Young does not
> guarantee that the integrity of this communication has been maintained nor
> that the communication is free of viruses, interceptions or interference.
>
> If you are not the intended recipient of this communication please return
> the communication to the sender and delete and destroy all copies.
>
> In carrying out its engagements, Ernst & Young applies general terms and
> conditions, which contain a clause that limits its liability. A copy of
> these terms and conditions is available on request free of charge.
> ===================================================================
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
