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


ADVERTISEMENT

Backup & Recovery :: Restore And Recover Database Excluding Tablespace

Jul 27, 2011

I am doing some test, seeking your expert opinion.I have a database and have the following backup strategy.

1) Database running in archive log mode.
2) First I backup all the table space excluding one tablespace 'DP_TS_LOB'.

RMAN> CONFIGURE EXCLUDE FOR TABLESPACE 'DP_TS_LOBS';
RMAN> BACKUP DATABASE;

3) I take a separate Backup of DP_TS_LOB tablespace.

RMAN> BACKUP TABLESPACE DP_TS_LOB;

4) I backup all the archived redo logs.

RMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
RMAN> backup archivelog all delete input;

Now I wanted to restore the database from the backup excluding the DP_TS_LOB and bring it up and running. DP_TS_LOB is huge and used only on certain work flows. I don't want the database to be down until we restore DP_TS_LOB. I wanted to restore all the other tablespace and bring the database up operational and restore and recover the DP_TS_LOB tablespace datafile's in background taking the datafiles of DP_TS_LOB tablespace offline.I tried the following but unsuccessful.

RMAN> restore controlfile to 'g:ctl_bckctl_01' from autobackup;
RMAN> restore spfile to 'g:ctl_bckspfile' from autobackup;
RMAN> sql "create PFILE = ''G:ctl_bckPFILE'' from SPFILE = ''G:ctl_bckSPFILE''";

Update the new parameter with new control file name. Copied the control file and parameter file to corresponding location.

RMAN> startup nomount pfile=D:appdivaproduct11.1.0db_1databasepfile;
RMAN> restore database skip tablespace 'dp_ts_lob';
RMAN> alter database mount;
RMAN> sql 'alter database datafile 8 offline'; ==> datafile of DP_TS_LOB tablespace.

First I assumed "Recover Database" will only recover online database files. But got the following error.

RMAN> recover database;

Starting recover at 27-JUL-11
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/27/2011 18:23:03
RMAN-06094: datafile 8 must be restored

Then I tried recovering data file separately, but same error.

RMAN> recover datafile 1;

Starting recover at 27-JUL-11
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/27/2011 18:24:30
RMAN-06067: RECOVER DATABASE required with a backup or created control file

View 4 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 :: 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 :: 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 :: Incremental Backup Level 1 Or Level 0 Without Archivelogs?

Oct 22, 2012

Can you take an incremental backup level 1 or level 0 without archivelogs?

syntax would bebackup as compressed backupset cummulative level 1 database.

The reason I ask is because when I run backup as compressed backupset cummulative level 1 database plus archivelogs # it runs fine, but when I run backup as compressed backupset cummulative level 1 database it just hangs.

View 20 Replies View Related

Backup & Recovery :: RMAN Recovery Failing With Incremental Level 0 Backup

Feb 10, 2011

We are trying to restore a database on the different server using RAM incremental level 0 and 1 backups. We have weekly Incremental level 0 backups along with incremental backups on daily basis. During recovery of Incremental level 0 backup, RMAN is expecting/looking for Incremental Level 0 backup of prior week as well. Is this the usual process for RMAN to look for prior level 0 backup though we need to restore from the current level 0 backup and roll forward by a week with subsequent Level 1 backup.?

We intend to restore from the Level 0 of 1/16 and roll forward with daily incrementals till 1/22. RMAN is expecting level 0 backupsets from 1/9 backup as well and keep failing since those backups are not available. quick inputs since we are in middle of recovery and trying to resolve if this is even doable.

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

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

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

Backup & Recovery :: Timezone And SET UNTIL For Recover

May 15, 2011

I'm in the process of testing a restore/recover from a simulated full system and media loss. A level 0 backup was taken from the server, and I'm trying to restore/recover to a point in time on a second server. I have created the database (with the same name) and have been able to successfully restore both the controlfile and spfile from the autobackup.

how does RMAN treat the "set until time"? The level 0 was taken on a database/server that is in CST while the database I'm trying to do a restore/ recover to is in EST. So when trying to do a point in time recovery, should I specify the time in EST or CST?

View 2 Replies View Related

Backup & Recovery :: Recover Table Which Truncated

Jun 11, 2012

How to recover a table which truncate incautiously?

View 7 Replies View Related

Backup & Recovery :: How To Recover Truncated Table

Apr 20, 2011

One of our programmer/user accidentally truncated 2 tables in production. The dB is in NO ARCHIVELOG MODE.

How can we restore records of the 2 tables?

View 9 Replies View Related

Backup & Recovery :: How To Recover Database Having Only DBF And CTL Files

Oct 15, 2013

I have the following situation: a customer sent me a group of files, that he said to be a "backup" of an old database, that is no longer online (he doesn´t use our software anymore). However, he needs to recover the data in this database. The person at the company who generate these files doesn´t work there anymore, so we don´t have any of the following information:

- Database version, connection details, service names, user names neither tablespace names.

We were just told that these files were recorded in a DVD, and is que only source remaining.
The files he sent are the following:

ctrlcf_satp_01.ctl
ctrlcf_satp_02.ctl
ctrlcf_satp_03.ctl
daddf_satp_dad_01.dbf
[code]......

Is there a way to access this data? Or can I tell our costumer that your data is lost forever..

View 4 Replies View Related

Backup & Recovery :: Recover Data From DBF Files?

Feb 24, 2013

My server hard disc crashed yesterday and i don't have any backups.

I am able to recover the .dbf files by using a recovery tool.

is it possible to use this .dbf files into new server and recover my data.

View 5 Replies View Related







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