To Restore Database To Last Week

Dec 31, 2012

I am running 10g on Linux, and last week someone messed up a database and it needs to be restored to 27 December. I am not a DBA, out regular DBA is on vacation till mid January,

I know we have archivelog on (I can see .arc files for the database), and I also have a backup of the actual data files and control files from when the database was first created. So in other words, I have all archive files and the initial data files. What i do not know is how to set the restore till December 27.

View 8 Replies


ADVERTISEMENT

Restore Recent Backed Up Control File And Then Restore The Database?

May 6, 2013

The controlfiles were corrupted due to some issue. So, I had to restore the recent backed up control file and then restore the database.

The weird thing which I have noticed is that. I tried backing up Yesterday's Control file. So, I would say that the backup pieces it should pick should be from yesterday. however, the backup pieces are getting restored from last week's backup.

View 3 Replies View Related

Possible To Restore Database Only Using RESTORE Command?

Dec 4, 2012

It's possible to restore a database only using the RESTORE command? (without use the recovery process)?I trying to do this using the commands:

RMAN> backup database;
RMAN> backup current contolfile;
RMAN> shutdown immediate;
RMAN> startup nomount;
RMAN> restore controlfile from '/opt/oracle/flash_recovery_area/ORCL/backupset/2012_12_04/o1_mf_ncnnf_TAG20121204T2555832_8cx71t4j_.bkp';
RMAN> restore database;
RMAN> alter database open resetlogs;
[code]....

View 2 Replies View Related

Backup & Recovery :: Restore A Database On Another Database With Another SID?

Aug 24, 2011

i need to restore a database on another database with another SID.

View 1 Replies View Related

How To Restore A Database Using Impdp

Oct 5, 2012

I'm a SQL DBA, so pretty new to Oracle.

I'm trying to restore a database using impdp (it was created using expdp).

Here's my impdp statement:

CODEimpdp system/oracle full=y directory=ATA_PUMP_IR dumpfile=IRISexp%U.dmp remap_datafile=/'+PDATA/iris/datafile/undotbs2.302.699230857/':\'D:\NickL\App\oradata\DT_IRIS_EXPORT_2012\DATAFILE\undotbs2.302.699230857'/

This is the error I get:

CODEORA-39083: Object type TABLESPACE failed to create with error:

ORA-01276: Cannot add file +PATA/iris/datafile/undotbs2.302.6992308597. File has an Oracle Managed Files files name.

View 1 Replies View Related

Restore Database After Installation

Jul 20, 2012

I have a quick question : -

Usually you install and create a database in one go using dbca.

Now you have the option of only installing oracle and then say next day create the database still using DBCA.

My question is how do you restore the database on another host on a machine which has only oracle software installed and no database installed.

well can a re-direct restore do the job ?

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

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

RMAN :: How To Restore Corrupted Database

Dec 19, 2012

We have Oracle 10.2.0.3 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 11.1.0.4, 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

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

Error While Backup And Restore Database To New Host?

Jul 22, 2011

I have 2 server install oracle : server 1 and server 2

server 1 run database DB01

i use rman backup DB01 ( this command : BACKUP FULL DATABASE PLUS ARCHIVELOG DELETE INPUT; ) and move ( The database backup pieces , Controlfile backup piece, The parameter file i.e init.ora file) to server 2 .

At server 2 :

After start database with init.ora file and restore controlfile error :

RMAN-03002: failure of restore command at 07/22/2011 02:56:04
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

View 1 Replies View Related

Server Administration :: Restore And Recover Database?

Oct 21, 2010

I create a test database which is duplicate of my production server and after every 15 or 20 days I need to synchronize test db with production db.So I clone it and it takes about a day.I have to remove all datafiles from test and move from production to there on test server and I applied restore and recover.So it is very time consuming process.

I want to know is there any process which makes my work less like I just need to apply all rest of the logs which are new after synchronize last time from production server that need restore and recover.

View 6 Replies View Related

Backup & Recovery :: Restore Oracle Database

Feb 12, 2012

I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?

View 1 Replies View Related

Backup & Recovery :: Restore Datafiles In Another Database

Jun 29, 2011

Can we restore a database if we have only the datafiles available? The database has been dropped but we have just the datafiles with NO system, sysaux,users and undo datafiles that were saved after taking the database offline and then dropping the database. I know this is strange but if possible, I want to see if we can retrieve some of the data from those datafiles to another database. BTW, There is no backup available for this database except the dbf files on OS.

View 3 Replies View Related

Backup & Recovery :: Partly Restore A Database?

Mar 21, 2012

I have a task which is to get an export of an account.Easy, you will say, use Data Pump but I have not the database only a complete RMAN backup of it (including control file and spfile). Easy once again, restore the database and export but I have not the space to restore the complete database.

all segments of the account are in a couple of tablespaces I know the name (and I know I have space enough to restore them).

Unfortunately, I don't know the other tablespace names (but of course SYSTEM and SYSAUX), in particular I don't know the name of the undo tablespace and, of course, I have no connection with the source database and no way to know these tablespace names.

So here's the question, how can I restore part of the database (SYSTEM, SYSAUX, undo tablespace and a couple of other ones) from a complete backup without knowing the name of the undo tablespace and of the tablespaces I don't need?

View 5 Replies View Related

2 Identical Database - Creating Script From DB1 And Run It To Restore DB2

Dec 27, 2010

We have a 2 database identical ( Say DB1 & DB2). In that, one of the database(DB2) base got corrupted. We cant recover back the database due to hard disk problem. So we did a new installation of database and patched to current level.

Now I want make DB2 up and running. So I though of generating a script from DB1 and run it in DB2 to restore back.

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

Restore A Database Into A Server With Fewer Memory?

May 12, 2013

I'm running Oracle 11.2g enterprise and we have a database on a server. We want to take a backup from this database and restore it in another database with fewer memory. In restore procedure after edition of pfile I try to restore controlfiles with my edited pfile(initdb.ora), but i'm getting an error related to memory shortage. So i decreased the amount of *.memory_target(3.5G to 2.5G) and the restore procedure continued. At the end when i try to Open database(alter database open resetlogs) i got the following error and the database does not work normally.

RMAN> alter database open resetlogs
database opened
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT row
s
ORACLE error from target database:
ORA-06553: Please-801: internal error [56319]
ORA-00604:error occurred at recursive sql level 1.

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 And Recover Tablespace (s) In Another Database

Dec 3, 2012

I'm using Oracle Standard edition 11gR2, actually that's why I'm posting this thread because I can't use TRANSPORT TABLESPACE feature.

I need to restore and recover two tablespaces, backed up in source database in another database. The destination db has been duplicated from the source db a couple of days ago so the structure is identical.

I cannot use Data Pump on this specific tablespace, because it causes some strange behavior in our application. So I took a backup from tablespaces and now I'm looking for a solution to restore and recover it in another db.

Is there any command to restore a tablespace from a specific file? I googled a lot and no luck so far..

P.S: I use controlfile instead of recovery catalog.

View 8 Replies View Related

Backup & Recovery :: Restore Database In Oracle 10g Enterprise?

Apr 13, 2011

I am new in oracle. I want to restore my database in oracle 10g enterprise. Actually i have a backup file(.bkp file) from oracle 10g xe and now i wanna restore in oracle 10g enterprise.

View 5 Replies View Related

Backup & Recovery :: Restore Database / Copied Archivelogs

Dec 14, 2011

Question: does oracle recover past the scn mentioned in the control file or do you need recover using backup control file for it? No specific scn,time specified.

Scenario: Restore database on new server + copy archivelogs from original to minimize data loss.
Backup : 5 AM
Archivelogs: 7 AM

New server:
Configure dummy instance
Restore spfile from tape
Restore controlfile from tape: SCN 5AM
Restore database (no scn specified) from tape: : SCN 5AM
Copy archivelogs from old server to archivelog new location: SCN 7AM.
Recover database
open database -> SCN 5AM or 7AM?

Does it recover till SCN 5AM (controlfile) or SCN 7AM (latest scn in copied archivelog)

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

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 Flashback Data Archive And Restore On New Database?

Oct 14, 2012

Is there anyway to backup Flashback Data Archive (FBDA) data and can be restore on new database. I cannot find Oracle's document or any document explain about backing up this data.

View 6 Replies View Related

Export/Import/SQL Loader :: Use Impdp To Restore To Different Database Name

Jun 20, 2012

Can I use impdp to restore to a different database name? If yes what is the syntax? This is 10.2 on linux.

View 2 Replies View Related

RMAN :: Ways To Restore Database To Point Time

Feb 21, 2013

i have oracle 11gr2 database on linux 5.5

i have the performed level 0 rman backup on 15th feb 2013, and after that i have incremental 1 and archives and controlfile backup. Before this no backup is the database.

Now i want to restore it to 12th feb 2013.so is there any ways to restore the database to that point time.can we restore controlfile to point in time.

View 5 Replies View Related







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