RMAN :: Error When Restore Data From Server A To B
Sep 22, 2012
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.
View 20 Replies
ADVERTISEMENT
Jun 21, 2011
We are using Oracle 10g R2 in Windows Server 2003. I'm trying to restore a database in a new server, using RMAN backups.
Our external consultant configured RMAN scripts for full and incremental backups but never tested them . Since he just doesn't show up, I'm forced to tested them, restoring the whole database in a new server.
My instance is named MTDPROD, and I will create all from scratch.
At current server, RMAN files are generated in:
//192.168.1.149/g$/XXXSRV4-ArcLogs/MTDPROD/RMAN
At new server, I run all these commands:
C:>oradim -new -sid MTDPROD -intpwd mtdprod
Instance created
-- I created the relevant folder hierarchy under <ORACLE_BASE>
directory
-- Then, I created the relevant directories for Oracle Database, as
follows:
--a. Create BDUMP, CDUMP, and UDUMP directories under '<ORACLE_ BASE>
[code]....
By instance, I see a lot of this kind of files:
- FULL_MTDPROD_20110529_386_1.BAK
- INCR_MTDPROD_20110621_480_7.BAK
And only see these two files:
- C-2169285856-20110527-03
- C-2169285856-20110527-04
It seems that this C-2169285856-.... files only were on 27/05/2011 and then no more. However, the FULL_... and INCR_.. files are generated every day. The FULL is generated at the end of each month and INCR is generated every day.
This is the backfull.sql:
run {
allocate channel c1 type disk maxpiecesize=4G;
CROSSCHECK archivelog all;
backup
incremental level 0
format '\192.168.1.149g$XXXSRV4-arclogsMTDPRODRMANFULL_
[code]....
This is the backincr.sql:
run {
allocate channel c1 type disk maxpiecesize=4G;
CROSSCHECK archivelog all;
backup
incremental level 1 cumulative
format '\192.168.1.149g$XXXSRV4-arclogsMTDPRODRMANINCR_
%d_%T_%s_%p.bak'
[code]....
View 6 Replies
View Related
Feb 27, 2013
I have two Solaris 5.11 x86 64 bit servers. I need to be able to copy the backup files to a temp location on the 2nd server and restore that server so it is a test version of the first server. There is no RMAN catalog, I simply want to backup on A move to B restore from files copied to b.
On the first server installed Oracle Enterprise 11.2.0.3. sid = orcl. i created one schema with a new table space added a table and inserted 500,000 rows.
i set the db to archivelog=on, set configure controlfile autobackup on
i then did RMAN backup as backupset database spfile;
on the second server, i installed Oracle Enterprise 11.2.03, sid=orcl exactly like i did on the first server.i scp'd all of the files created by the backup to one location on the test server. i renamed spfileorcl.ora in dbs to somethinge else. startup nomount, exit and go to rman and run this:
DUPLICATE DATABASE TO 'orcl' SPFILE BACKUP LOCATION '/tmp/backups' NOFILENAMECHECK;
this runs for a while and looks like it works but eventually fails with :
RMAN-05541: no archived logs found in target database
subsequent attempts to 'startup' the database receive the error ORA-19838: Cannot use this control file to open database.
This is very frustrating. I have gone over all of the manuals, documentation and more but there is no 'step by step' process that i can find that is current with my version of Oracle that documents the steps necessary to simply backup a db, move it to a test server to a disk and then restore that test server as a copy of the first server.
View 4 Replies
View Related
Jul 1, 2013
I am facing an issue while rebuilding a DR (Physical Standby) site using RMAN.Rman is failing to restore all the datafiles to the stanby site.
There are 403 datafiles that should be restored among which after restoring 50-60 datafiles the channel is abruptly getting terminated.Please note this exercise is not new I have done this many times (once a year after a DR testing) and the same script is being used.The rcv file is as follows
/u03/oracle/admin/mpr/scripts/dataguard/configure_dr.rcv
connect auxiliary sys/XXXX@YYY
run {
duplicate target database for standby nofilenamecheck dorecover;
}
exit
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
configure_dr.rcv: END
[code]....
The trace file says "krso_proc_add: Detected dead process 13828326; subsuming V$MANAGED_STANDBY slot
INFO: krsr_rfs_atc: RFS processes are temporarily disallowed"
I have also started RMAN debug tracing and the trace is also scanned as it is huge.I have seen the following in the trace error 3015 signalled during compilation..I do not find any specific oracle error to check on .
The only change that happened is that the Primary production server has been moved to a new datacentre and after its move all the connections seems to be working fine.
View 3 Replies
View Related
Feb 19, 2013
I want to test full backup (hot backup using RMAN) of my DB (11.2 SE) on another server (I didn't install DB on yet).
View 6 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
Feb 14, 2012
I am trying to restore a backup from a live server to a dev server. Have moved nackup sets. Created a windows service to match the old sid on live system. copied the pfile from live and changed the locations of the folders to suit dev. set oracle_sid to the new sid(as created to match live)
connected to rman
startup nomount
set dbid to the live number
restore controlfile
alter database mount
catalog'd all the backupsets
[code]....
but it fails when it tries the restore .. see below ..The path it is showing is the old path from the live server, so it appears to eb ignoring my set newname statements even though they succeeded earlier - should be restoring them to d:oracleoradatasun43dev ? Does the whole thing have to be put inside one run block or can I put bits in one run block and other bits outside of it etc?
RMAN> restore database;
Starting restore at 14-FEB-12
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
[code]....
View 1 Replies
View Related
Aug 26, 2010
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.
View 4 Replies
View Related
Feb 13, 2012
I am attempting to use an rman backup form our live server to restore live data over an existing dev database with a different name. I cant use the duplicate command as the versions of oracle are different (10.2.0.4 EE on live, 10.2.0.5 SE on dev) So I copied the backup sets including an autobackup control file onto the dev server. I set the ORACLE_SID to the DEV version (SUN43DEV) and startup nomount and restore controlfile from the backup location. This works and restored the live controlfile. However, I then wanted to mount the database and catalog the backupsets before making a note of the last archivelog etc and restoring the backup with set newname options. But when I try to mount the database I am told that the database has a different name (SUN43 is not SUN43DEV). I read somewhere that I need to set the ORACLE_SID to the live value (SUN43) and restore as that, then use nid TO RESET THE DBID and DATABASE NAME. However, my tnsnames on DEV has no entry for the live database, and we do not have any service defined through ORADIM for the live instance on the dev server. Should I be creating an entry in DEV tnsnames that actually looks at the LIVE server? or do I need to create a service and tns entry etc for SUN43 on my DEV server pointing at the DEV server I have not seen any mention in instructions of creating a service or adding the entry to tnsnames, or indeed adding an entry to the listener for the original live sid. I am worried that if I actually point to the live server then the restore would be attempted on the live server not dev even though I am running it from Dev.
Also, do I need to drop the existing database on DEV before I restore or will RMAN just restore over the top of it?
Finally, if I try to add an entry to the LISTENER.ORA for the new sid, when I stop and start the listener, or reload, the entry is not recognised. I also noticed that the existing SUN43DEV entry is not in there either, yet I can still use that SID - I am assuming that is because the listener is not being used and the sid is recognised from the existence of the service in windows services instead?
View 2 Replies
View Related
Apr 19, 2013
This message for my clarification,we have two schemas MAD_LIVE and MAD_TEST we want to take data from MAD_LIVE to MAD_TEST for particular period of time. way to import data from MAD_LIVE to MAD_TEST for particular period
My SCHEMA MAD_LIVE using from year 2010 till now,we want to take only 2012 data from MAD_LIVE and restore it in MAD_TEST.
View 3 Replies
View Related
May 15, 2011
I have some problem while restore the database in separate environment.
This My backup policy and retention
I have monthly full database backup on march the backup started 2nd march 15:31 and completed at 03 march 11:12 AM retention period 3 years
We have ADHOC ARCHIVE backup which will run for certain conditions if the file system threshold reach 80%
In between the monthly backup the ADHOC ARCHIVE jobs has executed from 03Mar2011 00:00 to 03Mar2011 05:14 this retention period is 30 days
So while restore the database with monthly backup i can't able to recover the the datafiles due to adhoc archive files are missing.
View 4 Replies
View Related
Feb 6, 2013
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;
}
View 3 Replies
View Related
Oct 15, 2010
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]...
View 10 Replies
View Related
Apr 11, 2013
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?
View 3 Replies
View Related
Feb 21, 2013
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
10.2.0
win 7
View 5 Replies
View Related
Nov 5, 2010
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,
View 4 Replies
View Related
Jul 30, 2012
i can do a rman restore from 9i Enterprise to 9i Standard?
View 2 Replies
View Related
Feb 14, 2011
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.
What oracle procedure must I apply?
View 1 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
Nov 1, 2013
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
View 11 Replies
View Related
Mar 7, 2012
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.
View 2 Replies
View Related
Apr 18, 2013
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'
View 2 Replies
View Related
Feb 27, 2013
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?
View 13 Replies
View Related
Feb 12, 2013
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:
*.db_file_name_convert='DB1','STBY1'
*.db_name='DB1'
*.db_recovery_file_dest='E:FLASH_RECOVERY_AREA'
*.db_unique_name='STBY1'
[code]........
View 2 Replies
View Related
Oct 24, 2013
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:
cat INITTEST1. oraspfile='+ ASMD G003 /TEST1/spfileTEST1.ora'
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?
View 6 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
Aug 8, 2012
Version : 11.2 on Solaris, AIX
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 ?
View 3 Replies
View Related
Aug 30, 2012
Oracle RDBMS 11.2.0.2.RAC and Host RHEL 5.6
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.
View 3 Replies
View Related
