RMAN-06023 When Restoring Full Database (new Datafiles)

Jun 20, 2013

I'm testing out various RMAN restore/recovery scenarios for 10g R1. Took a full level-0 backup of one of our larger databases (16 tb) and I'm trying to restore the whole thing on another server. While the backup was running (for about a day & a half), a few datafiles were added. The backup completed fine, including "backup current controlfile;". Now my restore is failing with "RMAN-06023: no backup or copy of datafile xxxx found to restore", with reference to the 4 files that were added while the backup was in progress.

I guess if the datafiles were added after the backup had finished, we'd be fine because they'd be created during recovery with our archive logs (we have all of those).

I found some suggestions for first doing a "restore controlfile;" -- did that and it worked fine -- then mounting the database and creating the datafiles manually. I added that to my RMAN restore script and tried it, like so:

run {
allocate channel d4 type disk format '/BK01/dbX/stream1/df_%t_s%s_s%p' ;
sql "alter database create datafile ''/uXX/oradata/dbX/datafile_58.dbf''";
restore database ;
}

The datafiles were created successfully, and the restore began .. but then it failed with this:

creating datafile fno=4216 name=/uXX/oradata/dbX/datafile_58.dbf
...
RMAN-03002: failure of restore command at 06/20/2013 17:27:28
ORA-01119: error in creating database file '/uXX/oradata/dbX/datafile_58.dbf
ORA-27038: created file already exists

So RMAN seems to be telling me that if these 4 datafiles don't exist in the backupset, then RMAN won't automatically create them. But if I manually create them first, then RMAN will try to restore them and complain that they already exist. And for that matter, I would have expected that RMAN would be smart enough to detect that those 4 files were added while the backup was active, and just include them in the backup. Maybe there's something I needed to do to tell RMAN to do that?

This is just a test, so of course I can redo the backup from scratch and try again, but we have some pretty large databases which cannot be shut down for cold backups, so it's entirely possible this scenario could show up in a real disaster recovery. RMAN does such a good job of managing things.

View 1 Replies


ADVERTISEMENT

RMAN :: Restoring Backup From Other Database

Aug 6, 2012

I just duplicate my PRODUCTION database to TEST database (11.2.0.1 both) on windows 7.

I just create a backup from PRODUCTION:

RMAN> backup full database format ='C:Usersmy_usermiBBDDflash_recovery_are aTESTdatabase_%U';and controlfile backup:

RMAN> backup current controlfile format='C:Usersmy_usermiBBDDflash_recover y_areaTESTCONTROL_FILE_%U';now i'm trying to restore this backup into TEST with this script:

RMAN
CONNECT TARGET /
STARTUP NOMOUNT;
SET DBID 486238190;  #DBID of TEST database
RUN

[Code]....

but i'm having a similar error when i tried to duplicate both databases ( post -->Error duplicate databases fallo de la recuperaci¾n del medio fÝsico
canal liberado: c1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: fallo del comando recover en 08/06/2012 11:53:06
ORA-00283: recovery session canceled due to errors
RMAN-11003: fallo al analizar/ejecutar la sentencia SQL: alter database recover

if needed start until cancel using backup controlfile

ORA-00283: recovery session canceled due to errors

ORA-01110: data file 1: 'C:USERSmy_userMIBBDDORADATAPRODUCTIONSYSTEM01. D BF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:USERSmy_userMIBBDDORADATAPRODUCTIONSYSTEM01.D BF'

Controlfile was restored correctly. what am I doing wrong?

View 23 Replies View Related

Backup & Recovery :: Error While Restoring Database Using RMAN

Mar 31, 2011

i am trying to restore database using rman backup on same machine using command

RMAN> run {
2> set until sequence 23;
3> restore database;
4> recover database;
5> }
but it will give me error.
RMAN-00571: =======================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===========
RMAN-00571: =======================================================
RMAN-03002: failure of restore command at 03/31/2011 19:18:11
[code]....

View 3 Replies View Related

Recovery Manager (RMAN) :: Restoring A Backup To A New Database Instance

Sep 4, 2013

I have an issue with restoring a RMAN backup that i have with me to a new database instance. What i have with me are: 1. Backup of SPFile.

(O1_MF_NCNNF_CTLFILE_BU_92DVGYO2_.BKP)2. Backup of Control file (O1_MF_NNSNF_SPFILE_BU_92DVGW9H_.BKP)3. Full database backup (O1_MF_NNSNF_FULLPROD_BU_92DVGW9H_.BKP)

 I have received these files from a customer environment and I need to restore these to a new database instance in a local machine. I have given a attempt as follows (in Oracle 10g): 1, Created a new database instance (Test75) using Oracle Database Configuration Assistant2. SET ORACLE_SID = Test753. Connected to this instance using RMAN4. Tried to restore the SPFILE from the received BKP file.I am getting errors and cannot proceed. I am not sure whether I am executing the correct steps.

View 6 Replies View Related

Backup & Recovery :: RMAN Full Database Backups

Nov 9, 2011

Environment:
oracle 10.2.0.1.0
Windows XP

I have taken the RMAN Full database backup through the following command.My database is in no archivelog mode.

AT RMAN prompt
Shutdown immediate;
Startup mount;
run
{
allocate channel c01 device type disk format 'd:
man_bkp est_%U';
allocate channel c02 device type disk format 'd:
man_bkp est_%U';
backup full database tag 'full_bkup_test_081111';
backup current controlfile;
backup spfile;
release channel c01;
release channel c02;
}

Now i have deleted my all controlfile and spfile/Pfile from the database.So how can i recover my SPfile and controlfile? i do not have autobackup on of SPfile/Controlfile.

View 7 Replies View Related

RMAN :: How To Reduce Full Database Backup Time

Feb 15, 2013

I am running full database backup it take 10hrs to complete.

Size of the database=590GB

Platform:Solaris 9

database version:10.2.0.5

using catalog database.

Is there any way to reduce the time ?

Is there any query to see how long does the backup runs?Monitor the backup time?

View 5 Replies View Related

Security :: How To Clone Database Using RMAN Full Backup On Different Machine

Oct 1, 2012

How to clone database using RMAN FULL BACKUP on different machine? I do not wants to use DUPLICATE Command......

Is there any other way to clone DB? I am using Oracle 11g R1 on Windows Server 2007 (64 bit)

View 2 Replies View Related

Data Guard :: Take RMAN Full Backup Of Standby Database On Regular Basis?

Jun 8, 2012

I use windows 2003 server, oracle 10.2.0.4.0.My question is related to maintaing a standby database

1. Do we need to take RMAN full backup of standby database on a regular basis? At the moment I dont take backups of standby database.

2. I have FRA on standby database. The archivelogs from primary go to FRA on standby. I delete my archivelogs as follows:

DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';

Though the archivelogs are delete there are still empty folders of archivelogs that are not deleted. How to get rid of them automatically.

View 2 Replies View Related

Backup & Recovery :: Restoring RMAN Backups On Another Server

May 10, 2011

I have a live server on which Oracle 10g Database is running. We take full RMAN Backups everyday. Now we want to restore the RMAN Backup file from the Live server to another machine (which is going to be a test system). I want to restore the latest RMAN backup on the test machine (which is not on network).

When I copy the RMAN backup set in the flash recovery area of the test machine and then use "list backup", the backup set is not listed. I also tried "crosscheck backup" and then "list backup" but still the backup set does not appear. how can I register the backup set from live server into test machine and then restore it.

View 5 Replies View Related

RMAN :: Restoring Backup From Tape Beyond Retention Policy?

Nov 7, 2013

How we can use RMAN backup to restore oracle database when the RMAN backup pushed to tape already and being a OLD backup ( before retention policy date).Just to elaborate a more..  Say my retention policy is 3 days. I want to restore from a old backup  like 30 days old.So surely the requesting backup is behind retention date and has been pushed to tape.

View 1 Replies View Related

Data Guard :: Restoring Logical Standby Rman Backup On Production

Oct 9, 2012

I have One Production and one logical standby database . Due to tape problem we are unable to take backups of primary . And due to business , we cannot take back up on disk in hot period(Bank database ) .

If i take logical standby database backup(level 0 ) using RMAN , then will i be able to restore it on production dtbs (In case Production down) ? . Logical standby is in sync with primary .

View 2 Replies View Related

Recovery Manager (RMAN) :: Duplicate Restoring Older Version Of File Than Expected?

Feb 28, 2013

We are running 11.2.0.3.2.

In my catalog for the "source" database (rman target db), I have the backupsets for a full database backup ended at Feb. 7, 03:43:37. These are online backups. So, there are archived redo logs being generated while it runs and the following archived redo logs finished at Feb. 7, 04:00:24.

We duplicate databases all the time. So, this is not a new concept for us. The one thing that has changed is that we now back up to disk (using the flashback recovery area) and then later on, initiate a backup to tape. Prior to this go-live, we did all of our backups directly to tape. The catalog does not seem confused. It knows it needs to go to tape because it's beyond the retention for disk backups. The only problem is that it is going to the backup prior to the backupset I want, only for a couple of files.

In the past, when all went directly to tape, we would do a set until time 'Feb. 7, 03:43:37' and it would automatically restore the backupset that finished then and apply archived redo logs as necessary to make a consistent copy. Now, if I use the same model, it's going to a backup set from the prior date for 3 particular files. If I change the time to when the archived redo logs ended their backup, 04:00, it still goes back to the day before, but only for 2 files.

I can list a backup of each specific file and see that the file is in the backupset for which I expect RMAN to pull. How can I figure out a date/time to go back to if not using the method of reviewing the catalog entries and timestamps?

View 4 Replies View Related

Server Administration :: RMAN Restore Failure All Datafiles

Jul 1, 2013

I am facing an issue while rebuilding a DR (Physical Standby) site using RMAN.Rman is failing to restore all the datafiles to the stanby site.

There are 403 datafiles that should be restored among which after restoring 50-60 datafiles the channel is abruptly getting terminated.Please note this exercise is not new I have done this many times (once a year after a DR testing) and the same script is being used.The rcv file is as follows

/u03/oracle/admin/mpr/scripts/dataguard/configure_dr.rcv
connect auxiliary sys/XXXX@YYY
run {
duplicate target database for standby nofilenamecheck dorecover;
}
exit
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
configure_dr.rcv: END
[code]....

The trace file says "krso_proc_add: Detected dead process 13828326; subsuming V$MANAGED_STANDBY slot
INFO: krsr_rfs_atc: RFS processes are temporarily disallowed"

I have also started RMAN debug tracing and the trace is also scanned as it is huge.I have seen the following in the trace error 3015 signalled during compilation..I do not find any specific oracle error to check on .

The only change that happened is that the Primary production server has been moved to a new datacentre and after its move all the connections seems to be working fine.

View 3 Replies View Related

Restoring Standby Database

Sep 27, 2012

My standby got corrupted and I need to restore from Primary database. As it is already setup , no need to configure listener and tnsnames.

At Primary site
==========
1. After shutting down the primary database.
2. copying all .dbf and log files. (need to query v$datafile and v$logfile)
3. Copying archive logs. (not sure about this step)
4. Again restart, create control file for standby database.
5. Restart primary database.

Standby
=====
1. After changing the location of control file on standby parameter file (initSTANDBYDB.ora)
2. Startup nomount pfile='/pfile/location'
3. Mount the standby database.
4. Putting database in MRM mode.

View 3 Replies View Related

Backup & Recovery :: Restoring Pre-RMAN Backup

Dec 8, 2011

Just inherited an 8i DB that is being backed up with then common techniques used prior to RMAN. The tablespace is placed in backup mode, an OS copy of the file is taken, the tablespace is returned online, and the process is repeated until all files captured in an usable state.

It is running in archive log mode on a Linux OS and daily backups are initiated through crontab as well as jobs to purge the redo logs after backup. Backup storage recently filled - working since 2004. Not bad!

I have documented procedures for using these files with an operational 8i DB. Will I be able to restore these files directly into an 11g environment? What is the implication of 8i having DBA managed "RBS" (roll back segments) vs. 11g?

I am thinking I will have to build both versions.

View 7 Replies View Related

Backup & Recovery :: RMAN Backup Empty Block From Datafiles?

Apr 27, 2012

Does change in segment size effect the rman backup size..??

I'm trying to understand do Rman backup the empty block from datafiles..?? And if it escape the empty block than inserting data in tables (increasing the number of used block) might change the size of total backup (Rman) size

View 2 Replies View Related

Moving Datafiles Between Database

Oct 31, 2012

I read this article:

[URL]......

Does it work with copying datafiles from 10g2 to 11g2? I want to move one huge tablespace (which contains one table) from 10g2 to 11g2, what is the best method to do that?

View 3 Replies View Related

RMAN Full Backup - All Application Connections Goes In Wait Mode

Aug 8, 2012

on our 10.2.0.5 database, when we run full backup, my system performance comes to an halt. we run full backup and then do a validate backup to validate the structure of the database etc. Database performance takes a hit and all of the application connections goes in wait mode: On ASH or AWR - this is the top wait i see:

RMAN backup & recovery I/O

Event % Event P1 Value, P2 Value, P3 Value % Activity Parameter 1 Parameter 2 Parameter 3
RMAN backup & recovery I/O 22.22 "1","32","2147483647" 21.79 count intr timeout

what can we do to over come this issue?

View 3 Replies View Related

Recovery Manager (RMAN) :: Restore From Full Backup While Incremental Lvl 0 Available

Sep 10, 2012

7 of days ago Full backup has been taken to disk due to issues with tape devices.3 days ago tape devices have been fixed and we switched to CommVault managed tape backups. CommVault calls RMAN with following command:

run {
     allocate channel ch1 type 'sbt_tape'
     PARMS="SBT_LIBRARY=/usr/local/bin/simpana/Base/libobk.so,BLKSIZE=1048576,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine=BACKUP -jm 45 -a 2:71 -cl 9 -ins 9 -at 22 -j 294321 -jt 294321:4:1 -bal 1 -rcp 0 -ms 1 -data -ma 89 -cn oraclehost -vm Instance001)"
     TRACE 0;
     setlimit channel ch1 maxopenfiles 8;
     backup
     incremental level = 0
     filesperset = 32
     database
     include current controlfile spfile ;
     }
     exit;

These backups done successfully.Then archivelog backup taken similar way.But when I issue RESTORE DATABASE PREVIEW SUMMARY; RMAN starts with Full backup set, though newer Incremental Level 0 ones are available.Why it does not use these newer ones?

Oracle 10.2.0.5 for Linux on IBM POWER

View 2 Replies View Related

Restore Full Backup On New Server (With Same OS / Version Of Oracle) Without RMAN Catalog DB

Aug 26, 2010

I started restoring and testing all the backups. So far I did good and I wanted to restore and test in different host. I couldn't find any online documentation regarding restore full back up in a new different server (With same OS and same version of Oracle) without RMAN catalog database.

View 4 Replies View Related

Backup & Recovery :: Backup All Datafiles Only Using RMAN

Apr 20, 2013

Need the command for backup all the datafiles using RMAN. Not any specific data file.

Also another thing, when i try to take full database backup, it creates two .bkp file. What the two files for?

input datafile file number=00004 name=/oracle/oradb/oradata/ora138/users01.dbf
channel ORA_DISK_1: starting piece 1 at 20-APR-13
channel ORA_DISK_1: finished piece 1 at 20-APR-13
piece handle=/oracle/oradb/flash_recovery_area/ORA138/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T171350_8q4q2gop_.bkp tag=TAG20130420T171350 comment=NONE
[code].......

View 3 Replies View Related

Backup & Recovery :: Restore Datafiles In Another Database

Jun 29, 2011

Can we restore a database if we have only the datafiles available? The database has been dropped but we have just the datafiles with NO system, sysaux,users and undo datafiles that were saved after taking the database offline and then dropping the database. I know this is strange but if possible, I want to see if we can retrieve some of the data from those datafiles to another database. BTW, There is no backup available for this database except the dbf files on OS.

View 3 Replies View Related

RMAN :: Configured Recovery Catalog / Started Full Online Backup Using EMC Networker

Nov 27, 2012

I configured recovery catalog and started Full online backup using EMC Networker. In EMC Networker I set three months policy to keep Backup.I didn't change redundancy.

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

My question is, if I need to restore Backup of last 15 days then I can ?.

View 4 Replies View Related

Server Administration :: Estimating Size Of Database / Datafiles

Jul 3, 2010

I have checked the space of my tablespaces/datafiles in my database. I have 8 GB space left in my database server. I cant add more hard-disk as there is no slot left. We r planning to buy a new server with latest config.

My question is, how can we know upto what size our database can increase and when a datafile need to be added in advance. Sometimes even though datafiles have space left,it shows errors abt extents cannot be extended. We have coalesce the tablespaces and added a new datafile.

View 5 Replies View Related

Server Administration :: Recover Database With Some Datafiles And Archivelogs?

Dec 24, 2010

We have lost some datafiles and some archivelogs. We have backup of whole database taken on Dec 20 and archivelogs until Dec 23.So we dont have 1 day worth of archivelogs which can lead to incomplete recovery.

Now question is do we need to restore all datafiles or only lost datafiles for incomplete recovery since we dont have all archivelogs ? lost datafiles belong to different tablespaces.

Datafiles which are still intact are with current SCN and we restore lost datafiles only and recover unitl our last available archivelog it will have different SCN. Will we be able to open database or we need to resotre whole database for this scenario?

View 8 Replies View Related

Backup & Recovery :: Backing Up / Restoring Oracle Database Via Entire Backup Of Server

Aug 7, 2012

I've read a lot about the different types of backup available with Oracle (hot and cold backup). However, I was thinking of a different way of performing this task. I'm currently using Windows Server 2008 R2 and Oracle 11g Standard Edition. I'd like to schedule an entire backup of my server via the utility "Windows Server Backup" (available for free).That way, I could recover my entire server with all the programs and files in case the latter crashes.I'm wondering if this solution could be used as a way of backing up (and recovering) the Oracle database. Should I still set up a regular hot backup with the Archivelog mode enabled in case some operations/transactions were being done at the time of the crash (for the data integrity)?

View 2 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 initBR1_onlinefull.sap

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

[code]...

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

RMAN>
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

[code]...

Recovery Manager complete.
ERR_RC: 1
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

[code]...

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

eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
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 :: Does Full Cold Backup Of RMAN Include Online Redologs

Jan 8, 2013

Does the full cold backup of rman include online redologs?

So that at the time of recovery when i restore the database the online redologs also restored to that point?

View 2 Replies View Related

RMAN :: Size Of Level 1 Differential Backup Greater Than Full Backup

Jul 22, 2013

I am trying to practice some RMAN configuration settings.Version 11.2.0.1OS - Linux X86-64 What i wanted to validate is if there is no level 0 backup of database taken, then the level 1 backup will be automatically backing up all the blocks of the database(similar to full backup). RMAN> report schema; Report of database schema for database with db_unique_name DB101 List of Permanent Datafiles

File Size(MB) Tablespace  RB segs Datafile Name----1    300      SYSTEM +DATA/db101/datafile/system.257.8208254172    200  SYSAUX ***     +DATA/ db101/ datafile/sysaux.268.8208254253    820      UNDOTBS1 ***     +DATA/db101/datafile/undotbs1.261.8208254294    5000     TPCCTAB  *** +DATA/ db101/ datafile/tpcctab.266.820832485 List of Temporary Files=File Size(MB) Tablespace  Maxsize(MB) Tempfile Name---- 1    200..
[code]....

I am not sure what these input bytes are which is not matching with the database size(posted in the beginning of thread)? why it has to show as db full when i actually run a incremental?

View 1 Replies View Related

PL/SQL :: Backup Of Full Database Using EXP?

Aug 23, 2012

We are having 5 schemas in one database. Now we need to move Oracle server from one machine to another. I can take schema level back up using Export and Import in new server. I am not a DBA as we don't have a DBA I need to do this myself.

I want to know Is there an option to take full database back up including tablespaces and all the schemas in one shot. I read that RMAN is one option. But any option using EXP/IMP for same?

My plan is

-Take list of Tablespaces and create them in new server
-Take Exports of schemas from original server
-Create schemas and import the data in new server.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved