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 ?
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.
we have a running Oracle 8i in NT 2000 since year 2004, now we have a new Machine onto which we install a fresh copy of OS and also fresh Installation of Oracle. but..i want to have all those settings, users, database as it is running. i am creating regular dumps of the current database running.
View 4 Replies View RelatedIt'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]....
My question is; I've been reading the Oracle database 11g R2 documentation at this link [URL]...
I passed a couple of days learning about all installation configuration parts including the desktop class and server class.As I was learning, So I had already downloaded Oracle Database Express 11g R2 for win32.
So as i had finished the installation guide I thought it's time to install the oracle now. I did it, and what I found was that there was not any option during installation that i read in above documentation. While trying to find about this difference i reached on documentation[URL]...
That is for express version only.
My question here is, Express edition, we use for learning purpose, But it doesn't look like it has all the stuff that we should learn during installation And what documentation I should follow from my above given two links?
I downloaded the 11G 64bit for windows and unzipped the files into one folder and ran the setup.exe as an administrator. It opened up the java screen and I chose, create and configure a database. Next screen I chose, Desktop Class, when I click next it dies. It does not show me teh next screen. I went to the appdata folder and saw this error but not sure what to do EXCEPTION_ACCESS_VIOLATION (0xc0000005).
View 10 Replies View Relatedi need to restore a database on another database with another SID.
View 1 Replies View RelatedI'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.
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.
can we restore oracle database using backup using emc bcv technology? i dont have experience with bcv.
View 1 Replies View RelatedI'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?
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.
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 Relatedi 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?
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 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
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.
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 RelatedCan 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 RelatedI 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?
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.
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?
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;
}
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.
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.
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.
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 RelatedQuestion: 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)
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'
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