-
Restoring A Database From A Previous Installation
Hello Everyone,
I need help. I need to restore a previous RMAN backup set to a new engine/DB I created. I would think that there will be no RMAN catalog for the old backup.
What do I need to do to restore the backup into my new engine.
Thank you and best regards,
Randy
-
Hello Everyone,
Reference to my earlier posting, I managed to get the backup script used. It is as follows:
BACKUP
AS COMPRESSED BACKUPSET
INCREMENTAL LEVEL 0
DATABASE TAG "BackupBaseline"
PLUS ARCHIVELOG
DELETE INPUT;
And the log is as follows:
Starting backup at 13-MAY-07
using channel ORA_DISK_1
specification does not match any archive log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 13-MAY-07
Starting Control File and SPFILE Autobackup at 13-MAY-07
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_13\O1_MF_S_622432820_34F GG2PG_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 13-MAY-07
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 91 29-APR-07
Backup Piece 91 29-APR-07 D:\ORACLE\BACKUP\ORA_DF621136860_S93_S1
Backup Set 92 29-APR-07
Backup Piece 92 29-APR-07 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_04_29\O1_MF_S_621136819_338K2DPG_. BKP
Backup Set 93 30-APR-07
Backup Piece 93 30-APR-07 D:\ORACLE\BACKUP\ORA_DF621223240_S95_S1
Backup Set 94 30-APR-07
Backup Piece 94 30-APR-07 D:\ORACLE\BACKUP\ORA_DF621223249_S96_S1
Backup Set 95 30-APR-07
Backup Piece 95 30-APR-07 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_04_30\O1_MF_S_621223220_33C56KM1_. BKP
Backup Set 96 01-MAY-07
Backup Piece 96 01-MAY-07 D:\ORACLE\BACKUP\ORA_DF621396040_S98_S1
Backup Set 97 01-MAY-07
Backup Piece 97 01-MAY-07 D:\ORACLE\BACKUP\ORA_DF621396057_S99_S1
Backup Set 98 01-MAY-07
Backup Piece 98 01-MAY-07 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_01\O1_MF_S_621396020_33FSLSQG_. BKP
Backup Set 99 02-MAY-07
Backup Piece 99 02-MAY-07 D:\ORACLE\BACKUP\ORA_DF621482442_S101_S1
Backup Set 100 02-MAY-07
Backup Piece 100 02-MAY-07 D:\ORACLE\BACKUP\ORA_DF621482459_S102_S1
Backup Set 101 02-MAY-07
Backup Piece 101 02-MAY-07 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_02\O1_MF_S_621482422_33JFYW6C_. BKP
Backup Set 102 03-MAY-07
Backup Piece 102 03-MAY-07 D:\ORACLE\BACKUP\ORA_DF621568841_S104_S1
Backup Set 103 03-MAY-07
Backup Piece 103 03-MAY-07 D:\ORACLE\BACKUP\ORA_DF621568859_S105_S1
Backup Set 104 03-MAY-07
Backup Piece 104 03-MAY-07 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_03\O1_MF_S_621568821_33M2BVNZ_. BKP
Backup Set 105 04-MAY-07
Backup Piece 105 04-MAY-07 D:\ORACLE\BACKUP\ORA_DF621655240_S107_S1
Backup Set 106 04-MAY-07
Backup Piece 106 04-MAY-07 D:\ORACLE\BACKUP\ORA_DF621655258_S108_S1
Backup Set 107 04-MAY-07
Backup Piece 107 04-MAY-07 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_04\O1_MF_S_621655220_33OPPT98_. BKP
Backup Set 108 05-MAY-07
Backup Piece 108 05-MAY-07 D:\ORACLE\BACKUP\ORA_DF621741640_S110_S1
Backup Set 109 05-MAY-07
Backup Piece 109 05-MAY-07 D:\ORACLE\BACKUP\ORA_DF621741668_S111_S1
Backup Set 110 05-MAY-07
Backup Piece 110 05-MAY-07 E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_05\O1_MF_S_621741620_33RC357T_. BKP
Backup Set 111 06-MAY-07
Backup Piece 111 06-MAY-07 D:\ORACLE\BACKUP\ORA_DF621828041_S113_S1
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621136860_S93_S1 recid=91 stamp=621136860
deleted backup piece
backup piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_04_29\O1_MF_S_621136819_338 K2DPG_.BKP recid=92 stamp=621137276
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621223240_S95_S1 recid=93 stamp=621223240
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621223249_S96_S1 recid=94 stamp=621223249
deleted backup piece
backup piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_04_30\O1_MF_S_621223220_33C 56KM1_.BKP recid=95 stamp=621223425
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621396040_S98_S1 recid=96 stamp=621396040
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621396057_S99_S1 recid=97 stamp=621396057
deleted backup piece
backup piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_01\O1_MF_S_621396020_33F SLSQG_.BKP recid=98 stamp=621396233
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621482442_S101_S1 recid=99 stamp=621482443
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621482459_S102_S1 recid=100 stamp=621482460
deleted backup piece
backup piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_02\O1_MF_S_621482422_33J FYW6C_.BKP recid=101 stamp=621482636
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621568841_S104_S1 recid=102 stamp=621568842
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621568859_S105_S1 recid=103 stamp=621568859
deleted backup piece
backup piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_03\O1_MF_S_621568821_33M 2BVNZ_.BKP recid=104 stamp=621569035
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621655240_S107_S1 recid=105 stamp=621655241
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621655258_S108_S1 recid=106 stamp=621655258
deleted backup piece
backup piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_04\O1_MF_S_621655220_33O PPT98_.BKP recid=107 stamp=621655434
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621741640_S110_S1 recid=108 stamp=621741641
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621741668_S111_S1 recid=109 stamp=621741669
deleted backup piece
backup piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\GPSD\AUTOBACKUP\2007_05_05\O1_MF_S_621741620_33R C357T_.BKP recid=110 stamp=621741845
deleted backup piece
backup piece handle=D:\ORACLE\BACKUP\ORA_DF621828041_S113_S1 recid=111 stamp=621828042
Deleted 21 objects
database opened
Recovery Manager complete.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|