Error in Restore [message #286972] |
Mon, 10 December 2007 14:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
emind
Messages: 49 Registered: April 2007 Location: Islamabad
|
Member |
|
|
i am using Standalone enterprise manager 10g R2 for backup the database using control file.
I didn't change any thing in RMAN configuration.
This is the script which i am using for backup.
#################################################################
connected to target database: PROD (DBID=32940950)
using target database control file instead of recovery catalog
Starting backup at 10-DEC-07
backup device type disk tag 'BACKUP_PROD_000025_121007050646' da
echo set on
set command id to 'BACKUP_PROD_000025_121007050646';
executing command: SET COMMAND ID
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: sid=217 devtype=DISK
allocated channel: ORA_DISK_1
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current control file in backupset
input datafile fno=00012 name=H:\ORACLE\PRODDATA\UNDO01.DBF
input datafile fno=00019 name=H:\ORACLE\PRODDATA\A_REF01.DBF
input datafile fno=00020 name=H:\ORACLE\PRODDATA\A_REF02.DBF
input datafile fno=00024 name=H:\ORACLE\PRODDATA\A_TXN_DATA03.DBF
input datafile fno=00026 name=H:\ORACLE\PRODDATA\A_TXN_IND02.DBF
input datafile fno=00015 name=H:\ORACLE\PRODDATA\A_MEDIA01.DBF
input datafile fno=00001 name=H:\ORACLE\PRODDATA\SYSTEM01.DBF
input datafile fno=00002 name=H:\ORACLE\PRODDATA\SYSTEM02.DBF
input datafile fno=00003 name=H:\ORACLE\PRODDATA\SYSTEM03.DBF
input datafile fno=00004 name=H:\ORACLE\PRODDATA\SYSTEM04.DBF
input datafile fno=00005 name=H:\ORACLE\PRODDATA\SYSTEM05.DBF
input datafile fno=00010 name=H:\ORACLE\PRODDATA\SYSTEM10.DBF
input datafile fno=00011 name=H:\ORACLE\PRODDATA\SYSTEM11.DBF
input datafile fno=00021 name=H:\ORACLE\PRODDATA\A_SUMM01.DBF
input datafile fno=00022 name=H:\ORACLE\PRODDATA\A_TXN_DATA01.DBF
input datafile fno=00023 name=H:\ORACLE\PRODDATA\A_TXN_DATA02.DBF
input datafile fno=00025 name=H:\ORACLE\PRODDATA\A_TXN_IND01.DBF
input datafile fno=00027 name=H:\ORACLE\PRODDATA\A_TXN_IND03.DBF
input datafile fno=00028 name=H:\ORACLE\PRODDATA\A_TXN_IND04.DBF
input datafile fno=00014 name=H:\ORACLE\PRODDATA\A_INT01.DBF
input datafile fno=00029 name=H:\ORACLE\PRODDATA\A_TXN_IND05.DBF
input datafile fno=00006 name=H:\ORACLE\PRODDATA\SYSTEM06.DBF
input datafile fno=00007 name=H:\ORACLE\PRODDATA\SYSTEM07.DBF
input datafile fno=00008 name=H:\ORACLE\PRODDATA\SYSTEM08.DBF
input datafile fno=00009 name=H:\ORACLE\PRODDATA\SYSTEM09.DBF
input datafile fno=00013 name=H:\ORACLE\PRODDATA\A_ARCHIVE01.DBF
input datafile fno=00017 name=H:\ORACLE\PRODDATA\A_QUEUE01.DBF
input datafile fno=00018 name=H:\ORACLE\PRODDATA\A_QUEUE02.DBF
input datafile fno=00035 name=H:\ORACLE\PRODDATA\SYSAUX01.DBF
input datafile fno=00031 name=H:\ORACLE\PRODDATA\ODM.DBF
input datafile fno=00032 name=H:\ORACLE\PRODDATA\OLAP.DBF
input datafile fno=00034 name=H:\ORACLE\PRODDATA\PORTAL01.DBF
input datafile fno=00016 name=H:\ORACLE\PRODDATA\A_NOLOG01.DBF
input datafile fno=00030 name=H:\ORACLE\PRODDATA\CTXD01.DBF
input datafile fno=00033 name=H:\ORACLE\PRODDATA\OWAD01.DBF
channel ORA_DISK_1: starting piece 1 at 10-DEC-07
channel ORA_DISK_1: finished piece 1 at 10-DEC-07
piece handle=F:\ORACLE\ORADB\DATABASE\07J391TU_1_1 tag=BACKUP_PROD_000025_121007050646 comment=NONE
current log archived
Starting backup at 10-DEC-07
backup device type disk tag 'BACKUP_PROD_000025_121007050646' ar
channel ORA_DISK_1: backup set complete, elapsed time: 00:06:27
Finished backup at 10-DEC-07
skipping archive log file F:\ORADB_ARCHIVE\ARC08218_0621102616.001; already backed on 10-DEC-07
skipping archive log file F:\ORADB_ARCHIVE\ARC08217_0621102616.001; already backed on 10-DEC-07
skipping archive log file F:\ORADB_ARCHIVE\ARC08216_0621102616.001; already backed on 10-DEC-07
using channel ORA_DISK_1
skipping archive log file F:\ORADB_ARCHIVE\ARC08219_0621102616.001; already backed on 10-DEC-07
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: starting piece 1 at 10-DEC-07
input archive log thread=1 sequence=8222 recid=3700 stamp=640977217
input archive log thread=1 sequence=8221 recid=3699 stamp=640976084
input archive log thread=1 sequence=8220 recid=3698 stamp=640972856
channel ORA_DISK_1: specifying archive log(s) in backup set
channel ORA_DISK_1: finished piece 1 at 10-DEC-07
piece handle=F:\ORACLE\ORADB\DATABASE\08J392A2_1_1 tag=BACKUP_PROD_000025_121007050646 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 10-DEC-07
exit;
#############################################################
in Restore i am doing this.
SQL> Startup mount
RMAN> restore controlfile PATH 'f:\oracle' ;
REsotre successfully.
RMAN > alter database mount;
Database mounted.
************************************************************
now when i start to restore the Database it's show me that error that backup file is not exit while Backup file exit and it's show me the backup file name of Previous BACKUPSET not that backup set which i want to restore.
WHY?
|
|
|
|
|
|
|
Re: Error in Restore [message #287080 is a reply to message #287024] |
Tue, 11 December 2007 01:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
emind
Messages: 49 Registered: April 2007 Location: Islamabad
|
Member |
|
|
F:\oracle\oradb>rman target \
Recovery Manager: Release 10.2.0.3.0 - Production on Tue Dec 11 11:07:06 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
target database Password:
connected to target database: PROD (DBID=32940950)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
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 'F:\ORACLE\ORADB\DATABASE\SNCFPROD.ORA';
# default
This is the parameters of Source Database.
|
|
|
|
Re: Error in Restore [message #287090 is a reply to message #287080] |
Tue, 11 December 2007 01:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
emind
Messages: 49 Registered: April 2007 Location: Islamabad
|
Member |
|
|
This i run on Target system.
F:\oracle\oradb>rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Dec 10 17:00:57 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PROD (not mounted)
RMAN> restore controlfile from 'F:\oracle\oradb\database\SNCFPROD.ORA';
Starting restore at 10-DEC-07
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=386 devtype=DISK
channel ORA_DISK_1: copied control file copy
output filename=F:\ORACLE\PRODDATA\CNTRL01.DBF
output filename=F:\ORACLE\PRODDATA\CNTRL02.DBF
output filename=F:\ORACLE\PRODDATA\CNTRL03.DBF
Finished restore at 10-DEC-07
RMAN> list backup;
released channel: ORA_DISK_1
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 16.07G DISK 00:06:25 10-DEC-07
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: BACKUP_PROD_000022_121007022051
Piece Name: F:\ORACLE\ORADB\DATABASE\04J38O6N_1_1
Control File Included: Ckp SCN: 910250408 Ckp time: 10-DEC-07
SPFILE Included: Modification time: 09-DEC-07
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM01.DBF
2 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM02.DBF
3 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM03.DBF
4 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM04.DBF
5 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM05.DBF
6 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM06.DBF
7 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM07.DBF
8 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM08.DBF
9 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM09.DBF
10 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM10.DBF
11 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSTEM11.DBF
12 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\UNDO01.DBF
13 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_ARCHIVE01.DBF
14 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_INT01.DBF
15 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_MEDIA01.DBF
16 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_NOLOG01.DBF
17 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_QUEUE01.DBF
18 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_QUEUE02.DBF
19 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_REF01.DBF
20 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_REF02.DBF
21 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_SUMM01.DBF
22 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_TXN_DATA01.DBF
23 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_TXN_DATA02.DBF
24 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_TXN_DATA03.DBF
25 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_TXN_IND01.DBF
26 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_TXN_IND02.DBF
27 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_TXN_IND03.DBF
28 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_TXN_IND04.DBF
29 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\A_TXN_IND05.DBF
30 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\CTXD01.DBF
31 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\ODM.DBF
32 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\OLAP.DBF
33 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\OWAD01.DBF
34 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\PORTAL01.DBF
35 Full 910250419 10-DEC-07 H:\ORACLE\PRODDATA\SYSAUX01.DBF
You can see it's showing the backup Piece Name: F:\ORACLE\ORADB\DATABASE\04J38O6N_1_1
While i am not using this backup Piece i am uisng 05J38QIA_1_1
|
|
|
|
Re: Error in Restore [message #287099 is a reply to message #287092] |
Tue, 11 December 2007 01:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
emind
Messages: 49 Registered: April 2007 Location: Islamabad
|
Member |
|
|
This 05J38QIA_1_1 backup set Peice i am using i Don't have F:\ORACLE\ORADB\DATABASE\04J38O6N_1_1.
that why i am asking that when i start restore it's start searching for the old backup set not the current 1.
May be due to configure controlfile autobackup Off; ?
|
|
|
Re: Error in Restore [message #287104 is a reply to message #287099] |
Tue, 11 December 2007 01:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
emind
Messages: 49 Registered: April 2007 Location: Islamabad
|
Member |
|
|
Hi Michel,
I will be convenient for me that if you send me that what parameter i have to configure before start a backup and what backup commands for Full database including control file and Archive logs.
and Restore commands on new system.
|
|
|
|
Re: Error in Restore [message #287133 is a reply to message #287112] |
Tue, 11 December 2007 03:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
emind
Messages: 49 Registered: April 2007 Location: Islamabad
|
Member |
|
|
configure snapshot controlfile name to 'f:\bk_rman\snapcf_emcc.ctl';
configure controlfile autobackup on;
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
sql "alter system switch logfile";
sql "alter system archive log current";
backup maxsetsize=8096128K format 'f:\bk_rman\df_%d_%T_%s_%p'
database include current controlfile;
sql "alter system switch logfile";
sql "alter system archive log current";
backup maxsetsize=2096128K format 'f:\bk_rman\al_%d_%T_%s_%p'
archivelog all;
# archivelog all delete input;
release channel d2;
backup format 'f:\bk_rman\cf_%d_%T_%s_%p' current controlfile;
release channel d1;
}
This is the script which i customize as per my enviourment.
but for restore u didn't mention the restore for Control file so it's should be automatic?
|
|
|
Re: Error in Restore [message #287137 is a reply to message #287133] |
Tue, 11 December 2007 03:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1/ You only restore the control file if it is lost (I should say it THEY are lost as you MUST have 2 or 3 control files)
2/ I mention "restore controlfile from autobackup;" but this is just an example
Regards
Michel
[Updated on: Tue, 11 December 2007 03:21] Report message to a moderator
|
|
|
Re: Error in Restore [message #287154 is a reply to message #287137] |
Tue, 11 December 2007 03:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
emind
Messages: 49 Registered: April 2007 Location: Islamabad
|
Member |
|
|
ok i restore the control file on Target system with These commands can u check it's ok?
i didn't set any path for The database restore.
RMAN>restore control file from 'f:\bk_rman\snapcf_emcc.ctl' ;
RMAN>Alter database mount;
RMAN>Run
{
set newname for datafile 'H:\oracle\proddata\system01.dbf' to 'f:\oracle\proddata\system01.dbf';
restore datafile 'H:\oracle\proddata\system01.dbf';
set newname for datafile 'H:\oracle\proddata\system02.dbf' to 'f:\oracle\proddata\system02.dbf';
restore datafile 'H:\oracle\proddata\system02.dbf';
set newname for datafile 'H:\oracle\proddata\system03.dbf' to 'f:\oracle\proddata\system03.dbf';
restore datafile 'H:\oracle\proddata\system03.dbf';
set newname for datafile 'H:\oracle\proddata\system04.dbf' to 'f:\oracle\proddata\system04.dbf';
restore datafile 'H:\oracle\proddata\system04.dbf';
set newname for datafile 'H:\oracle\proddata\system05.dbf' to 'f:\oracle\proddata\system05.dbf';
restore datafile 'H:\oracle\proddata\system05.dbf';
set newname for datafile 'H:\oracle\proddata\system06.dbf' to 'f:\oracle\proddata\system06.dbf';
restore datafile 'H:\oracle\proddata\system06.dbf';
set newname for datafile 'H:\oracle\proddata\system07.dbf' to 'f:\oracle\proddata\system07.dbf';
restore datafile 'H:\oracle\proddata\system07.dbf';
set newname for datafile 'H:\oracle\proddata\system08.dbf' to 'f:\oracle\proddata\system08.dbf';
restore datafile 'H:\oracle\proddata\system08.dbf';
set newname for datafile 'H:\oracle\proddata\system09.dbf' to 'f:\oracle\proddata\system09.dbf';
restore datafile 'H:\oracle\proddata\system09.dbf';
set newname for datafile 'H:\oracle\proddata\system10.dbf' to 'f:\oracle\proddata\system10.dbf';
restore datafile 'H:\oracle\proddata\system10.dbf';
set newname for datafile 'H:\oracle\proddata\system11.dbf' to 'f:\oracle\proddata\system11.dbf';
restore datafile 'H:\oracle\proddata\system11.dbf';
set newname for datafile 'H:\oracle\proddata\undo01.dbf' to 'f:\oracle\proddata\undo01.dbf';
restore datafile 'H:\oracle\proddata\undo01.dbf';
set newname for datafile 'H:\oracle\proddata\a_archive01.dbf' to 'f:\oracle\proddata\a_archive01.dbf';
restore datafile 'H:\oracle\proddata\a_archive01.dbf';
set newname for datafile 'H:\oracle\proddata\a_int01.dbf' to 'f:\oracle\proddata\a_int01.dbf';
restore datafile 'H:\oracle\proddata\a_int01.dbf';
set newname for datafile 'H:\oracle\proddata\a_media01.dbf' to 'f:\oracle\proddata\a_media01.dbf';
restore datafile 'H:\oracle\proddata\a_media01.dbf';
set newname for datafile 'H:\oracle\proddata\a_nolog01.dbf' to 'f:\oracle\proddata\a_nolog01.dbf';
restore datafile 'H:\oracle\proddata\a_nolog01.dbf';
set newname for datafile 'H:\oracle\proddata\a_queue01.dbf' to 'f:\oracle\proddata\a_queue01.dbf';
restore datafile 'H:\oracle\proddata\a_queue01.dbf';
set newname for datafile 'H:\oracle\proddata\a_queue02.dbf' to 'f:\oracle\proddata\a_queue02.dbf';
restore datafile 'H:\oracle\proddata\a_queue02.dbf';
set newname for datafile 'H:\oracle\proddata\a_ref01.dbf' to 'f:\oracle\proddata\a_ref01.dbf';
restore datafile 'H:\oracle\proddata\a_ref01.dbf';
set newname for datafile 'H:\oracle\proddata\a_ref02.dbf' to 'f:\oracle\proddata\a_ref02.dbf';
restore datafile 'H:\oracle\proddata\a_ref02.dbf';
set newname for datafile 'H:\oracle\proddata\a_summ01.dbf' to 'f:\oracle\proddata\a_summ01.dbf';
restore datafile 'H:\oracle\proddata\a_summ01.dbf';
set newname for datafile 'H:\oracle\proddata\a_txn_data01.dbf' to 'f:\oracle\proddata\a_txn_data01.dbf';
restore datafile 'H:\oracle\proddata\a_txn_data01.dbf';
set newname for datafile 'H:\oracle\proddata\a_txn_data02.dbf' to 'f:\oracle\proddata\a_txn_data02.dbf';
restore datafile 'H:\oracle\proddata\a_txn_data02.dbf';
set newname for datafile 'H:\oracle\proddata\a_txn_data03.dbf' to 'f:\oracle\proddata\a_txn_data03.dbf';
restore datafile 'H:\oracle\proddata\a_txn_data03.dbf';
set newname for datafile 'H:\oracle\proddata\a_txn_ind01.dbf' to 'f:\oracle\proddata\a_txn_ind01.dbf';
restore datafile 'H:\oracle\proddata\a_txn_ind01.dbf';
set newname for datafile 'H:\oracle\proddata\a_txn_ind02.dbf' to 'f:\oracle\proddata\a_txn_ind02.dbf';
restore datafile 'H:\oracle\proddata\a_txn_ind02.dbf';
set newname for datafile 'H:\oracle\proddata\a_txn_ind03.dbf' to 'f:\oracle\proddata\a_txn_ind03.dbf';
restore datafile 'H:\oracle\proddata\a_txn_ind03.dbf';
set newname for datafile 'H:\oracle\proddata\a_txn_ind04.dbf' to 'f:\oracle\proddata\a_txn_ind04.dbf';
restore datafile 'H:\oracle\proddata\a_txn_ind04.dbf';
set newname for datafile 'H:\oracle\proddata\a_txn_ind05.dbf' to 'f:\oracle\proddata\a_txn_ind05.dbf';
restore datafile 'H:\oracle\proddata\a_txn_ind05.dbf';
set newname for datafile 'H:\oracle\proddata\ctxd01.dbf' to 'f:\oracle\proddata\ctxd01.dbf';
restore datafile 'H:\oracle\proddata\ctxd01.dbf';
set newname for datafile 'H:\oracle\proddata\odm.dbf' to 'f:\oracle\proddata\odm.dbf';
restore datafile 'H:\oracle\proddata\odm.dbf';
set newname for datafile 'H:\oracle\proddata\olap.dbf' to 'f:\oracle\proddata\olap.dbf';
restore datafile 'H:\oracle\proddata\olap.dbf';
set newname for datafile 'H:\oracle\proddata\owad01.dbf' to 'f:\oracle\proddata\owad01.dbf';
restore datafile 'H:\oracle\proddata\owad01.dbf';
set newname for datafile 'H:\oracle\proddata\portal01.dbf' to 'f:\oracle\proddata\portal01.dbf';
restore datafile 'H:\oracle\proddata\portal01.dbf';
set newname for datafile 'H:\oracle\proddata\SYSAUX01.DBF' to 'f:\oracle\proddata\SYSAUX01.DBF';
restore datafile 'H:\oracle\proddata\SYSAUX01.DBF';
}
######################################################
SQL >
alter database rename file 'H:\oracle\proddata\system01.dbf' TO 'f:\oracle\proddata\system01.dbf' ;
alter database rename file 'H:\oracle\proddata\system02.dbf' TO 'f:\oracle\proddata\system02.dbf' ;
alter database rename file 'H:\oracle\proddata\system03.dbf' TO 'f:\oracle\proddata\system03.dbf' ;
alter database rename file 'H:\oracle\proddata\system04.dbf' TO 'f:\oracle\proddata\system04.dbf' ;
alter database rename file 'H:\oracle\proddata\system05.dbf' TO 'f:\oracle\proddata\system05.dbf' ;
alter database rename file 'H:\oracle\proddata\system06.dbf' TO 'f:\oracle\proddata\system06.dbf' ;
alter database rename file 'H:\oracle\proddata\system07.dbf' TO 'f:\oracle\proddata\system07.dbf' ;
alter database rename file 'H:\oracle\proddata\system08.dbf' TO 'f:\oracle\proddata\system08.dbf' ;
alter database rename file 'H:\oracle\proddata\system09.dbf' TO 'f:\oracle\proddata\system09.dbf' ;
alter database rename file 'H:\oracle\proddata\system10.dbf' TO 'f:\oracle\proddata\system10.dbf' ;
alter database rename file 'H:\oracle\proddata\system11.dbf' TO 'f:\oracle\proddata\system11.dbf' ;
alter database rename file 'H:\oracle\proddata\undo01.dbf' TO 'f:\oracle\proddata\undo01.dbf' ;
alter database rename file 'H:\oracle\proddata\a_archive01.dbf' TO 'f:\oracle\proddata\a_archive01.dbf' ;
alter database rename file 'H:\oracle\proddata\a_int01.dbf' TO 'f:\oracle\proddata\a_int01.dbf' ;
alter database rename file 'H:\oracle\proddata\a_media01.dbf' TO 'f:\oracle\proddata\a_media01.dbf' ;
alter database rename file 'H:\oracle\proddata\a_nolog01.dbf' TO 'f:\oracle\proddata\a_nolog01.dbf' ;
alter database rename file 'H:\oracle\proddata\a_queue01.dbf' TO 'f:\oracle\proddata\a_queue01.dbf' ;
alter database rename file 'H:\oracle\proddata\a_queue02.dbf' TO 'f:\oracle\proddata\a_queue02.dbf' ;
alter database rename file 'H:\oracle\proddata\a_ref01.dbf' TO 'f:\oracle\proddata\a_ref01.dbf' ;
alter database rename file 'H:\oracle\proddata\a_ref02.dbf' TO 'f:\oracle\proddata\a_ref02.dbf' ;
alter database rename file 'H:\oracle\proddata\a_summ01.dbf' TO 'f:\oracle\proddata\a_summ01.dbf' ;
alter database rename file 'H:\oracle\proddata\a_txn_data01.dbf' TO 'f:\oracle\proddata\a_txn_data01.dbf' ;
alter database rename file 'H:\oracle\proddata\a_txn_data02.dbf' TO 'f:\oracle\proddata\a_txn_data02.dbf' ;
alter database rename file 'H:\oracle\proddata\a_txn_data03.dbf' TO 'f:\oracle\proddata\a_txn_data03.dbf' ;
alter database rename file 'H:\oracle\proddata\a_txn_ind01.dbf' TO 'f:\oracle\proddata\a_txn_ind01.dbf' ;
alter database rename file 'H:\oracle\proddata\a_txn_ind02.dbf' TO 'f:\oracle\proddata\a_txn_ind02.dbf' ;
alter database rename file 'H:\oracle\proddata\a_txn_ind03.dbf' TO 'f:\oracle\proddata\a_txn_ind03.dbf' ;
alter database rename file 'H:\oracle\proddata\a_txn_ind04.dbf' TO 'f:\oracle\proddata\a_txn_ind04.dbf' ;
alter database rename file 'H:\oracle\proddata\a_txn_ind05.dbf' TO 'f:\oracle\proddata\a_txn_ind05.dbf' ;
alter database rename file 'H:\oracle\proddata\ctxd01.dbf' TO 'f:\oracle\proddata\ctxd01.dbf' ;
alter database rename file 'H:\oracle\proddata\odm.dbf' TO 'f:\oracle\proddata\odm.dbf' ;
alter database rename file 'H:\oracle\proddata\olap.dbf' TO 'f:\oracle\proddata\olap.dbf' ;
alter database rename file 'H:\oracle\proddata\owad01.dbf' TO 'f:\oracle\proddata\owad01.dbf' ;
alter database rename file 'H:\oracle\proddata\portal01.dbf' TO 'f:\oracle\proddata\portal01.dbf' ;
alter database rename file 'H:\oracle\proddata\SYSAUX01.DBF' TO 'f:\oracle\proddata\SYSAUX01.DBF' ;
alter database rename file 'H:\oracle\proddata\LOG02A.DBF' TO 'f:\oracle\proddata\LOG02A.DBF' ;
alter database rename file 'H:\oracle\proddata\LOG02B.DBF' TO 'f:\oracle\proddata\LOG02B.DBF' ;
alter database rename file 'H:\oracle\proddata\LOG01A.DBF' TO 'f:\oracle\proddata\LOG01A.DBF' ;
alter database rename file 'H:\oracle\proddata\LOG01B.DBF' TO 'f:\oracle\proddata\LOG01B.DBF' ;
RMAN>Recover database;
RMAN>Alter database open resetlogs;
|
|
|
|
|
Re: Error in Restore [message #287342 is a reply to message #287302] |
Wed, 12 December 2007 00:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | Have you actually encountered this situation?
|
I never check it as I always also explicitly backup the control file. It is a possibility (maybe through a bug) and in backup matter I take no risk.
Quote: | performing logfile switches or manual archiving isn't necessary prior to backing up the archive logs since RMAN will ensure that ALL necessary redo is backed up automatically by performing any necessary switching prior to the backup.
|
I agree (at least for the 3 latest versions).
I picked up a couple of scripts in my archives, they were old ones and just examples not things to copy.
Thanks to emphasize their weaknesses.
Regards
Michel
|
|
|