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
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
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
Aug 24, 2011
i need to restore a database on another database with another SID.
View 1 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
