Replication :: Backup And Restore

Dec 6, 2007

I have various oracle database systems having version 10g. I need to resotre data(data,structure,tables,proc,package and all objects) from one database to another database very frequently. Currenlty using exp/imp utilities. I really would like to know any other tools/utilities can be used other than imp/exp and impd/expd utilities. Is there any way to use RMAN in this regard and all database DBF files ,sizes, tablespace names are different accros DB systems. Any way minize of restoration of dumps and can go for best method.

View 5 Replies


ADVERTISEMENT

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

Backup & Recovery :: RMAN Duplicate Set Until Time Using Wrong Backup Piece Name To Restore?

Feb 26, 2012

We are doing RMAN Duplicate set until time to refresh daily our test database for our developers and it taking long time to finish. We noticed on the restore log that RMAN was using a day old old backup pieces to refresh the test database and don't immediately use the latest backup pieces instead.

For additional details here's the rman duplicate command we are using which we run daily(mon-sat) at 4am once daily full backup on production completed.

RMAN Duplicate commands:
run
{
set until time "to_date(to_char(sysdate,'Mon DD YYYY') || ' 04:00:00', 'Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
duplicate target database to testdb;
}
exit

Is there a way on how to let RMAN use the latest backup pieces instead?

View 1 Replies View Related

Backup & Recovery :: Restore Dropped Or Wrongly Updated Table Using RMAN Backup?

Feb 9, 2011

Is it possible to restore dropped table OR wrongly updated table using RMAN backup.

View 18 Replies View Related

Backup & Recovery :: Restore RMAN Backup In New Server / Got Error 06172

Jun 21, 2011

We are using Oracle 10g R2 in Windows Server 2003. I'm trying to restore a database in a new server, using RMAN backups.

Our external consultant configured RMAN scripts for full and incremental backups but never tested them . Since he just doesn't show up, I'm forced to tested them, restoring the whole database in a new server.

My instance is named MTDPROD, and I will create all from scratch.

At current server, RMAN files are generated in:
//192.168.1.149/g$/XXXSRV4-ArcLogs/MTDPROD/RMAN

At new server, I run all these commands:

C:>oradim -new -sid MTDPROD -intpwd mtdprod
Instance created
-- I created the relevant folder hierarchy under <ORACLE_BASE>
directory
-- Then, I created the relevant directories for Oracle Database, as
follows:
--a. Create BDUMP, CDUMP, and UDUMP directories under '<ORACLE_ BASE>

[code]....

By instance, I see a lot of this kind of files:

- FULL_MTDPROD_20110529_386_1.BAK
- INCR_MTDPROD_20110621_480_7.BAK
And only see these two files:
- C-2169285856-20110527-03
- C-2169285856-20110527-04

It seems that this C-2169285856-.... files only were on 27/05/2011 and then no more. However, the FULL_... and INCR_.. files are generated every day. The FULL is generated at the end of each month and INCR is generated every day.

This is the backfull.sql:

run {
allocate channel c1 type disk maxpiecesize=4G;
CROSSCHECK archivelog all;
backup
incremental level 0
format '\192.168.1.149g$XXXSRV4-arclogsMTDPRODRMANFULL_

[code]....

This is the backincr.sql:

run {
allocate channel c1 type disk maxpiecesize=4G;
CROSSCHECK archivelog all;
backup
incremental level 1 cumulative
format '\192.168.1.149g$XXXSRV4-arclogsMTDPRODRMANINCR_
%d_%T_%s_%p.bak'

[code]....

View 6 Replies View Related

Inputs On RMAN Backup N Recovery For Multiple Restore Of Clean Backup?

Nov 7, 2010

We have the requirement of performance testing of our proposed production platform, for this i am asked to take RMAN backup of clean position (Say Day0 or baseline backup) and restore it multiple times for few rounds of testing. My question is after 1st restore (with set until time of day0 position) if i open the database with resetlogs, would i be able to restore same clean backup again? I am using control file in the environment instead of RMAN catalog database. What i can do to make this scenario work? I am already in preperation of setting rman catalog database.

View 3 Replies View Related

Backup & Recovery :: Restore Rman Backup On New Server As Different Name Sid / Service / Listener

Feb 13, 2012

I am attempting to use an rman backup form our live server to restore live data over an existing dev database with a different name. I cant use the duplicate command as the versions of oracle are different (10.2.0.4 EE on live, 10.2.0.5 SE on dev) So I copied the backup sets including an autobackup control file onto the dev server. I set the ORACLE_SID to the DEV version (SUN43DEV) and startup nomount and restore controlfile from the backup location. This works and restored the live controlfile. However, I then wanted to mount the database and catalog the backupsets before making a note of the last archivelog etc and restoring the backup with set newname options. But when I try to mount the database I am told that the database has a different name (SUN43 is not SUN43DEV). I read somewhere that I need to set the ORACLE_SID to the live value (SUN43) and restore as that, then use nid TO RESET THE DBID and DATABASE NAME. However, my tnsnames on DEV has no entry for the live database, and we do not have any service defined through ORADIM for the live instance on the dev server. Should I be creating an entry in DEV tnsnames that actually looks at the LIVE server? or do I need to create a service and tns entry etc for SUN43 on my DEV server pointing at the DEV server I have not seen any mention in instructions of creating a service or adding the entry to tnsnames, or indeed adding an entry to the listener for the original live sid. I am worried that if I actually point to the live server then the restore would be attempted on the live server not dev even though I am running it from Dev.

Also, do I need to drop the existing database on DEV before I restore or will RMAN just restore over the top of it?

Finally, if I try to add an entry to the LISTENER.ORA for the new sid, when I stop and start the listener, or reload, the entry is not recognised. I also noticed that the existing SUN43DEV entry is not in there either, yet I can still use that SID - I am assuming that is because the listener is not being used and the sid is recognised from the existence of the service in windows services instead?

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

Cause

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.

Solution

Workaround:

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 :: Restore Database From Obsolete Backup Using RMAN

Dec 13, 2011

can we restore database from obsolete backup using rman

View 2 Replies View Related

Backup & Recovery :: Restore / Recover Level 1 Backup On New Server

Jan 31, 2011

I am trying to create my database on a new server using rman incremental hot backups.

I have already restored and recovered my level 0 database on new server, but i am not able to restore/recover the level 1 backup on the new server. I have transported level 1 backup irom the old server to the new one. Do i need to recover lvl 1 bkp only or restore it also.

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.

RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS='...';
RESTORE SPFILE TO PFILE '?/oradata/test/inittrgta.ora' FROM AUTOBACKUP;
SHUTDOWN ABORT;
}

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 :: RMAN - Time Interval Backup And Restore?

Mar 27, 2012

I have been updating data in my database by adding numerous rows and assume the insertion of rows started from 1st date of january month.

I have been entering somehow or the other part of data every day.And now the date is 25th of january.

How can i take a partial backup of my database of the transactions done between 15th of January to 20th of January Month

How to take Backup of a particular date say it be 12th of january month.

How to take backup of first 10 days i.e., 1st-10th of january.

View 7 Replies View Related

Backup & Recovery :: Restore Incremental Backup To New Server?

Jan 31, 2011

n my last post I asked abt the issues that I was facing while restoring the full backup of RMAN on a new server. I mentioned the steps as well, Now my Question is what If I want to restore the incremental backup on the new server?

What all steps do I have to follow after restoring the zero level backup on a new server.

View 18 Replies View Related

Backup & Recovery :: How To Restore Full Backup On A Media

May 13, 2012

my restore scenario bellow.

I have hot full backup that processed by NetBackup Policy. the backup policy are;

1.Full backup database in Monday. Daily_Monday_RMAN <- 1 volume pool=1 media
2.Full backup database in Tuesday .Daily_Tuesday_RMAN <- 1 volume pool=1 media
3.Full backup database in Wednesday. Daily_Wednesday_RMAN <- 1 volume pool=1 media
4.Full backup database in Thursday. Daily_Thursday_RMAN <- 1 volume pool=1 media
5.Full backup database in Friday. Daily_Friday_RMAN <- 1 volume pool=1 media
6.Full backup database in Saturday. Daily_Saturday_RMAN <- 1 volume pool=1 media

How to restore database from one of medias?

View 5 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 :: Restore Fails On Archived Log Which Is In Backup Set?

Dec 2, 2011

I ran the Full database backup as,

RUN {ALLOCATE CHANNEL CH0 TYPE 'sbt_tape';
BACKUP DATABASE FORCE PLUS ARCHIVELOG FORCE NOT BACKED UP DELETE INPUT;
RELEASE CHANNEL CH0;
}

Then I ran the restore, it failed with Quote:RMAN-06054: media recovery requesting unknown archived log....

When I backup archivelogs and choose to delete the input, it does not delete the multiplexed copy, but the specific file being backed up.So, ideally it should find it in Flah Area or at least in the backed up pieces which are there with it.Still why is it failing?

Also, in recovery, it is deleting the archived log after applying, RMAN does this if we use recover... delete archivelog command.I am using only RECOVER, still in output I can see RMAN deleting the log after it has applied it. WHY?

View 3 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 :: RMAN Tablespace Backup And Restore?

Sep 7, 2012

i want to clone the test db to dev db but i dont want default users and tablespaces(SYS,SYSAUX,...) in the test db datapump and exp are not working, then contacted ORACLE support and they concluded that test db sysaux was corrupted.i took RMAN all tablespace bkup except default tablespaces. then created new database using DBCA and now i want to restore and recover all those test db tablesapces but while i'm doing restore its saying

RMAN> restore tablespace MAIN_DATA;

Starting restore at 07-SEP-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=129 device type=DISK
creating datafile file number=20 name=/opt/oracle/oradata/DEV71/main_data01.dbf
restore not done; all files read only, offline, or already restored
Finished restore at 07-SEP-12

i created all tablespaces in dev same as test db,

View 6 Replies View Related

Backup & Recovery :: Backup And Restore On Different Server?

Jun 14, 2013

I would like get a copy of an oracle 10g database off the production server(windows 2003) and set it up on Windows 2003 virtual server to use for dev/testing.

What would be the safest and most efficient way.??

View 2 Replies View Related

Backup & Recovery :: Restore Backup At New Machine?

Nov 7, 2012

We need to migrate database from old machine to new machine. This is because our SAN storage need to be change due to file system.

Old machine setup with RAC and using 10g. Is it possible i restore at single machine only? The backup on the NAS. SAN act as ASM only.

View 1 Replies View Related

Backup & Recovery :: Restore Backup Of Database A From Into B

Jun 16, 2013

I need to restore a backup of database A from into Database B. Both have the same names. Database B is already up and running.

I have a full rman backup of Database A ( it was taken with a recovery catalog which I don't have access to now as it was deleted ). I just have the full backup pieces including the control files. Is it possible to recover this database into Database B from this stand point.

I was thinking

2. Shutdown database B
3. Mount database B. It has same name as Database A.
4. With RMAN restore controlfile. Will a new controlfile be created from the backup directory I have the rman pieces for the full backup in ?

View 9 Replies View Related

Replication :: How To Use Replication For Backup

Dec 3, 2007

We have two ORACLE-Standard-Edition installations, one is installed on a machine in our production department and one is installed on an central server. We want to replicate the data from the production-DB to the central server to backup the data on tape drives.

Is this possible using the feature of standard edition?

View 9 Replies View Related

Backup And Restore From Tar

Jul 14, 2013

I wanted to backup my entire database using tar and then recover it from the compressed tar, what directories I should backup using tar? As well as how would I restore it?

View 2 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
#ALLOCATE CHANNEL FOR DEVICE TYPE DISK;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
#backup database
BACKUP FULL DATABASE TAG='latest' PLUS ARCHIVELOG TAG='latest' DELETE INPUT;
[code]....

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)
SHUTDOWN IMMEDIATE;
#mount db
STARTUP NOMOUNT;
#show RMAN settings
SHOW ALL;
[code]...

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:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
[code]...

View 10 Replies View Related

Backup & Recovery :: Restore Asm To No-asm?

Jan 8, 2012

My product db is a RAC entironment with ASM,Now i backup my db using Rman,and want to restore to a test db with just as a node with no-asm,how can i do?

View 4 Replies View Related

Restore Database From Backup Using Emc Bcv Technology?

Oct 15, 2010

can we restore oracle database using backup using emc bcv technology? i dont have experience with bcv.

View 1 Replies View Related

Backup And Restore Don't Work In Oracle

Mar 22, 2011

I try this for backup:

$ exp scott/tiger FULL=y FILE='d:\demo.dmp';

and this for restore:

$ imp scott/tiger FULL=y FILE='d:\demo.dmp';

and after restore i can't see the data in my tables. (i work on Oracle 11.2.0 64bit)

View 2 Replies View Related

Restore Backup Without Control File

Sep 11, 2011

I have a problem with my control file [URL].........

What I did, I have a duplicate of the database with the invalid control file, let's call it DUMDB. I am using my control file and no recovery-catalog-db.

I recreated the control file. Now everything is working fine, new backups can be taken, restores can be made. I just need to restore a backup tagged with "LASTDEV". The control file for this backup is the invalid one. So I need a restore WITHOUT restoring the control file.

I did:

CODERMAN> catalog backuppiece '/u03/flash_recovery_area/DUMDB/backupset/o1_mf_nnndf_LASTDEV_75fmkllw_.bkp';
cataloged backup piece
backup piece handle=/u03/flash_recovery_area/DUMDB/backupset/o1_mf_nnndf_LASTDEV_75fmkllw_.bkp RECID=1 STAMP=761604017
CODERMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    2.77G      DISK        00:00:00     26-AUG-11
        BP Key: 1   Status: AVAILABLE  Compressed: YES  Tag: LASTDEV
        Piece Name: /u03/flash_recovery_area/DUMDB/backupset/o1_mf_nnndf_LASTDEV_75fmkllw_.bkp

  List of Datafiles in backup set 1
===========================
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 63166185   26-AUG-11 /u02/oradata/dumdb/system01.dbf
  2       Full 63166185   26-AUG-11 /u02/oradata/dumdb/sysaux01.dbf
  3       Full 63166185   26-AUG-11 /u02/oradata/dumdb/undotbs01.dbf
  5       Full 63166185   26-AUG-11 /u02/oradata/dumdb/stdtbs01.dbf
  6       Full 63166185   26-AUG-11 /u02/oradata/dumdb/users.dbf

CODERMAN> crosscheck backupset 1;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u03/flash_recovery_area/DUMDB/backupset/o1_mf_nnndf_LASTDEV_75fmkllw_.bkp RECID=1 STAMP=761603187
Crosschecked 1 objects

CODERMAN> RESTORE DATABASE FROM TAG='LASTDEV';

Starting restore at 11-SEP-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/11/2011 20:32:25
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

This is exactly the same message if you do "RESTORE DATABASE FROM TAG='NONEXISTENTDUMMYTAGXXXX'"
Why can the data files not be found even if they are listed in the backup?

I am on 11.2.0.2.0 on Linux64.

View 1 Replies View Related

Backup & Recovery :: Restore With Archive Log Only

Aug 9, 2013

We have a 9.2.8.0 database in archive log mode. We want to restore that db to a specified point in time. What is the fastest way to do it ?

View 3 Replies View Related

To Restore Database From A Cold Backup

Feb 28, 2013

I've got a database I need to restore from a cold backup, but I don't have a copy of the multiplexed members of the redo groups - each group has 2 members, and we've only got a backup of the first.

I know this won't stop the database from starting, and I can recreate them, but for ease can you copy and rename a redo log file from a multiplexed copy to correct location like you can with a control file?

View 2 Replies View Related







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