subject:"RE\: Rman again. Long screen output included"

RE: Rman again. Long screen output included

2002-01-29 Thread nlzanen1




Hi,

That only works if the format mask is set correctly, ergo not very
flexible.


Jack




×××¨ ××××× <[EMAIL PROTECTED]>@fatcity.com on 29-01-2002 14:15:22

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Subject:  RE: Rman again. Long screen output included

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 < connect sys/rman_oracledba as sysdba
> shutdown abort
> startup nomount
> exit
> EOF
> rm /data/oracle8/TEST3/*
> rman < 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','ddmmhh24miss')";
> 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 Size73620 bytes
> Variable Size  33808384 bytes
> Database Buffers   4096 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

RE: Rman again. Long screen output included

2002-01-29 Thread nlzanen1




Hi Thomas,


AFAIK this is generated code (by RMAN) based on the command duplicate that
I issued. I sure didn't store any script yet. This is the next step when
all secrets of RMAN are uncovered (than it's time to move to RMAN 9i)


Jack




"Mercadante, Thomas F" <[EMAIL PROTECTED]> on 29-01-2002
14:19:30

To:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:

But where is it getting the other commands shown in the output?

Like the "set newfile for datafile 1 to" command?

Are you running scripts stored within the Rman catalog?  The message
'RMAN-03027-' states that this is a stored script.

Maybe a stored script is wrong?

Just a thought.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, January 29, 2002 8:13 AM
To: Mercadante, Thomas F




Hi,


In my test script (all I'm doing is trying to find out the do's & don'ts
of RMAN for the moment but examples are difficult to find and error
messages frequent) I put double quotes, but later (towards the end of the
screen output it shows  the line with double single quotes around the
format mask and date string (must be what it translates into internally)
and that is the only thing weird to me


Jack




"Mercadante, Thomas F" <[EMAIL PROTECTED]> on 29-01-2002
13:58:37

To:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>

Jack,

I don't think Rman wants "double single quotes", but double quotes around
the whole to_date clause.  At least that's what I use when performing
recovery.

Did I mis-read what you said?

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, January 29, 2002 5:15 AM
To: Multiple recipients of list ORACLE-L




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 < Connected.
SQL> ORACLE instance shut down.
SQL> ORACLE instance started.

Total System Global Area   74919828 bytes
Fixed Size73620 bytes
Variable Size  33808384 bytes
Database Buffers   4096 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 2 to /data/oracle8/TEST3/rbsTEST3.dbf
RMAN-08523: restoring datafile 4 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 3 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

RE: Rman again. Long screen output included

2002-01-29 Thread אדר יחיאל


Hello Jack

The RMAN commandrecover 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 < connect sys/rman_oracledba as sysdba
> shutdown abort
> startup nomount
> exit
> EOF
> rm /data/oracle8/TEST3/*
> rman < 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','ddmmhh24miss')";
> 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 Size73620 bytes
> Variable Size  33808384 bytes
> Database Buffers   4096 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 2 to /data/oracle8/TEST3/rbsTEST3.dbf
> RMAN-08523: restoring datafile 4 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 3 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 1 to
> /data/oracle8/TEST3/systemTEST3..dbf
> RMAN-08023: channel d1: restored backup piece 1
> RMAN-08511: piece
> handle=/data/oracle8/BACKUP/rman_LVL0_TES

RE: Rman again. Long screen output included

RE: Rman again. Long screen output included

RE: Rman again. Long screen output included

3 matches

Site Navigation

Mail list logo

Footer information