Home » RDBMS Server » Backup & Recovery » Error in Restore
Error in Restore [message #286972] Mon, 10 December 2007 14:14 Go to next message
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 #286977 is a reply to message #286972] Mon, 10 December 2007 14:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't post the script you used but it is likely that you restore a control thta was backed up BEFORE all the data files were backed up and so it does not contain the reference to these backups.

Regards
Michel
icon9.gif  Re: Error in Restore [message #286988 is a reply to message #286972] Mon, 10 December 2007 15:23 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
how come it's possible i restored the old control file backup i just have 1 BACKUP set on that Target machine i didn't copy any other BACKUPSET from Source.

Q1-Should i have to configure any parameter in RAMN configuration for backup current control file or not?
Re: Error in Restore [message #287007 is a reply to message #286988] Mon, 10 December 2007 22:23 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>Q1-Should i have to configure any parameter in RAMN >configuration for backup current control file or not?
RMAN>configure controlfile autobackup on;
Default is off. if we set ON then controlfile/spfile is automatically backup with database backup.
Re: Error in Restore [message #287024 is a reply to message #286988] Mon, 10 December 2007 23:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you configure a parallelism then control file may be backed up in one piece BEFORE other pieces are recorded in it, for instance.
This is why I asked for script and now I add for configuration parameters.
Please post what I asked, it is a prerequisite for us to give you an answer.

In addition to Mohammad Taj answer: I always add an explicit "backup controlfile" as the last step in all my backup scripts.

Regards
Michel
Re: Error in Restore [message #287080 is a reply to message #287024] Tue, 11 December 2007 01:12 Go to previous messageGo to next message
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 #287086 is a reply to message #287080] Tue, 11 December 2007 01:18 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
RMAN>configure controlfile autobackup ON;

and as micheal suggested always include backup controlfile statement in your backup script.
Re: Error in Restore [message #287090 is a reply to message #287080] Tue, 11 December 2007 01:25 Go to previous messageGo to next message
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 #287092 is a reply to message #287090] Tue, 11 December 2007 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is this 05J38QIA_1_1 piece comes from?
It is nowhere in your post.

Regards
Michel
Re: Error in Restore [message #287099 is a reply to message #287092] Tue, 11 December 2007 01:37 Go to previous messageGo to next message
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 messageGo to next message
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 #287112 is a reply to message #287104] Tue, 11 December 2007 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All this is in the documentation.
Here's two examples but correct scripts depend on environment and cases:
configure snapshot controlfile name to '/export/home/oracle/snapcf_MCA.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=2096128K format '/space/MCA/backup/df_%d_%T_%s_%p'
          database include current controlfile;
   sql "alter system switch logfile";
   sql "alter system archive log current";
   backup maxsetsize=2096128K format '/space/MCA/backup/al_%d_%T_%s_%p'
          archivelog all;
#          archivelog all delete input;
   release channel d2;
   backup format '/space/MCA/backup/cf_%d_%T_%s_%p' current controlfile;
   release channel d1;
   }

set dbid=XXXXXXXXX;
connect target /
shutdown abort;
startup nomount;
run {
allocate channel disk1 device type disk format '/export/home/oracle/sauvegarde.rman';
restore controlfile from autobackup;
alter database mount;
restore database;
recover database;
alter database open resetlogs;
}

Regards
Michel
Re: Error in Restore [message #287133 is a reply to message #287112] Tue, 11 December 2007 03:00 Go to previous messageGo to next message
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 messageGo to next message
Michel Cadot
Messages: 64133
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 messageGo to next message
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 #287155 is a reply to message #287154] Tue, 11 December 2007 04:00 Go to previous messageGo to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
and also not Set DBID.
Because i am using control file so DBID is required for restore from catalog?
Re: Error in Restore [message #287302 is a reply to message #287024] Tue, 11 December 2007 21:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Michel Cadot wrote on Tue, 11 December 2007 00:23

If you configure a parallelism then control file may be backed up in one piece BEFORE other pieces are recorded in it, for instance.

In addition to Mohammad Taj answer: I always add an explicit "backup controlfile" as the last step in all my backup scripts.


Have you actually encountered this situation? With AUTOBACKUP ON, backup of the controlfile and spfile should occur AFTER the backup has executed and therefore parallelism shouldn't have an affect.

In addition, 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.
Re: Error in Restore [message #287342 is a reply to message #287302] Wed, 12 December 2007 00:47 Go to previous message
Michel Cadot
Messages: 64133
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
Previous Topic: Problem with RMAN configuration, I need help!
Next Topic: Parallel recovery (splitted from Error in Restore)
Goto Forum:
  


Current Time: Thu Dec 08 04:07:50 CST 2016

Total time taken to generate the page: 0.16291 seconds