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?
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
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 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.
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 upgrading an application from 9i to 11g and I've been told that the connect by prior sql is broken. While I am waiting for the example and the error message, is 11g pickier about looping than 9i was? some documentation on 10 or 11 changes to hierarchical queries?
I started restoring and testing all the backups. So far I did good and I wanted to restore and test in different host. I couldn't find any online documentation regarding restore full back up in a new different server (With same OS and same version of Oracle) without RMAN catalog database.
We are cloning a database, but using the restore method ( version 11.1.0.7). The source and destination path are different. As we are using the source controlfile, before restoration SET new name inside the run block is the way to change the path.
I was just wondering, if there is any other way to do it. Because, we have around 1000 datafiles, and dont want write everything in the run block. Also, this goes from Non-ASM to ASM. I tried DB_FILE_NAME_CONVERT, but it seems to be not working.
run { Set newname for datafile 1 to '+DATA_DG1'; Set newname for datafile 2 to '+DATA_DG1'; Set newname for datafile 3 to '+DATA_DG1'; Set newname for datafile 4 to '+DATA_DG1'; restore database; switch datafile all; }
create a backupset, tag it, and restore it. You could say that what I'm trying to achieve is analogous to a flashback, but rather than specifying a timestamp, I'd like to simply restore the entire db to exactly what was there when the tagged backup was taken.Here is the RMAN script I am using for the backup procedure:
run { #allocate channels #ALLOCATE CHANNEL FOR DEVICE TYPE DISK; SHUTDOWN IMMEDIATE; STARTUP MOUNT; #backup database BACKUP FULL DATABASE TAG='latest' PLUS ARCHIVELOG TAG='latest' DELETE INPUT; [code]....
I'd like to take these backups in online mode, and I've tried taking both a consistent and inconsistent backup modifying the above script.Additionally, I'm using the following restore script to try to revert the database to the state when the backup set was taken (and am testing the data being restored by deleting some data entries after taking the backup):
run { #shutdown db (should be done already) SHUTDOWN IMMEDIATE; #mount db STARTUP NOMOUNT; #show RMAN settings SHOW ALL; [code]...
When performing the restore, I dont see the data backed up, rather I see the latest data still in the database. why the state of the db is not getting reverted to the backupset with tag='latest'.Finally, here below I've listed the rman settings for reference:
RMAN> show all; RMAN configuration parameters for database with db_unique_name ### are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default [code]...
I am in process of restoring database for a standby.When I am restoring datafiles, it says it is restoring to an original location (same as primary database).
restoring datafile 00242 to +MYDB_DATADG/mydb/datafile/data_05.474.805989155 but when I checked with asmcmd utility, it is actually another path/filename. Only same thing is the diskgroup name.
So the file would be -> +MYDB_DATADG/mydb_stby/datafile/data_05.281.812429111
How do I force rman to restore to the same exact location as my primary database?
i have changed the log_archive_dest_1 to another drive (suppose D ) than Oracle installed disk
created tables in scott , alter system switch logfile;
so archive log was der in the new destination i delete that archivelog from D and pasted to drive E ( cut paste ) start rman , crosschecked archivelogs Now , i want to tell Rman that recover that archivelog from E and then recover
I am trying to duplicate an Database and create an Physical Standby through following command
I took the backup through rman using the following command on Monday
RMAN> run 2> { 3> ALLOCATE CHANNEL C1 TYPE DISK FORMAT 'E:DB_FULL\DB1_FULL_%U'; 4> ALLOCATE CHANNEL C2 TYPE DISK FORMAT 'E:DB_FULL\DB1_FULL_%U'; 5> ALLOCATE CHANNEL C3 TYPE DISK FORMAT 'E:DB_FULL\DB1_FULL_%U'; 6> ALLOCATE CHANNEL C4 TYPE DISK FORMAT 'E:DB_FULL\DB1_FULL_%U'; 7> backup database format 'E:DB_FULL\DB1_FULL_%U'; 8> backup archivelog all format 'E:DB_FULL\DB1_FULL_%U'; 9> backup current controlfile for standby format 'E:DB_FULL\DB1_FULL_%U'; 10> }
Today i am trying to clone the DB1 Database as physical standby ...
using the following command
> RMAN TARGET sys/sys@db1 AUXILIARY /
Then I exceuted the following command
> duplicate target database for standby dorecover;
but i am getting error RMAN-06024: no backup or copy of the control file found to restore
contents of Memory Script: { set until scn 11182084819076; restore standby controlfile; sql clone 'alter database mount standby database'; } executing Memory Script
executing command: SET until clause
Starting restore at 05-NOV-10 using channel ORA_AUX_DISK_1
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 11/05/2010 15:45:30 RMAN-03015: error occurred in stored script Memory Script RMAN-06026: some targets not found - aborting restore RMAN-06024: no backup or copy of the control file found to restore
i even tried to switch the log file of the primary database DB1 but no avail,
I have to test a hot rman backup on testing environment and I have some doubts.
STAGE Server 1 production database (linux) backup folder on cifs share windows server Server 2 testing database (linux)
First I installed linux on same network, I gave it access to cifs backup resource, then I installed the same database version than production environment, then I create a typical database with only same database production name. Also the Linux partitions between linux servers are different.
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.
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.
I want to restore my database from server x to server y.
The control files on server x are named [$ORACLE_SID]_control01.ctl and [$ORACLE_SID]_control02.ctl.
We have an auto backup of the control files.
When I restore the control files on host y, (from autobackup) the restored controle files have other names: control01.ctl and control02.ctl. After the restore and recover (which goes well) the database does not start correctly.
SQL> ORACLE instance started.
Total System Global Area 626327552 bytes Fixed Size 2224088 bytes Variable Size 411041832 bytes Database Buffers 205520896 bytes Redo Buffers 7540736 bytes Database mounted. ORA-01122: database file 1 failed verification check ORA-01110: data file 1: '/data/coda/coda_system01.dbf' ORA-01202: wrong incarnation of this file - wrong creation time
I have on PC running Windows Server 2003 named "Host A" and another Windows Server 2003 named "Host B".I made a Backup from Host A and want to restore this on Host B with following procedure.
Prepare & Backup: SQLPLUS SYS AS SYSDBA SQL>SHUTDOWN IMMEDIATE SQL>STARTUP MOUNT SQL>ALTER DATABASE ARCHIVELOG; SQL>ALTER DATABASE OPEN; SQL>ARCHIVE LOG LIST; SQL>ALTER SYSTEM ARCHIVE LOG START; SQL>QUIT [code]...
But when i now try to access the Database Control i got following Error:„503 Service Unavailable: Servlet error an exception occurred the current application deployment descriptor do not allow for including it in this response" and the restored Datas are not included.
We are managing a huge amount of data warehouse on oracle 11.2.0.3.0. We need to take backup using rman of some tablespace not the whole database backup. we need a backup strategy in which we can restore the backup of some tablespace plus oracle instance if any disaster occur.
I have taken backup using rman on test db of system , sysaux , user tablespace then i restore these tablespace successfully and make the remaining tablespace offline , but while open the database it show me below error.
My question is how i backup using rman so that in case of disaster i restore oracle instance plus specific tablespace not full database.
ERROR at line 1: ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'C:APPADMINISTRATORORADATASYSTEMSYSTEM01.DBF'
I have 2 databases. Primary ( DB1 ) and Standby ( STBY1 ). My standby database went kaput, and i have as a result deleted the standby database in order to re-create it from a full primary backup.
Oracle 10g R2 on Server 2003.
I have followed several guides, and at this time i have done the following:
- Configured standby re-do logs on primary - backed up current controlfile for standby - backed up database plus archivelog - configured the tnsnames [code].........
The problem is here. I connect to RMAN from standby
rman nocatalog connect target sys/password@ DB1 connect auxiliary / run{ set until scn xxx; duplicate target database for standby dorecover; }
I receive an error message saying that it cannot find the file location of the backups that its trying to find. I see in the error that it tries to look locally for
E:FLASH_RECOVERY_AREA DB1 BACKUPSET2013_02_12), however the actual location is (E:FLASH_RECOVERY_AREA STBY1 BACKUPSET2013_02_12)
I have read that the locations need to be the same, however the instance names are different, and i thought i changed the pfile to accommodate that. My assumption is that i have made an error in the pfile. However i cannot see any issues there. Some things that i have changed in the pfile for standby:
Database: 11gEBS: 12.1.3O/S: Solaris Sparc 64 bits
Problem Description: Cloning from Source instance A to target instance B and both are in ASM instances.RMAN backup in source instance A is completed, which has spfile configured in non-default location in ASM for example,see belowASMCMD
[+ASMDG003/TEST1 > ls -ltType Redund Striped Time Sys Name Y TEMPFILE/ Y ONLINELOG/ Y DATAFILE/ Y CONTROLFILE/ N spfiletest1.ora => +ASMDG003/TEST1/PARAMETERFILE/SPFILE.747.856347
Also, there is no SPFILE in $ORACLE_HOME/dbs for the TEST1 source instance. INITTEST1.ora file has the following entry:
Question: In the target instance to be cloned from RMAN backup fro source instance TEST1, on performing ' restore spfile from autobackup 'location';Will the spfile be restored in $ORACLE_HOME/dbs in the target instance TEST2?
All our production DBs are backed up by some Hitachi tool (apparently it is called ShadowImage) . Apparently they put all the tablespaces in Backup mode and 'take a snap' . Our BAU team says this is faster.
On an event of DB Crash Is it easier to restore, recover from these 'snapshots' ? Are these snapshots much faster than RMAN ?
My dev application team iwant to test their application, and once that is done they want to recover to point in time. In my case they would do that after 9.0Am and once that is done they want the state of the database back to 9.0Am
What i am planning to do is:create a restore point at 9.0Am and once application testing is done recover until restore point. ..But i was suggested not to do that way instead my Lead want me to use just recover until timestampI asked what is the difference in doing in my way,the answer i got is by using recover until restore point, the recover process cannot apply incremental level 1 backups and it just restores to a point of incremental level 0, it looked strange to me.
I have troubles when restore FULL BACKUP from server A to Server B . when i Backup Full from server A ,i copy that Backup files to Server B (aa new server),i restore spfile và control file from BK files,then i mount (alter database mount ) to restore database , it show error message ORA-01103:
database name 'ORCL' in control file is not 'DUMMY' ,
I tried to shutdown immediate and then startup mount again , but it show other error message
RMAN-04014: startup failed: ORA-00845: MEMORY_TARGET not supported on this system.
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.