RMAN :: Restore Spfile From Non-default Location In ASM

Oct 24, 2013

Database: 11gEBS: 12.1.3O/S: Solaris Sparc 64 bits 

Problem Description: Cloning from Source instance A to target instance B and both are in ASM instances.RMAN backup in source instance A is completed, which has spfile configured in non-default location in ASM for example,see belowASMCMD

[+ASMDG003/TEST1 > ls -ltType           Redund  Striped  Time             Sys  Name   Y    TEMPFILE/  Y    ONLINELOG/  Y    DATAFILE/   Y    CONTROLFILE/     N    spfiletest1.ora => +ASMDG003/TEST1/PARAMETERFILE/SPFILE.747.856347 

Also, there is no SPFILE in $ORACLE_HOME/dbs for the TEST1 source instance. INITTEST1.ora file has the following entry: 

cat INITTEST1. oraspfile='+ ASMD G003 /TEST1/spfileTEST1.ora' 

Question: In the target instance to be cloned from RMAN backup fro source instance TEST1, on performing ' restore spfile from autobackup 'location';Will the spfile be restored in $ORACLE_HOME/dbs in the target instance TEST2?

View 6 Replies


RMAN :: Looking At Different Location To Restore On Physical Standby (10g)

Feb 12, 2013

I have 2 databases. Primary ( DB1 ) and Standby ( STBY1 ). My standby database went kaput, and i have as a result deleted the standby database in order to re-create it from a full primary backup.

Oracle 10g R2 on Server 2003.

I have followed several guides, and at this time i have done the following:

- Configured standby re-do logs on primary
- backed up current controlfile for standby
- backed up database plus archivelog
- configured the tnsnames

The problem is here. I connect to RMAN from standby

rman nocatalog
connect target sys/password@ DB1
connect auxiliary /
set until scn xxx;
duplicate target database for standby dorecover;

I receive an error message saying that it cannot find the file location of the backups that its trying to find. I see in the error that it tries to look locally for

E:FLASH_RECOVERY_AREA DB1 BACKUPSET2013_02_12), however the actual location is (E:FLASH_RECOVERY_AREA STBY1 BACKUPSET2013_02_12)

I have read that the locations need to be the same, however the instance names are different, and i thought i changed the pfile to accommodate that. My assumption is that i have made an error in the pfile. However i cannot see any issues there. Some things that i have changed in the pfile for standby:


View 2 Replies View Related

RMAN :: Complete Procedure To Restore Database On New Location

Aug 29, 2012

I have taken full backup of database plus archivelog. Then copied them to new server..I want the complete procedure to restore the database on new location.

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

How To Move Spfile On Default Local Filesystem To ASM Diskgroup

Jul 1, 2012

What is correct way to move the default oracle spfile to ASM diskgroup so i can successfully bring up the instance . After bring up the instance , it should point to ASM diskgroup. My oracle database is siting on sun solaris 64 Bit.

View 8 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

RMAN :: Restore Point Backup And Restore To New Host

Mar 14, 2013

We want to keep the Guaranteed restore point for week but unfortunately we don't have enough flash space in the server. Is it possible to backup the flashback log(restore point logs) through rman and send bkp file to tape? how to restore the database in new server until Guaranteed restore point.

View 1 Replies View Related

RMAN :: CLONING By Offline Backup Location?

Jan 9, 2013

I am doing a cloning of DB 11.1.0 from PROD to TEST but
os RHEL 5.5     
Click to add to Favorites          RMAN 11GR2 : DUPLICATE WITHOUT CONNECTING TO TARGET DATABASE [ID 874352.1]



is not working for same SID on the target database.it is asking for a target name.

View 4 Replies View Related

Backup & Recovery :: RMAN Restoration To New Location In Same Server

Nov 29, 2012

We need to test mean time to restore from rman backup. So can we restore the data file to new location on the same server without effecting the Database.?

View 4 Replies View Related

RMAN :: Give Output File Location In Crontab Using ( > )?

Aug 2, 2013

I need to take RMAN full backup by every Sunday night and Wednesday night . I have the netbackup script which will take the backup to media. 

Question is:1. We have 15 - backup scripts for 15 DB in that server , so if i configure crontab for backup do i need to give all 15 scripts one by one or (*) will work .    ie) 00 20 * * 3,7 /app/oracle/rman/scripts/hot_db_<sid>.sh    

instead of this if i give  :  00 20 * * 3,7 /app/oracle/rman/scripts/hot_db_*.sh then it will works fine or not ? 2.

Already my backup will create .output file in the same location , do i need to give output file location in crontab using ( > ) ? 3.

Is the above crontab timing is correct ? (3,7) for Wednesday and Sunday 8pm? so Sunday is 0(zero) or 7 ?

View 6 Replies View Related

RMAN :: Duplicate Database Can't Read Backup-piece Location

Aug 28, 2013

Oracle 5I am creating a duplicate database using RMAN based on Oracle's documentation. I was successful up to running the duplicate command.Here is my command:DUPLICATE TARGET DATABASE vlab pfile='/<complete path of pfile>'; When I run the command, it tries to read from the backup files on production database - which is on anotehr node.Before then, I had backup piece copied to the node with the duplicate database.I ran this command to catalog the backup piece:catalog start with '/<complete path to backuppiece>'Error: no files to be unknown to the database On the other hand, when I run the command without cataloging the backuppiece, I get this error:

Partial view of error- restoring datafile 00021 to /oraappl/pca/vptch/vlabdata/staff101.dbf restoring datafile 00022 to /oraappl/pca/vptch/vlabdata/staff201.dbf restoring datafile 00023 to /oraappl/pca/vptch/vlabdata/tools01.dbf restoring datafile 00024 to /oraappl/pca/vptch/vlabdata/vol01.dbf restoring datafile 00025 to /oraappl/pca/vptch/vlabdata/volsup101.dbf restoring datafile 00026 to /oraappl/pca/vptch/vlabdata/volsup201.dbf channel ORA_AUX_DISK_1: reading from backup piece /oraappl/pca/backups/weekly/vproddat ackupset/2013_08_27/o1_mf_nnndf_TAG20130827T083750_91s7dz0r_.bkp ORA-19870: error reading backup piece /oraappl/pca/backups/weekly/vproddata/rman/VPROD 3_08_27/o1_mf_nnndf_TAG20130827T083750_91s7dz0r_.bkp ORA-19505: failed to identify file "/oraappl/pca/backups/weekly/vproddata/rman/VPROD/b


View 3 Replies View Related

RMAN :: 10G Compression - Default Features

Oct 18, 2013

What are the default features available along with 10g R2 Enterprise Edition , Especially for RMAN Backup ? What are the features required for licensing in 10g R2 EE version .

View 2 Replies View Related

Rman Restore On 11g?

May 15, 2011

I have some problem while restore the database in separate environment.

This My backup policy and retention

I have monthly full database backup on march the backup started 2nd march 15:31 and completed at 03 march 11:12 AM retention period 3 years

We have ADHOC ARCHIVE backup which will run for certain conditions if the file system threshold reach 80%

In between the monthly backup the ADHOC ARCHIVE jobs has executed from 03Mar2011 00:00 to 03Mar2011 05:14 this retention period is 30 days

So while restore the database with monthly backup i can't able to recover the the datafiles due to adhoc archive files are missing.

View 4 Replies View Related

RMAN :: Restore Set New Name

Feb 6, 2013

We are cloning a database, but using the restore method ( version The source and destination path are different. As we are using the source controlfile, before restoration SET new name inside the run block is the way to change the path.

I was just wondering, if there is any other way to do it. Because, we have around 1000 datafiles, and dont want write everything in the run block. Also, this goes from Non-ASM to ASM. I tried DB_FILE_NAME_CONVERT, but it seems to be not working.

Set newname for datafile 1 to '+DATA_DG1';
Set newname for datafile 2 to '+DATA_DG1';
Set newname for datafile 3 to '+DATA_DG1';
Set newname for datafile 4 to '+DATA_DG1';
restore database;
switch datafile all;

View 3 Replies View Related

RMAN Backup And Restore

Oct 15, 2010

create a backupset, tag it, and restore it. You could say that what I'm trying to achieve is analogous to a flashback, but rather than specifying a timestamp, I'd like to simply restore the entire db to exactly what was there when the tagged backup was taken.Here is the RMAN script I am using for the backup procedure:

run {
#allocate channels
#backup database

I'd like to take these backups in online mode, and I've tried taking both a consistent and inconsistent backup modifying the above script.Additionally, I'm using the following restore script to try to revert the database to the state when the backup set was taken (and am testing the data being restored by deleting some data entries after taking the backup):

run {
#shutdown db (should be done already)
#mount db
#show RMAN settings

When performing the restore, I dont see the data backed up, rather I see the latest data still in the database. why the state of the db is not getting reverted to the backupset with tag='latest'.Finally, here below I've listed the rman settings for reference:

RMAN> show all;
RMAN configuration parameters for database with db_unique_name ### are:

View 10 Replies View Related

RMAN :: Restore Asm To Same Folder?

Apr 11, 2013

I am in process of restoring database for a standby.When I am restoring datafiles, it says it is restoring to an original location (same as primary database).

restoring datafile 00242 to +MYDB_DATADG/mydb/datafile/data_05.474.805989155 but when I checked with asmcmd utility, it is actually another path/filename. Only same thing is the diskgroup name.

So the file would be
-> +MYDB_DATADG/mydb_stby/datafile/data_05.281.812429111

How do I force rman to restore to the same exact location as my primary database?

View 3 Replies View Related

RMAN :: Archivelog Restore

Feb 21, 2013

i have changed the log_archive_dest_1 to another drive (suppose D ) than Oracle installed disk

created tables in scott ,
alter system switch logfile;

so archive log was der in the new destination i delete that archivelog from D and pasted to drive E ( cut paste ) start rman , crosschecked archivelogs Now , i want to tell Rman that recover that archivelog from E and then recover

win 7

View 5 Replies View Related

RMAN - Physical Standby Restore

Nov 5, 2010

I am trying to duplicate an Database and create an Physical Standby through following command

I took the backup through rman using the following command on Monday

RMAN> run
2> {
7> backup database format 'E:DB_FULL\DB1_FULL_%U';
8> backup archivelog all format 'E:DB_FULL\DB1_FULL_%U';
9> backup current controlfile for standby format 'E:DB_FULL\DB1_FULL_%U';
10> }

Today i am trying to clone the DB1 Database as physical standby ...

using the following command


Then I exceuted the following command

> duplicate target database for standby dorecover;

but i am getting error RMAN-06024: no backup or copy of the control file found to restore

contents of Memory Script:
set until scn 11182084819076;
restore standby controlfile;
sql clone 'alter database mount standby database';
executing Memory Script

executing command: SET until clause

Starting restore at 05-NOV-10
using channel ORA_AUX_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/05/2010 15:45:30
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

i even tried to switch the log file of the primary database DB1 but no avail,

View 4 Replies View Related

RMAN Restore In Standard From Enterprise

Jul 30, 2012

i can do a rman restore from 9i Enterprise to 9i Standard?

View 2 Replies View Related

Backup & Recovery :: Restore With RMAN

Feb 14, 2011

I have to test a hot rman backup on testing environment and I have some doubts.

Server 1
production database (linux)
backup folder on cifs share windows server
Server 2
testing database (linux)

First I installed linux on same network, I gave it access to cifs backup resource, then I installed the same database version than production environment, then I create a typical database with only same database production name. Also the Linux partitions between linux servers are different.

What oracle procedure must I apply?

View 1 Replies View Related

RMAN :: How To Restore Corrupted Database

Dec 19, 2012

We have Oracle database installed on Itanium server.

1. One day we found some packages got invalid & not compiling at all with error – ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], [].

2. Then we successfully restored the database from old RMAN backup of previous date that caused this error.

3. After 2 days again we found the same error in alert_prd log - ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], [] ORA-06512: at "SYS.DBMS_STATS", line 19089 ], [], [], [], [], [], [], []     

4. Then for testing we exported database using exp command & found 3 tables are not exporting because of data block corruption issue.

5. Then we truncated the data from all 3 tables and then able to export successfully.

6. After all this we manually run SYS.DMS_STATS job but found same error logged in prd_alert log.

This looks like, still database block corruption issue is there & we are unable to cure it 100% This is a production system & in very critical state now.

View 1 Replies View Related

RMAN :: Restore Backup In Different Database On Same RAC

Nov 6, 2013

We have 11gR2 2 node RAC on Linux. ASM and OMF is used for database. The database on it is backed up using RMAN. We want to test the RMAN backup by restoring it to a new database on same server.

View 5 Replies View Related

RMAN :: How To Restore Lost Database

Sep 13, 2012

i was worked on oracle 11g.1, oracle data miner, sql developer 3.

unfortunately, after finishing my tables and models ,the hard disk damaged and was replaced with other.the oracle setup was not on system partition,it was on D:/ and i had windows backup for C, D partition. i restored oracle partition D which contains old oracle files and i installed oracle again but on partition F.

now....how can i restore tables and modules?

View 3 Replies View Related

Backup & Recovery :: RMAN Restore Off Autobackup

Nov 1, 2013

I want to restore my database from server x to server y.

The control files on server x are named [$ORACLE_SID]_control01.ctl and [$ORACLE_SID]_control02.ctl.

We have an auto backup of the control files.

When I restore the control files on host y, (from autobackup) the restored controle files have other names: control01.ctl and control02.ctl. After the restore and recover (which goes well) the database does not start correctly.

SQL> ORACLE instance started.

Total System Global Area 626327552 bytes
Fixed Size 2224088 bytes
Variable Size 411041832 bytes
Database Buffers 205520896 bytes
Redo Buffers 7540736 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/data/coda/coda_system01.dbf'
ORA-01202: wrong incarnation of this file - wrong creation time

View 11 Replies View Related

Backup & Recovery :: RMAN Restore To Another Device

Mar 7, 2012

I have on PC running Windows Server 2003 named "Host A" and another Windows Server 2003 named "Host B".I made a Backup from Host A and want to restore this on Host B with following procedure.

Prepare & Backup:

But when i now try to access the Database Control i got following Error:„503 Service Unavailable: Servlet error an exception occurred the current application deployment descriptor do not allow for including it in this response" and the restored Datas are not included.

View 2 Replies View Related

RMAN :: Backup Restore Instance And Tablespace

Apr 18, 2013

We are managing a huge amount of data warehouse on oracle We need to take backup using rman of some tablespace not the whole database backup.
we need a backup strategy in which we can restore the backup of some tablespace plus oracle instance if any disaster occur.

I have taken backup using rman on test db of system , sysaux , user tablespace then i restore these tablespace successfully and make the remaining tablespace offline , but while open the database it show me below error.

My question is how i backup using rman so that in case of disaster i restore oracle instance plus specific tablespace not full database.

ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup

View 2 Replies View Related

RMAN :: Oracle 11g Restore Prior To Resetlogs

Feb 27, 2013

On database A we have full backups (not incrementals) every morning at 3:00 AM including archive logs. When I query rman (list backup) I see the full at 3 AM (in two backup pieces, each in its own backup set) as well as the backup piece containing archive logs through 9:00 AM.

Due to a data issue at around 10AM, I attempted to do an incomplete recovery to 8:00 AM (data loss is not a concern) - once this was complete I opened the database with resetlogs.

I subsequently discovered that the data issue had occurred closer to 6:00 AM and I am now trying to restore to 5:00 AM. This is failing with the 'UNTIL TIME IS BEFORE RESETLOGS' error. I read up on incarnations, but my previous incarnation is from November, and when I reset the database to this incarnation and attempt a restore I get datafile 1 (2,3) is not available for restore.

how do I basically just restore the full 3:00 AM backup and apply the archive logs through 5:00 AM? Do I need to do a recover until cancel or something? And should I reset the incarnation?

View 13 Replies View Related

Restore Of RMAN Backup Into Duplicate Database

Oct 5, 2013

I am running into a strange issue with a restore of an RMAN backup into a duplicate database,. 

1). I restored the control file from a recent backup.
 2). restored the datafiles ( about 800) 

Now when doing a recover, its giving me an error of Future recovery of a datafile marked datafile marked 350.

View 1 Replies View Related

RMAN :: Restore / Recovery From Snapshot Faster?

Aug 8, 2012

Version : 11.2 on Solaris, AIX

All our production DBs are backed up by some Hitachi tool (apparently it is called ShadowImage) . Apparently they put all the tablespaces in Backup mode and 'take a snap' . Our BAU team says this is faster.

On an event of DB Crash Is it easier to restore, recover from these 'snapshots' ? Are these snapshots much faster than RMAN ?

View 3 Replies View Related

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