RMAN :: How To Restore Backup From A Server To A Test Server

Feb 27, 2013

I have two Solaris 5.11 x86 64 bit servers. I need to be able to copy the backup files to a temp location on the 2nd server and restore that server so it is a test version of the first server. There is no RMAN catalog, I simply want to backup on A move to B restore from files copied to b.

On the first server installed Oracle Enterprise 11.2.0.3. sid = orcl. i created one schema with a new table space added a table and inserted 500,000 rows.

i set the db to archivelog=on, set configure controlfile autobackup on

i then did RMAN backup as backupset database spfile;

on the second server, i installed Oracle Enterprise 11.2.03, sid=orcl exactly like i did on the first server.i scp'd all of the files created by the backup to one location on the test server. i renamed spfileorcl.ora in dbs to somethinge else. startup nomount, exit and go to rman and run this:

DUPLICATE DATABASE TO 'orcl' SPFILE BACKUP LOCATION '/tmp/backups' NOFILENAMECHECK;

this runs for a while and looks like it works but eventually fails with :

RMAN-05541: no archived logs found in target database

subsequent attempts to 'startup' the database receive the error ORA-19838: Cannot use this control file to open database.

This is very frustrating. I have gone over all of the manuals, documentation and more but there is no 'step by step' process that i can find that is current with my version of Oracle that documents the steps necessary to simply backup a db, move it to a test server to a disk and then restore that test server as a copy of the first server.

View 4 Replies


ADVERTISEMENT

Recovery Manager (RMAN) :: How To Test Restore In Another Server

Feb 19, 2013

I want to test full backup (hot backup using RMAN) of my DB (11.2 SE) on another server (I didn't install DB on yet).

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

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 :: Rman Restore On New Server - Set Newname Not Working?

Feb 14, 2012

I am trying to restore a backup from a live server to a dev server. Have moved nackup sets. Created a windows service to match the old sid on live system. copied the pfile from live and changed the locations of the folders to suit dev. set oracle_sid to the new sid(as created to match live)

connected to rman
startup nomount
set dbid to the live number
restore controlfile
alter database mount
catalog'd all the backupsets

[code]....

but it fails when it tries the restore .. see below ..The path it is showing is the old path from the live server, so it appears to eb ignoring my set newname statements even though they succeeded earlier - should be restoring them to d:oracleoradatasun43dev ? Does the whole thing have to be put inside one run block or can I put bits in one run block and other bits outside of it etc?

RMAN> restore database;

Starting restore at 14-FEB-12
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set

[code]....

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

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

RMAN :: Error When Restore Data From Server A To B

Sep 22, 2012

I have troubles when restore FULL BACKUP from server A to Server B . when i Backup Full from server A ,i copy that Backup files to Server B (aa new server),i restore spfile và control file from BK files,then i mount (alter database mount ) to restore database , it show error message ORA-01103:

database name 'ORCL' in control file is not 'DUMMY' ,

I tried to shutdown immediate and then startup mount again , but it show other error message

RMAN-04014: startup failed: ORA-00845: MEMORY_TARGET not supported on this system.

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

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

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 :: 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 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 :: 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 :: 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 :: How To Restore Database From Different Server

May 30, 2013

We have a database server running oracle 12G on linux which is the production then we have a DR using the same version of DB and linux, I want to restore from tape into the DR from the production backup. the UNIX admin has restored already from tape the rman backup, i would like to know what are the steps to restore the backup from tape, also the DR database server was created identical like production using the same spfile etc.

were do i copy restored file into on the DR server? also then in RMAN do i just start the DR database and run the command restore database? what else do i need?

View 7 Replies View Related

Backup & Recovery :: Restore Database From Another Server

Nov 14, 2011

I have taken cold back-up of a complete database using below rcv from a server.

RMAN>
connect target /
run{
set command id to 'bkp_EMCPROD_db';
allocate channel c1 type 'sbt_tape' parms="BLKSIZE=1048576, ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)";
backup current controlfile format 'ct_t%t_T%T_d%d_s%s.ctl';
backup database format 'db_t%t_T%T_d%d_s%s_p%p.db';
backup current controlfile format 'ct_t%t_T%T_d%d_s%s.ctl';
release channel c1;
}

I need to restore this back-up on another server of the same Database Name. Below is the rcv which my sr. dba asked me to look into for the restore.

/* From the new server to restore the back-up */
RMAN>
connect target "rman/xxxxx@emcprod"
connect auxiliary /
run {
set until time "to_date('Nov 03 2011 19:00:00','Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel c1 type 'sbt_tape' parms="ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.sacsun8.opt)";
restore database;
}

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

Feb 14, 2011

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

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

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:
SQLPLUS SYS AS SYSDBA
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP MOUNT
SQL>ALTER DATABASE ARCHIVELOG;
SQL>ALTER DATABASE OPEN;
SQL>ARCHIVE LOG LIST;
SQL>ALTER SYSTEM ARCHIVE LOG START;
SQL>QUIT
[code]...

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 11.2.0.3.0. 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
ORA-01110: data file 1: 'C:APPADMINISTRATORORADATASYSTEMSYSTEM01.DBF'

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

Backup & Recovery :: RMAN Incremental Backup Of Server

Jul 2, 2011

FIRST Question?

I have main database Server which is located on Server A, now I have to take the RMAN Backup of Server A and then shift the complete database on new Server B.

I am confused whether to use Backup command with AS COPY option or take the backup as backup sets. Which are the best option that I can use for the RMAN Backup.

View 22 Replies View Related

Backup & Recovery :: RMAN Tablespace Restore After One Year?

Jul 20, 2011

I have taken the backup of a tablespace using the below mentioned command.

run
{
allocate channel c1 device type disk;
backup tablespace tcs_tbs;
}

Now I after even after one month or one year I want to restore the backup on my same database to bring the tablespace to the previous position.

Is it possible to restore even after one year, Is retention period gonna play its role in this?

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







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