Created
January 9, 2012 15:05
-
-
Save dnaeon/1583310 to your computer and use it in GitHub Desktop.
RMAN #2
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| bash-3.2$ rman @/tmp/restore.rman | |
| Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jan 9 16:02:48 2012 | |
| Copyright (c) 1982, 2007, Oracle. All rights reserved. | |
| RMAN> connect target * | |
| 2> connect catalog * | |
| 3> | |
| 4> connect auxiliary * | |
| 5> run { | |
| 6> allocate auxiliary channel ch1 type disk; | |
| 7> allocate auxiliary channel ch2 type disk; | |
| 8> allocate auxiliary channel ch3 type disk; | |
| 9> duplicate target database to PINTAILA until sequence 51405 thread 1 nofilenamecheck; | |
| 10> } | |
| 11> | |
| connected to target database: PINTAIL (DBID=1577886170) | |
| connected to recovery catalog database | |
| connected to auxiliary database: PINTAILA (not mounted) | |
| starting full resync of recovery catalog | |
| full resync complete | |
| allocated channel: ch1 | |
| channel ch1: sid=540 devtype=DISK | |
| allocated channel: ch2 | |
| channel ch2: sid=539 devtype=DISK | |
| allocated channel: ch3 | |
| channel ch3: sid=538 devtype=DISK | |
| Starting Duplicate Db at 09-JAN-12 | |
| contents of Memory Script: | |
| { | |
| set until scn 1706537404; | |
| set newname for datafile 1 to | |
| "/opt/oracle/data/system01.dbf"; | |
| set newname for datafile 2 to | |
| "/opt/oracle/data/undotbs01.dbf"; | |
| set newname for datafile 3 to | |
| "/opt/oracle/data/sysaux01.dbf"; | |
| set newname for datafile 4 to | |
| "/opt/oracle/data/users01.dbf"; | |
| set newname for datafile 5 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA1.DBF"; | |
| set newname for datafile 6 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX1.DBF"; | |
| set newname for datafile 7 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_TEMP1.DBF"; | |
| set newname for datafile 8 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_BIGDATA1.DBF"; | |
| set newname for datafile 9 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DOC1.DBF"; | |
| set newname for datafile 10 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA2.DBF"; | |
| set newname for datafile 11 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA3.DBF"; | |
| set newname for datafile 12 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA4.DBF"; | |
| set newname for datafile 13 to | |
| "/opt/oracle/data/dataPINTAIL.TESTSCAPE_DATA5.DBF"; | |
| set newname for datafile 14 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX2.DBF"; | |
| set newname for datafile 15 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA6.DBF"; | |
| set newname for datafile 16 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA5.DBF"; | |
| set newname for datafile 17 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA7.DBF"; | |
| set newname for datafile 18 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA8.DBF"; | |
| set newname for datafile 19 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA9.DBF"; | |
| set newname for datafile 20 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX3.DBF"; | |
| set newname for datafile 21 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA10.DBF"; | |
| set newname for datafile 22 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA11.DBF"; | |
| set newname for datafile 23 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX4.DBF"; | |
| set newname for datafile 24 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA12.DBF"; | |
| set newname for datafile 25 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA13.DBF"; | |
| set newname for datafile 26 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA14.DBF"; | |
| set newname for datafile 27 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX5.DBF"; | |
| set newname for datafile 28 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA15.DBF"; | |
| set newname for datafile 29 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX6.DBF"; | |
| set newname for datafile 30 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA16.DBF"; | |
| set newname for datafile 31 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA17.DBF"; | |
| set newname for datafile 32 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX7.DBF"; | |
| set newname for datafile 33 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA19.DBF"; | |
| set newname for datafile 34 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_DATA18.DBF"; | |
| set newname for datafile 35 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX8.DBF"; | |
| set newname for datafile 36 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX9.DBF"; | |
| set newname for datafile 37 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX10.DBF"; | |
| set newname for datafile 38 to | |
| "/opt/oracle/data/PINTAIL.TESTSCAPE_IDX11.DBF"; | |
| restore | |
| check readonly | |
| clone database | |
| ; | |
| } | |
| executing Memory Script | |
| executing command: SET until clause | |
| 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 | |
| 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 09-JAN-12 | |
| released channel: ch1 | |
| released channel: ch2 | |
| released channel: ch3 | |
| RMAN-00571: =========================================================== | |
| RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== | |
| RMAN-00571: =========================================================== | |
| RMAN-03002: failure of Duplicate Db command at 01/09/2012 16:02:55 | |
| RMAN-03015: error occurred in stored script Memory Script | |
| RMAN-06026: some targets not found - aborting restore | |
| RMAN-06023: no backup or copy of datafile 38 found to restore | |
| RMAN-06023: no backup or copy of datafile 37 found to restore | |
| RMAN-06023: no backup or copy of datafile 36 found to restore | |
| RMAN-06023: no backup or copy of datafile 35 found to restore | |
| RMAN-06023: no backup or copy of datafile 34 found to restore | |
| RMAN-06023: no backup or copy of datafile 33 found to restore | |
| RMAN-06023: no backup or copy of datafile 32 found to restore | |
| RMAN-06023: no backup or copy of datafile 31 found to restore | |
| RMAN-06023: no backup or copy of datafile 30 found to restore | |
| RMAN-06023: no backup or copy of datafile 29 found to restore | |
| RMAN-06023: no backup or copy of datafile 28 found to restore | |
| RMAN-06023: no backup or copy of datafile 27 found to restore | |
| RMAN-06023: no backup or copy of datafile 26 found to restore | |
| RMAN-06023: no backup or copy of datafile 25 found to restore | |
| RMAN-06023: no backup or copy of datafile 24 found to restore | |
| RMAN-06023: no backup or copy of datafile 23 found to restore | |
| RMAN-06023: no backup or copy of datafile 22 found to restore | |
| RMAN-06023: no backup or copy of datafile 21 found to restore | |
| RMAN-06023: no backup or copy of datafile 20 found to restore | |
| RMAN-06023: no backup or copy of datafile 19 found to restore | |
| RMAN-06023: no backup or copy of datafile 18 found to restore | |
| RMAN-06023: no backup or copy of datafile 17 found to restore | |
| RMAN-06023: no backup or copy of datafile 16 found to restore | |
| RMAN-06023: no backup or copy of datafile 15 found to restore | |
| RMAN-06023: no backup or copy of datafile 14 found to restore | |
| RMAN-06023: no backup or copy of datafile 13 found to restore | |
| RMAN-06023: no backup or copy of datafile 12 found to restore | |
| RMAN-06023: no backup or copy of datafile 11 found to restore | |
| RMAN-06023: no backup or copy of datafile 10 found to restore | |
| RMAN-06023: no backup or copy of datafile 9 found to restore | |
| RMAN-06023: no backup or copy of datafile 8 found to restore | |
| RMAN-06023: no backup or copy of datafile 7 found to restore | |
| RMAN-06023: no backup or copy of datafile 6 found to restore | |
| RMAN-06023: no backup or copy of datafile 5 found to restore | |
| RMAN-06023: no backup or copy of datafile 4 found to restore | |
| RMAN-06023: no backup or copy of datafile 3 found to restore | |
| RMAN-06023: no backup or copy of datafile 2 found to restore | |
| RMAN-06023: no backup or copy of datafile 1 found to restore | |
| Recovery Manager complete. | |
| bash-3.2$ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment