Backup & Recovery :: Changing Location Of Data And Temp Files From Auto-backup Of Control-file?

Jan 26, 2012

I have an oracle autoback of controlfile and spfile. I am trying to restore the production database using this backup, into a new server with a different directory structure.

I have completed the following steps in the restore process.

1. Creating a pfile from spfile

2. Changing the the location of cdump, udump, bdump and the control files ( there are three )

3. Then creating a spfile from this pfile

I am stuck on the next step where to rename all the datafiles and tempfile and restore the database. Following is what I did.

After mounting the database in RMAN, tried to run the following.

RMAN> run
2> {
3> allocate channel c1 device type disk
4> ;
5> @/home/oracle/rman_scripts/newloc.rman
6> SET NEWNAME FOR DATAFILE 1 TO '/u02/oradata/dorian/system01.dbf';
7> SET NEWNAME FOR DATAFILE 2 TO '/u02/oradata/dorian/undotbs01.dbf';
8> SET NEWNAME FOR DATAFILE 3 TO '/u02/oradata/dorian/sysaux01.dbf';
9> SET NEWNAME FOR DATAFILE 4 TO '/u02/oradata/dorian/users01.dbf';


I am getting the following error message.

Starting restore at 25-JAN-2012 21:26:48
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/25/2012 21:26:49
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 30
RMAN-06100: no channel to restore a backup or copy of datafile 29
RMAN-06100: no channel to restore a backup or copy of datafile 28


View 14 Replies


Backup & Recovery :: RMAN Control File Auto Backup Error?

Dec 13, 2011

This is what I run

run {
sql 'alter system archive log current';


So /dd_oraback is a Data Domain mount. Not sure if that makes any difference or not.

View 1 Replies View Related

Backup & Recovery :: Restoring Spfile And Control File To New Location?

Aug 3, 2011

Im trying to restore my spfile and (later controlfile) to a new location:

RMAN> connect catalog rman11cv/pwd@metarep


RMAN> connect target

ansluten till msldatabasen: DATABASE (DBID=510270843)

RMAN> run
2> {
3> allocate channel ch1 type 'sbt_tape'
4> PARMS="BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
5> TRACE 0;
6> Restore spfile to pfile 'y:
7> }

tilldelad kanal: ch1
kanal ch1: sid=537 devtype=SBT_TAPE
kanal ch1: CommVault Systems for Oracle: Version 9.0.0(BUILD84)

Starting restore at 2011-08-03

frigjord kanal: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: restore-command failed at 08/03/2011 11:39:26
ORA-27191: sbtinfo2 returned an error

The spfile and control file exists.

RMAN>list backup of spfile

BS-nyckel Typ N Storlek Enhetstyp Tidsσtgσng Slutf÷randetid
------- ---- -- ---------- ----------- ------------ --------------
736698 Full 256.00K SBT_TAPE 00:00:04 2011-08-02
BP-nyckel: 736705 Status: AVAILABLE Komprimerad: NO Tagg: TAG2011080
Handtag: dkmj0i8p_1_1 Media: V_73870
SPFILE har inkluderats: Σndringstid: 2011-08-02

View 5 Replies View Related

Backup & Recovery :: Data Files Backed Up To FRA Instead Of Specified Location?

Jun 24, 2013

I am trying to backup my entire database's files :

[oracle@testing-oracle-1 ~]$ rman target /
Recovery Manager: Release - Production on Mon Jun 24 16:09:54 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1341263457)
RMAN> list backup;

using target database control file instead of recovery catalog specification does not match any backup in the repository

new RMAN configuration parameters:
new RMAN configuration parameters are successfully stored
FOR DEVICE TYPE DISK TO '/u01/app/oracle/backupsets/control_files/cf_%F.BCKP';2>


I see that a backup set was created to "/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/" , in spite of my specification.

So I asked RMAN to list all the backups I have:

RMAN> list backup;

List of Backup Sets
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 41.14M DISK 00:00:00 24-JUN-13
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20130624T161025
Piece Name: /u01/app/oracle/backupsets/818957425_1_%r.BCKP


Here I see that 4 backup sets have been created.The backup sets 1 & 3 containing the archived redo logs (818957425_1_%r.BCKP and 818957451_3_%r.BCKP) are placed as I wanted in /u01/app/oracle/backupsets/ dir.

The file containing the Control File and Spfile (cf_c-1341263457-20130624-00.BCKP) is placed as I wanted in /u01/app/oracle/backupsets/control_files/ dir.However, The backup set file containing the data files(o1_mf_nnnd0_TAG20130624T161026_8wjkb2tg_.bkp) is placed under the directory /u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/ ,and I don't understand why.

When I backup my database without the archived redo logs - it is saved correctly:

RMAN> delete backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name


1. Why aren't my data files backed up to the location I specified when I backup using PLUS ARCHIVELOG syntax?

2. Why are my redo logs saved to two different backup sets and not just one?

3. Is there a way to combine backup of all files (data files, control file, spfile, redo logs & arch redo's) in one backup set, one file?

View 5 Replies View Related

Backup & Recovery :: Restore From Newer Control File And Archived Redo Log Files?

Mar 29, 2011

I've got a legacy SAP system with oracle 8i on Tru64. No changes at all are made but for legal reasons we have to keep it up and running.

we currently do a full backup monthly by shutting down oracle and doing a backup of all the files to tape and that takes around 12 hours.

If I stop doing the full backup and I only backup the control file and the archived redo log files every month and I had to restore the full database years from now, would I be able to restore the database using the last full monthly backup and use the latest control file and archived redo log files?

View 5 Replies View Related

Backup & Recovery :: Restore DB From Control Files Using Symantec Backup Exec

Jun 10, 2013

I am having a issue, we are trying to restore our db from control files using Symantec Backup exec, but job fails giving me error go to table spaces select all table spaces and unchecked roll forward.

i am unable to find way to uncheck the table spaces. Here is the complete description.


The system catalog tablespace "syscatspace" contains all of the system catalog information for the tables. Syscatspace needs to be rolled forward first, and then the other tablespaces must be rolled forward.



When the restore operation is run from a tablespace level backup, perform the rollforward for the syscatspace tablespace first and then for other tablespaces.

Execute the rollforward operation as a DBA operation. The sequence of the recovery process should be as follows:

1. Select all tablespaces, uncheck the rollforward option and run the restore job.
2. Run the rollforward operation as a DBA initiated operation:

rollforward syscatspace to point in time / end of logs. e.g. db2 => rollforward database UEXIT to end of logs and complete Tablespace (SYSCATSPACE) online

3. Perform rollforward of all other tablespaces.

e.g. db2 => rollforward database UEXIT to end of logs and complete tablespace (SYSTOO LSPACE,USERSPACE1) online

Refer to IBM DB2 documentation for more information on DBA-initiated operations.

View 9 Replies View Related

Backup & Recovery :: RMAN Full Backup Failing When Backing Up Temp File?

Jan 28, 2011

I am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..Command that i am useing is ...

brbackup -u / -c force -t online_split -m full -p

The backup goes thru but i get this erro on the end...

BR0522I 57 of 57 files/save sets processed by RMAN
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28


Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42


Recovery Manager complete.
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman


I have check on the system .. There is not file like that but thwre on on the db i,e

eshtsm20:orabr1 88> pwd
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1

View 13 Replies View Related

Backup & Recovery :: Can A Control File Backed Up Be Present In Multiple Backup Pieces

Sep 27, 2011

Suppose I take a multi stream backup, say 3 streams.

So if a control file is backed up in say backup set 1, so is the whole control file is backed up in one backup piece or it may span multiple pieces?

A backup set may have multiple backup pieces.

View 2 Replies View Related

Backup & Recovery :: Restoring Later Backup Control File And Recovering Till Past Scn

Jul 11, 2012

I want to ask if I restore a control file from backup of say day2 and I recover till day1 using RMAN script, then what will be the state of my database? I mean day2 control file may be having SCN-Day2, and I am instructing RMAN to recover till past point in time that is SCN-Day1.

View 3 Replies View Related

Backup & Recovery :: Configuration Can't Be Changed For BACKUP Or STANDBY Control File

Sep 18, 2012

On my stand by DB when I run the following command I get this error:

Is this line really needed based on my run block?

allocate channel t1 type 'SBT_TAPE'


View 4 Replies View Related

Backup & Recovery :: Backup Of Control File On Standby Node?

Apr 3, 2013

I am trying to backup my control on a STBBY DB(RAC) and I am getting the ollowing error.

ORA-00245: control file backup failed; target is likely on a local file system

what the issue is? Note the FS is ACFS and can see on all my nodes

show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PA01INS_IM3L059B are:


ACFS file system

df -h /share/dbbkup/oracle/PA01INS/rman
Filesystem Size Used Avail Use% Mounted on
/dev/asm/pa01ins-33 75G 2.6G 73G 4% /share/dbbkup/oracle/PA01INS
rman cmdfile=control.rman


View 2 Replies View Related

Backup & Recovery :: Restore Control File Backup

Feb 10, 2011

I take hot backup of database at 10:00 am.After taking the hot backup 50 archived logs are created.Out of 50 i have backed up first 25 of them and at 5:00pm i lose complete database including control,data and the last 25 archived log files that were not backed up.So I am using latest hot backup to recover

I restore the control file backup and datafile backup taken during ho tbackup(10 am) and i issue the command

.......startup mount
>>>>>>>Recover database until cancel
!!!!!!! Apply the available 25 archive logs

then i give "cancel" since I dont have the next redo log .Now in which mode will the database open(Reset logs or no reset logs)

View 6 Replies View Related

Backup & Recovery :: To Restore Control File From Backup Set

Dec 9, 2011

I want to restore control file from backup set,just as the flowing command,where location does the control file be restored to? how can i specify the location when restore control file?

restore controlfile from '/u01/rman_backup/mybak/df_768589733_7_1.bak';

View 2 Replies View Related

Backup & Recovery :: Backup Control File To Trace?

May 28, 2012

taking the backup of a control file, as i am taking online backup, archive mode.

At first i have executed the statement

sql> alter database backup control file to trace;

then i have removed the control files and enterd some data in a table and committed it.As my oracle is not shutting down, so i shut aborted it. Now after saving the last file from the udump as obkp.sql i am unable to edit this file and use.

how to edit and use this file, so that i can startup my database normally.

View 4 Replies View Related

Backup & Recovery :: How Many Times To Backup Control-file

Jan 5, 2012

When i issue this command ,how many times to backup controlfile?



View 2 Replies View Related

RMAN :: Where Does Control File Auto-backup Information Gets Stored

Jun 15, 2012

where does the control file auto-backup information gets stored? or how does a RMAN knows from where to restore a controlfile in auto backup?

View 12 Replies View Related

Backup & Recovery :: Restore From Control Files

Feb 13, 2012

I had a database on an old P4 running but the motherboard got fried. I was able to recover all the data files (.ctl and *.dbf) plus the redo logs (.log). There is no export or backup taken - I have old ones, but I need to recover the latest which only existed in the data files.

I now have Oracle installed on a new P5 machine and was wondering if it is possible to use these data files in the new database? If so, how do I go by restoring the data files?

Both the P4 and P5 where running Red Hat Linux.

View 3 Replies View Related

Backup & Recovery :: Default Location For RMAN Backup

Jun 1, 2012

What is the default location for the Rman backup ORACLE_HOMEdbs is it correct?

View 1 Replies View Related

Backup & Recovery :: SPFILE Restore From Auto-backup No Catalog

Aug 1, 2012

I need to restore entire database(sp+control+datafile) to new host.I have started the instance with nomount( and it has created a dummy parameter file).Now, I need to fire the command to restore spfile.

RESTORE SPFILE TO PFILE '?/oradata/test/inittrgta.ora' FROM AUTOBACKUP;

My questions:-

1.How will RMAN find the location of backupset(Since there is controlfile for neither target or catalog database)?

2.How does RMAN reache the backupset in case of a)tape b)disk?

View 4 Replies View Related

Backup & Recovery :: Corrupt Control File?

Dec 2, 2011

I've recently moved jobs and am doing a lot of the normal things getting familiar with my new company's databases.I was checking through our production backup logs and came across something that looks a little funny. From the last two days backups, I see:

select completion_time, marked_corrupt, media_corrupt, logically_corrupt
from v$backup_datafile
where controlfile_type = 'B'
order by completion_time desc

01/12/2011 11:27:252011 1201 2
01/12/2011 11:26:180 0 0
01/12/2011 11:25:242011 1201 1
01/12/2011 11:15:562011 1201 0
01/12/2011 01:40:100 0 0
30/11/2011 11:23:482011 1130 2
30/11/2011 11:22:440 0 0
30/11/2011 11:21:562011 1130 1
30/11/2011 11:13:002011 1130 0
30/11/2011 01:41:010 0 0

The 01:40 record will come from our nightly command:


The 11AM records will come from the command:


(I know backups shouldn't still be running at 11am and we don't need level 0 backups every night, that's a seperate issue I'll be addressing! ) I see there's been a similar entry here in v$backup_datafile for all backups that there's records for. The database is up and running just fine. There are no unusual errors being reported by the database in OEM or the alert log.I tried looking at both our control files (yes, should have 3 - something else I've listed to change!) with dbverify which showed no issues - though I'm not sure if this is designed to work with control files.

If so, how could I confirm whether it's an issue with a specific controlfile (I'm assuming it's not an issue with the backup to tape itself, as it's reporting the same corruption every day)?I'd obviously like to diagnose this now while the db is up and running, rather than at 4am some morning during a crash and finding out my backup control files are no good!

View 10 Replies View Related

Backup & Recovery :: No RMAN Records In Control File

Dec 7, 2012

We're running Database on AIX with no catalog Database.We keep all the backup info in controlfiles only.When we do that backup, we're able to successfully back it up (including archivelogs). But I'm unable to find any records in the controlfiles.

SQL> select * from V$BACKUP_SET;

no rows selected


SQL> sho parameter control

------------------------------------ ------------------------------
control_file_record_keep_time integer 14

View 13 Replies View Related

Backup & Recovery :: Backing Up Control File And SPFILE

Jun 26, 2012

I've pasted some of the results of an RMAN backup that I ran. It says that it's backing up both the Control File and the SPFILE, but it appears that only one file is being created. Is this correct? How does this work? Are both files combined into the C-3843121877-20120619-00 file?

Starting Control File and SPFILE Autobackup at 19-JUN-12
piece handle=C:ORACLEPRODUCT10.2.0DATABASEC-3843121877-20120619-00 comment=NONE
Finished Control File and SPFILE Autobackup at 19-JUN-12

Also, regarding the below configuration of RMAN - I can change this directory to whatever I want, correct? In other words, is it just the directory where I am putting the backup?


View 2 Replies View Related

Backup & Recovery :: Restore Database Using Control File Until Cancel

May 17, 2012

In order for the following command to work:

> recover database using backup control file until cancel;

what command must precede it, is it:

> alter database backup control file to trace;

View 4 Replies View Related

Backup & Recovery :: To Create Binary Copy Of Control File

Oct 22, 2013

I want to create binary copy of control file every time I do backup. I am using sql "alter database backup controlfile to ''+FRADG/TESTDB/controlfile/controlfile.ctl'' "; in my rman backup script. If I run it second time I got errors as it does does not allow to overwrite existing one.

View 5 Replies View Related

Backup & Recovery :: 11g R2 - How To Update Control File With Switch Command

Oct 3, 2011

I have restored all datafile to new location (that is ASM) earlier it was on file system using set new name command (RMAN). Now when i'm trying to update control file with swicth command it is prompting error. Version is 11g R2.


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "all": expecting one of: "double-quoted-string, integer, single-quoted-string"
RMAN-01007: at line 1 column 17 file: standard input

View 3 Replies View Related

Backup & Recovery :: Control-file Piece Handle Lost From Tape?

May 9, 2011

We are trying to restore a database to a cold backup DBID.However while our datafiles were backuped up for 6 months retention we found out subsequent delete obsolete command wiped out the Control file related to this backup piece..Now what is left with this backup piece is just datafiles..

Can we still recover the database with a subsequent controlfile autobackup for the same DBID.?

View 2 Replies View Related

Backup & Recovery :: RMAN - Control File Be Used To Store Scripts Which Are Used To Perform Backups?

May 12, 2011

Can the control file be used to store scripts which are used to perform backups? I know the RMAN recovery catalog can.

Does the SHOW command display detailed reporting on the RMAN catalog contents other than configuration information?

View 1 Replies View Related

Backup & Recovery :: Synchronize CTI And Data Files

Dec 28, 2012

db can only be opened if all the datafile and controlfiles are synchronize.I wonder if db crash and we dont have any kind of backup. is there some way to synchronize the control file with the datafile?....any way.db is not idle either when crashes we can manage data lose.just want our database open

View 1 Replies View Related

Backup & Recovery :: Recover Data From DBF Files?

Feb 24, 2013

My server hard disc crashed yesterday and i don't have any backups.

I am able to recover the .dbf files by using a recovery tool.

is it possible to use this .dbf files into new server and recover my data.

View 5 Replies View Related

Backup & Recovery :: Querying V$archived_logs To Backup ARC Files?

Nov 28, 2011

When we backup .arc files we issue a RMAN command similiar to this:

rman <<EOT
connect target ....
connect catalog ...
sql "alter system archive log current";


The problem is at times there may not be any archive files that meet this criteria and RMAN throws an error

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archived log in the recovery catalog

I was considering using the following code to see if there are any available .arc files that meet the backup criteria.

set pagesize 0 feedback off verify off heading off echo off;
select count(1) from v$archived_log where
and backup_count = 0 and name is not null;

While testing on several systems, I found that the above-mentioned query picked up some redo-logs (*.rdo) I can only assume that these redo logs were used for a DB recovery.



I have a few questions:

1) Is my assumtion correct about the .rdo files in the v$archived_logs table

2) I would hate to add special logic and look for something like name substr(name, *.arc) (pardon the syntax). Therefore, is there a way to get rid of these *.rdo files?

View 9 Replies View Related

Copyrights 2005-15, All rights reserved