RMAN ASM Duplication Orphan Files?

Jun 10, 2011

I use the following script to duplicate a target to an auxiliary instance. This works fine once.

However if I run it a second time it will create a new set of datafiles leaving the original files in place taking up space.

Is there something that I can put in the script that will stop this happening.

I know I could probably put a "set newname for datafile" clause for each datafile in the target database, but this makes the script over complicated and I would like to keep it as generic as possible.

DUPLICATE TARGET DATABASE TO dupdb
until time "TO_DATE('07/06/2011 07:25','DD/MM/YYYY HH24:MI')"
LOGFILE GROUP 1 ('+DATA') SIZE 50M,
GROUP 2 ('+DATA') SIZE 50M,
GROUP 3 ('+DATA') SIZE 50M,
GROUP 4 ('+DATA') SIZE 50M;

View 2 Replies


ADVERTISEMENT

Database Duplication Via RMAN

Nov 11, 2011

I have 2 identical databases set up as follows:

- Version: Oracle 11gR2 (64 bit)
- OS: Windows Server 2008
- File System: ASM (with GRID Infrastructure)

Both instances are virtually identical... Same directory structures, same SYS passwords. The only thing that differs is the instance name (one is ABC, the other is XYZ).

Now, both databases are up and running, both have users on them, and both can accept remote connections. What I want to do is set up a very simple 'copy' system so that everything can be extracted (via RMAN) from the first database, and replace the database on the second. (Then, the user can log into XYZ with the same usernames/passwords they used on ABC.)

Here's what I'm doing so far:

On the 'source' database (ABC) I run RMAN as follows:
rman target / nocatalog
configure controlfile autobackup format for device type disk to 'C:\temp\CF_%F';
configure channel device type disk format 'C:\temp\bkp_%U';
run {backup database; backup archivelog all; }

Now, I'm not completely sure of what to do on the 'destination' database. I've seen multiple web pages with instructions that require the creation of a new instance using 'oradim' and the creation of a new password with 'orapwd'. However, is that necessary if I have the same sys password on both databases, and I want to use the same XYZ instance name on the destination machine?

Would it work if I used 'delete database' on the destination, and then used the RMAN 'Duplicate database to XYZ backup location 'C:\temp\'? Or does it HAVE to be a new instance created with oradim?

And if I DO have to use oradim to create a new instance, will the data be accessible through XYZ too?

View 2 Replies View Related

RMAN Duplication Of Active Database

Aug 5, 2011

I have issue with regards to duplication of an active (prod) database to a test database. This is my sql run by RMAN:

SPOOL MSGLOG to '/proddb/u01/app/dupe.log';

CONNECT target sys/oracle;
CONNECT auxiliary sys/oracle@MWTEST;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;
RUN {
duplicate target database to MWTEST from active database;
}
CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE;

It stops however in the middle and wouldn't continue. There is still huge space for the test database (3x the current size of prod database).

View 5 Replies View Related

Backup & Recovery :: RAC Database Duplication Using RMAN?

Jan 27, 2011

I have done many duplication before in sinlge instance databases using a backup tool and rman catalog. At the moment i was trying to do a RAC database duplication and facing some issues. For this i was doing a testing on my 1-node RAC. Primary and duplicated database is on the same Host and oracle version is 10.2.0.3. I perfomed following steps:

1.Created a DUPL database using DBCA.

2.Created a pfile using spfile.

3.Dropped all the datafiles, controlfiles and redo log files.

4.Started the database in nomount using pfile.

5.Disable cluster related parameters in pfile.

6.Took a full backup of the MAIN database with archivelog on disk.

6.Duplicate the database and it is done successfully.

7.Shutdown the instance and enabled cluster parameters.

8.Start instance using SRVCTL fails with error CRS-0215: Could not start resource 'ora.DUPL.DUPL1.inst'

But if start the instance using sqlplus it comes up nicely. There is not much information in alert log files.

View 13 Replies View Related

Recovery Manager (RMAN) :: Perform Active Database Duplication?

Sep 11, 2012

I like to duplicate the database DATABASEA to DATABASEB and need to be run in same server. I tried to bounce the listener & databaseb instance multiple times but no lucky.

Step 1 : The instance DATABASEB is in Nomount stage

Step 2 :

==> tnsping DATABASEB
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 11-SEP-2012 07:36:54
Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = client )(PORT = 1521)) (CONNECT_DATA = ( SERVER = DEDICATED) (SERVICE_NAME = DATABASEB)(UR=A)))
OK (10 msec)

Step 3 :

==> rman target sys/*****@DATABASEA auxiliary sys/********@DATABASEB
Recovery Manager: Release 11.2.0.2.0 - Production on Tue Sep 11 07:37:50 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DATABASEA (DBID=1723462779)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

[code]...

View 9 Replies View Related

Recovery Manager (RMAN) :: Backup-Based Duplication Without A Target And A Recovery Catalog Connection?

Sep 30, 2012

how to duplicate it on oracle 11g xe windows 2003

i have read from documentation but getting some error.

in last

E:Documents and SettingsAdministrator>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Sun Sep 30 03:03:09 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect auxiliary sys/12
connected to auxiliary database: XE (not mounted)
RMAN>
RMAN> DUPLICATE DATABASE TO xe

[code]...

Backup-Based Duplication Without a Target and a Recovery Catalog Connection?

View 6 Replies View Related

Data Guard :: ORA-19909 - Datafile 1 Belongs To Orphan Incarnation?

Jul 22, 2013

I have flash backed by primary database to an older SCN, from then on I am receiving the following errors on my standby database when I do media recovery :

 ERROR at line 1:ORA-00283: recovery session canceled due to errorsORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1:

'/u01/app/sbydb11g/system01.dbf'   PRIMARY DATABASE RMAN> list incarnation; List of Database IncarnationsDB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time------- ------- -------- ---------------- --- ---------- ----------1       1       ORCL     1343967574       PARENT  1          13-AUG-092       2       ORCL     1343967574       PARENT  754488     23-MAY-133       3       ORCL     1343967574       PARENT  1713927    14-JUN-134      

[code]...

View 2 Replies View Related

RMAN - Recover Files In Other Machine?

Dec 5, 2011

I have many backup sets of my database.

I need to recover a especific set of data, but where these data are. I thought of install oracle in a new machine and recover the backups one by one.

View 1 Replies View Related

Delete Archive Log Files Using RMAN

Jul 26, 2013

I am trying to remove archive log file on my standby site but I am getting the following message. There are lots of archive logs are present on the storage but rman is unable to displaying that.

RMAN> list archivelog all;

specification does not match any archived log in the repositoryRMAN> 

View 7 Replies View Related

RMAN :: How To Remove Database Files And Backup From ASM

Oct 19, 2012

Oracle Database 11.2.0.3
OEL 5.7

We have a host for restore purposes. We execute monthly or quarterly restore operations to verify that I am able to restore a subset of the data in the given amount of time or to other purposes. I have a automated script to Clone the Database, but to Clone Database we need remove the old database from ASM before start this operation. I want remove only Database files and keep the configuration (such as oratab/network/ocr and so on).

Question: There is a easy way to remove these files without connect on ASM or by using DBCA?

View 2 Replies View Related

RMAN :: Moving Backup Files From Disk

Jul 18, 2013

Accidentally without checking the channel allocation I have given the backup archivelog from sequence until sequence with delete input. This backup piece went to the disk but it should go to Tape.I know that we can catalog this backup piece but I want to move this backup files in disk to Tape using RMAN. Is there anyway or I have to lie with Backup team or OS team for this file movement?

View 4 Replies View Related

Backup & Recovery :: RMAN 10g - Restore Files From Tapes

May 8, 2013

Is it possible to recover files from backup tapes which are gone obsolete (as per retention policy)?

View 4 Replies View Related

Recovery Manager (RMAN) :: Taking Backup In 3 Files?

Mar 27, 2013

I took backup of Datafiles , archivelog files and controlfile through RMAN. Now, i want 3 backup file will created as a output of RMAN operation. It would be :

1 backupfile for all the datafiles
1 backupfile for all the archivelog files
1 backupfile for controlfile.

It have to be regardlessly whatevr my DB size is. It it possible to do so. How i can can write rman script to accomplish the task.

View 7 Replies View Related

RMAN :: Optimization - Ensure Skip Those Files Already Taken Backup

Feb 28, 2013

I would like to know that if I enable backup Optimization on then incremental full backup skip any files which was earlier backup? Because we may know that backup Optimization on ensure skip those files which are already taken backup.

Database : oracle 10g 10.2.0.3 .

View 4 Replies View Related

RMAN :: Change Database Name Control Files After Restore

Jul 12, 2012

I have restored database with the name DB to another database called DB01

it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it because of the name, how to solve this issue if possible? I have RMAN full backup from DB on my current server which hosting the database DB01 the initdb01.ora is ready and configured with DB01

what can I do next

ORA-01103: database name 'DB' in control file is not 'DB01'

View 5 Replies View Related

Backup & Recovery :: RMAN - Missing Archive Logs Files

Oct 7, 2012

We have a nightly rman backup that was complete and clean.The backup contains a Data File, Control File and a backup Archive Log file.The database server crashed with all the subsequent archive logs lost.

We are trying to recover from the three backup files.We are bumping into the backup piece missing as all the archive logs are done. how to restore with the exising backup files. the lost archive logs are probably salvageable.

View 9 Replies View Related

Resize Online Redolog Files And Make RMAN Absolute Backups As Usable?

Jun 19, 2013

why can not we resize online redolog files instead of re-creating the same with large size and remove the older onces.2. How can we make RMAN obsolute backups as usable ?

View 8 Replies View Related

RMAN :: Rc-datafile Mismatch Sizes - Column Bytes Shows Data Different From Real Of Files?

Sep 26, 2012

in my catalog database I see in Rc_datafile mismatch sizes - column bytes shows data different from the real sizes of files .

Does this view updated after copy of database into catalog ?

View 4 Replies View Related

Recovery Manager (RMAN) :: Possible To Make Recovery Of Deleted Files

Jan 6, 2013

I am making incremental backups via RMAN, the backups are staying at disk. And the infrastructure team will copy this files backups to tape. And they want delete the files that will staying in disk via RMAN. Until now it's ok.

But and if I need of backups that stay on tape, it's possible make a recovery of deleted files by rman.

View 3 Replies View Related

Database Duplication With Different DB ID And Oracle SID

Sep 3, 2010

I have the following question:

I try to duplicate a database on Host B with ORACLE_SID=hostb from an offline full backup plus archive log backup was taken from Host A with ORACLE_SID=hosta. Host A and Host B cannot communicate between them.

I don�t want to make a full restore of database, i want to make a duplicate database from that offline backup.

I need the duplicate database must be run with different ORACLE_SID and different DBID.

PD: I was reading the Oracle Documentation about that but i can�t find a step by step guide to follow.

Environment

Oracle 11gr2 with a Linux OS on x86_64 on host A and host B.

View 13 Replies View Related

SQL & PL/SQL :: Delete Duplication In A Table

Jul 7, 2011

I want to delete the duplicate rows in a table. there is no column which can be used to differentiate between the rows.

SELECT column_name1
FROM [table]
WHERE column_name2 = cond
GROUP BY column_name1
HAVING COUNT (column_name1) > 1

from the above query i can find the duplication in the table and can delete through it. But what i want one record of each duplication not to be deleted most probably the record added last to the table.

View 13 Replies View Related

Backup & Recovery :: RMAN Hot Backup Plus Archive Log Files?

Jan 11, 2008

I had a production db with archive logging enabled

SQL> select name,status
2 from v$archived_log;

NAME STATUS
---------------------------------------- -
D:ORACLEARCHIVE_ORCL11_13.DBF A
D:ORACLEARCHIVE_ORCL11_14.DBF A
D:ORACLEARCHIVE_ORCL11_15.DBF A

[code]...

So i need to restore archivelogs by using sequence

RMAN>RESTORE ARCHIVELOG FROM SEQUENCE 20 UNTIL SEQUENCE 28;
So the restore is completed successfully
So its very hard to monitor archivelog files
i feel i should have included all archivelog files while taking RMAN backup

RMAN >backup database plus archivelog all delete input;

but the problem is my RMAN backup is already 360GB in size and it takes 4-5 hrs to complete .so i need to schedule RMAN backup at one time (e.g sunday) ,delete the archivelog files older than sundayand now schedule the archivelog backup at another day (e.g wed &sat)

my question is where i have to change my script to backup all avaialbe archivelog files if old archivelog files are deleted at os level?

RMAN> run {
2> allocate channel c1 type disk;
3> sql 'alter system archive log current';
4> backup archivelog all format 'D:oracleackuplog_t%t_s%s_p%p' delete input;
5> release channel c1;
6> }

View 4 Replies View Related

CHARSET ORACLE Database Duplication?

Sep 22, 2010

Can i duplicate a database that is in a different CHARACTER SET?

If i can't made the duplication in a direct way, how can i convert or transform to duplicate a database from one character set o another?

View 7 Replies View Related

Forms :: Avoid Duplication In Three Tables

Jan 31, 2013

I'm creating oracle form to allow the user to register a new record in a table, I want to check the duplication in Four tables! which means, the user is able to save the record if it's NOT already registered in the other four tables.By checking P_ID (user parameter). this is my

Declare
v_count number;
begin
select count(*) into v_count ---Checking the 1st table
from 1_table
where p1_id=:p_id;
if (v_count>0) then
message ('Duplicate');
[code]....

View 4 Replies View Related

Oracle 11g Active Database Duplication?

Nov 2, 2011

I'm trying to set up Active Database Duplication between 2 Oracle 11g servers. Each server is identical, with the following characteristics:

- OS: Windows Server 2008
- Version: Ora11R2 (64 bit)
- DB Name: orcl
- Filesystem: asm (using grid infrastructure)

In addition, each server has been configured with the same sys passwords. The databases themselves were configured during installation (so the setups are about as basic as you can get.)

Now, I've done all sorts of research into how to do this. I've found plenty of good sources, but they seem to all have differences in the details.Here's what I've done so far:

- The TNSNames.ora file on each server has an entry for 'src' and 'dest' (sourca and destination) respectively
- I created an entry named 'SID_LIST_LISTENER' in the listner.ora file on the source machine. However, should the sid_name in this entry refer to the source or destination machine? Or does this listener entry belong on the destination machine instead?
- A lot of the examples require the setup of a new password file and spfile. Are these entries necessary if I'm using the same file structures/user names/etc. on both servers?

View 2 Replies View Related

Backup & Recovery :: 11g Active Database Duplication?

Nov 2, 2011

I'm trying to set up active database duplication between 2 Oracle 11g servers.

Both servers were set up with identical configurations (same directory structures, file systems, SIDs, and sys passwords.) Both oracle instances were created at the time of software installation.

Here is how things are configured:
- Version: Ora11gR2
- Oracle service name: orcl
- File system: ASM
- OS: Windows Server 2008

I've done some research and found several sources giving instructions on how to set up active database duplication (including a blog engry by rajabaskar on this site), but each site seems to have different details.

So, here's what I have so far:

- Set up entries in each TNSNames file... each has an entry 'src' and 'dst' (for source and destination)

- A new listener has been added on the source machine

- on the destination machine, run the 'oradm' to create a new SID. However, is this really necessary? Since the service names are already the same

- I'm also supposed to create a password file on the destination machine using orapwd. Again, is this necessary, if I'm using the same passwords on both machines?

Am I on the right track? Should I have created an actual database on the destination machine or should I have started with just the software installed?

View 1 Replies View Related

Forms :: New Record With Same ID Inserted Every Time - Duplication

Mar 4, 2013

I have a form that used to enter new employees , if the employee ID already registerd then the user can ONLY update the information and NOT adding the same ID with new info.

int the ID item in when-validat-item trigger I put this code

begin

IF :SOURCE_CODE IS NULL THEN MESSAGE('PLEASE ENTER SOURCE CODE');
ELSE
declare --chg#13-3169 nada

[Code].....

in the save button the code is : commit;

The problem Is : a new record with same ID is inserted every time !! Duplication is happining

View 6 Replies View Related

Precompilers, OCI & OCCI :: Make Files That Compile PC Files In Unix

Jul 31, 2008

I have written make files that compile .pc files in unix. This was for several projects that use an oralib source code directory.Just running proc on one target .pc file works fine on unix. I am trying to use proc - Oracle 10.2.0 - in windows and I keep getting:

Quote:unable to open include file
#include <stdio.h>
and other C library headers.

I am doing all development under cygwin, this way I can write a makefile just like under unix instead of using nmake.All C library headers are in /usr/include When I run proc on Solaris as that:

proc program.pc
No problems, and I do get program.c.

However in windows I get the previous error message. I have tried to do proc include=/user/include program.pc and proc include=/user/include parse=full program.pc but I still get the same error message.

View 3 Replies View Related

Know If Database Files Are On File System Or Raw Files?

Oct 11, 2012

How can I know if database files are on file system or raw files?

View 4 Replies View Related

Compare Two Dump Files And Their Respective Log Files

Jun 20, 2012

I want to compare two dump files and their respective log files, to see the difference. Is there any way.

View 8 Replies View Related







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