Restore Datafile After Opening DB Using Resetlogs?
Mar 5, 2013
We have cloned the db and after opening the db with resetlog option we came to know that one of the user db file is not part of the db and is showing the below error while checking the status and attempting to online it. When checking the size and availability of the dbfile it shows everything without errors.
SQL> alter database datafile 50 online;
alter database datafile 50 online
*
ERROR at line 1:
ORA-01122: database file 50 failed verification check
ORA-01110: data file 50:
'+DATA/orcl/orcldata.291.730828357.dbf'
ORA-01251: Unknown File Header Version read for file number 50
Basic situation is this: Oracle 10g database, good RMAN backup from a few days ago. We lost one datafile due to storage corruption. I restored the datafile from RMAN, no problem, and started to roll forward with our archive logs. Problem: one log is corrupted, can't be read, no other copies of it. We are stuck, cannot roll forward any further. The database is up (all activity suspended for now) -- only this one file is offline. Everything else is fine.
My question: Can i do something similar to "open resetlogs" with just the one datafile? Most of what was in the file was indexes, which can be easily dropped & recreated. But a few extents were data which I want to retain. It's old data and the archive logs subsequent to the one on which we are stuck should be pretty much irrelevant. So if i can 'force' the datafile to open up, i believe we should be OK with the little bit of data that's in there, even if we don't apply the remaining archive logs. If it's not 100% consistent we can live with that.
On database A we have full backups (not incrementals) every morning at 3:00 AM including archive logs. When I query rman (list backup) I see the full at 3 AM (in two backup pieces, each in its own backup set) as well as the backup piece containing archive logs through 9:00 AM.
Due to a data issue at around 10AM, I attempted to do an incomplete recovery to 8:00 AM (data loss is not a concern) - once this was complete I opened the database with resetlogs.
I subsequently discovered that the data issue had occurred closer to 6:00 AM and I am now trying to restore to 5:00 AM. This is failing with the 'UNTIL TIME IS BEFORE RESETLOGS' error. I read up on incarnations, but my previous incarnation is from November, and when I reset the database to this incarnation and attempt a restore I get datafile 1 (2,3) is not available for restore.
how do I basically just restore the full 3:00 AM backup and apply the archive logs through 5:00 AM? Do I need to do a recover until cancel or something? And should I reset the incarnation?
restored from tape a backup then issued rman command
RMAN> restore database;
Starting restore at 21-MAY-13 Finished restore at 21-MAY-13
RMAN> alter database open;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of alter db command at 05/21/2013 15:36:15 ORA-01190: control file or data file 1 is from before the last RESETLOGS ORA-01110: data file 1: '/u02/oradata/system01.dbf' [code]....
I have no backup taken in my oracle server.Today morning i created a data file and unknowingly deleted it. Now i need to restore the datafile with its contents without using RMAN.
I am performing testing on the database recovery after upgrading my backup solution software. I attempted to restore from tape media that is dated back at April 1st. My colleague have perform the same recovery from the same tape media during middle of April.
After restore, I encounter some problem and I could no longer up the database anymore.
These are the steps I have taken to perform recovery. It is being perform when the database in mount mode
SQL> recover database using backup controlfile until TIME '2012-04-01:21:55:00' ORA-00283: recovery session canceled due to errors ORA-19909: datafile 1 belongs to an orphan incarnation ORA-01110: data file 1: '/oracle/AP1/sapdata1/system_1/system.data1'
SQL> shutdown immediate; ORA-01109: database not open
SQL> alter database open resetlogs; alter database open resetlogs *
ERROR at line 1: ORA-01190: control file or data file 1 is from before the last RESETLOGS ORA-01110: data file 1: '/oracle/AP1/sapdata1/system_1/system.data1'
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 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.
I am running 10.1.0 and the database went down and I have been trying to get it started again. I have worked through several errors but stuck on this one.When trying to run startup I get this error ORA-01589 must use RESETLOGS or NORESETLOGS option for database open.
I am trying to create a clone database using hot backup of a database .
STEPS THAT I FOLLOWED ------------------------------------
LET ----- >CURRENT_DB NAME=DEV CLONE DATABASE NAME=DEVCLONE
steps PERFORMED FORM DEV DB ----------------------------------------------- - put the database in backup mode using 'alter database begin backup' - copy all the data files to a different folder - during copy i have performed some operations on the DB (creating users, tables, dmls etc...) - in between copying i also performed log switch - after completion of copy , "alter database end backup" - created a backup control file in a human readable format (alter database backup controlfile to trace as ........)
steps performed for clone DB side ((DEVCLONE) ------------------------------------------------------------------- - created a parameter file for the database . - modified the backup control file so that it will point to the location of copied destination of datafiles - set the ORACLE_SID - then 'sqlplus / as sysdba - starup nomount - run the modified control file ( created a control file for the clone database) - recover the database using "recover database using backup controlfile" I have provided the archive files that it was asking for (archive logs that has been generated in DEV DB) then i canceled the recovery by typing "cancel" - recover database using backup controlfile until cancel; then typed "cancel" - then try to open the database with open resetlogs but it showed below error
alter database open resetlogs * ERROR at line 1: ORA-01195: online backup of file 1 needs more recovery to be consistent ORA-01110: data file 1: 'D:DATA_GUARDDEVHOTSYSTEM01.DBF'
We have a problem while opening PDF through oracle forms, we are getting the folowing error in some PC's, but some PC's this is working fine.'there was a problem reading this document 14'.
un-documented parameter _trace_files_public / I want to set this to true so my app team can review trace files. better way to proceed to open read permissions for non oracle users.
When I click on 'Run Form', the Applet is not opening in Internet Explorer.
Giving Error like " Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience." Even I have re-installed the oracle 10g the same problem is coming.
Note: When I remove jinitiator and then reinstall jinitiator the applet is opening once and again if I run the form second time the same above error is coming.
There is a existing form B. From a form A I need to call form B on button press. Problem is form B has many tabs,It should open in the third tab when it is being opened from form A.
I have a multiple forms application and I use OPEN_FORM to call one form from another. However I want the new form to open in a separate tab ( the way it works in a tabbed canvas).
I have developed a new form.Something peculiar is happening for that form.Let me list down the scenario
1)In the data base for the particular table my form is using, there are 1600 records.When i do a Query on Count Hits in the forms,it gives the same number.
2)However when i open the form ,i do not get some of the records.I found that on opening the form and making an Execute Query only those records that i have added through forms exist.
3) However,when i try to add a new record and do an Execute query again,i get all the records present in the database.
I'm new to Oracle. I took cold backup of my database. Then, i removed my whole database while database was down.Then i restored the whole database from backup taken earlier. Now, when i try to open the database. it does not open up instead gives the below message.
Total System Global Area 1288949760 bytes Fixed Size 1336288 bytes Variable Size 754977824 bytes [code]....
SQL> alter database mount; Database altered. SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01139: RESETLOGS option only valid after an incomplete database recovery
we have a database available in UNIX machine A which can be connected from client in UNIX machine B through port 1521. If we give ping command from UNIX machine A to B or B to A, 0% packet loss, means connection established properly through firewall in port 1521.
Now we are setup one more UNIX machine C and installed a client here. This machine is available in different group, means if i give ping command from machine C to A, 100% packet loss. But from machine A to C, connection established with 0% packet loss.Because of this, when we tried to connect to a database from client in Machine C to database in Machine A, we got "time out" error.
My query is: 1. Is this because of not opening of port 1521 through firewall? 2. If so, is it enough to open port 1521 through firewall when we connect from machine C to A? 3. Any additional setup is required in firewall apart from opening of ports?
My client is Oracle 10G DS Forms Developer. The application server is on a Solaris 64 bit sparc system. I have copied all the forms and libraries to my forms directory under C:DevSuiteHome_1forms10g_rel1 from the application server. and placed the following directory in my FORMS_PATH in the registry entry.
Now I am opening up the forms in my Forms builder and running the form. I get this error. I have the attached library in the form but I still get this error:
FRM-40039 Cannot attach a library while opening a form
I was surprised when I shutdown our production dB. I got this error:
$ . oraenv ORACLE_SID = [abcd] ? SQL> shutdown ORA-01116: error in opening database file 26 ORA-01110: data file 26: '/VOL03/oradata/qxyz/data/qxyz_data01.dbf' ORA-27041: unable to open file SVR4 Error: 2: No such file or directory Additional information: 3 SQL> shutdown abort ORACLE instance shut down.
2 days ago i rename this file QXYZ_DATA01.dbf from it's original name of QXYZ01.dbf without knowing that I was in the 'abcd' instance. When I backup a controlfile I noticed that it was part of the 'abcd' data files, so I just delete it (from OS level).
Is there any risk involved in the 'abcd' instance? How do I get rid of that file 'qxyz_data01.dbf' in the 'abcd' instance.
I have an apex page with a link on one column for each row. My requirement is as below
When i click on the first time on any of that link, it opens up in a new window and any subsequent clicks should override the previously opened window. So at a time, there should be only 2 windows open..
1) the APEX page 2) The browser window after clicking on an link in apex page
I need is to generate this chart automatically from the form builder without opening any program like visio (for instant). that's mean when I select the wanted department the chart will be generated automatically .