I just duplicate my PRODUCTION database to TEST database (11.2.0.1 both) on windows 7.
I just create a backup from PRODUCTION:
RMAN> backup full database format ='C:Usersmy_usermiBBDDflash_recovery_are aTESTdatabase_%U';and controlfile backup:
RMAN> backup current controlfile format='C:Usersmy_usermiBBDDflash_recover y_areaTESTCONTROL_FILE_%U';now i'm trying to restore this backup into TEST with this script:
RMAN
CONNECT TARGET /
STARTUP NOMOUNT;
SET DBID 486238190; #DBID of TEST database
RUN
[Code]....
but i'm having a similar error when i tried to duplicate both databases ( post -->Error duplicate databases fallo de la recuperaci¾n del medio fÝsico
canal liberado: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: fallo del comando recover en 08/06/2012 11:53:06
ORA-00283: recovery session canceled due to errors
RMAN-11003: fallo al analizar/ejecutar la sentencia SQL: alter database recover
if needed start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'C:USERSmy_userMIBBDDORADATAPRODUCTIONSYSTEM01. D BF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:USERSmy_userMIBBDDORADATAPRODUCTIONSYSTEM01.D BF'
Controlfile was restored correctly. what am I doing wrong?
i am trying to restore database using rman backup on same machine using command
RMAN> run { 2> set until sequence 23; 3> restore database; 4> recover database; 5> } but it will give me error. RMAN-00571: ======================================================= RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =========== RMAN-00571: ======================================================= RMAN-03002: failure of restore command at 03/31/2011 19:18:11 [code]....
I have an issue with restoring a RMAN backup that i have with me to a new database instance. What i have with me are: 1. Backup of SPFile.
(O1_MF_NCNNF_CTLFILE_BU_92DVGYO2_.BKP)2. Backup of Control file (O1_MF_NNSNF_SPFILE_BU_92DVGW9H_.BKP)3. Full database backup (O1_MF_NNSNF_FULLPROD_BU_92DVGW9H_.BKP)
I have received these files from a customer environment and I need to restore these to a new database instance in a local machine. I have given a attempt as follows (in Oracle 10g): 1, Created a new database instance (Test75) using Oracle Database Configuration Assistant2. SET ORACLE_SID = Test753. Connected to this instance using RMAN4. Tried to restore the SPFILE from the received BKP file.I am getting errors and cannot proceed. I am not sure whether I am executing the correct steps.
Just inherited an 8i DB that is being backed up with then common techniques used prior to RMAN. The tablespace is placed in backup mode, an OS copy of the file is taken, the tablespace is returned online, and the process is repeated until all files captured in an usable state.
It is running in archive log mode on a Linux OS and daily backups are initiated through crontab as well as jobs to purge the redo logs after backup. Backup storage recently filled - working since 2004. Not bad!
I have documented procedures for using these files with an operational 8i DB. Will I be able to restore these files directly into an 11g environment? What is the implication of 8i having DBA managed "RBS" (roll back segments) vs. 11g?
I have a live server on which Oracle 10g Database is running. We take full RMAN Backups everyday. Now we want to restore the RMAN Backup file from the Live server to another machine (which is going to be a test system). I want to restore the latest RMAN backup on the test machine (which is not on network).
When I copy the RMAN backup set in the flash recovery area of the test machine and then use "list backup", the backup set is not listed. I also tried "crosscheck backup" and then "list backup" but still the backup set does not appear. how can I register the backup set from live server into test machine and then restore it.
How we can use RMAN backup to restore oracle database when the RMAN backup pushed to tape already and being a OLD backup ( before retention policy date).Just to elaborate a more.. Say my retention policy is 3 days. I want to restore from a old backup like 30 days old.So surely the requesting backup is behind retention date and has been pushed to tape.
I have One Production and one logical standby database . Due to tape problem we are unable to take backups of primary . And due to business , we cannot take back up on disk in hot period(Bank database ) .
If i take logical standby database backup(level 0 ) using RMAN , then will i be able to restore it on production dtbs (In case Production down) ? . Logical standby is in sync with primary .
I've read a lot about the different types of backup available with Oracle (hot and cold backup). However, I was thinking of a different way of performing this task. I'm currently using Windows Server 2008 R2 and Oracle 11g Standard Edition. I'd like to schedule an entire backup of my server via the utility "Windows Server Backup" (available for free).That way, I could recover my entire server with all the programs and files in case the latter crashes.I'm wondering if this solution could be used as a way of backing up (and recovering) the Oracle database. Should I still set up a regular hot backup with the Archivelog mode enabled in case some operations/transactions were being done at the time of the crash (for the data integrity)?
I'm testing out various RMAN restore/recovery scenarios for 10g R1. Took a full level-0 backup of one of our larger databases (16 tb) and I'm trying to restore the whole thing on another server. While the backup was running (for about a day & a half), a few datafiles were added. The backup completed fine, including "backup current controlfile;". Now my restore is failing with "RMAN-06023: no backup or copy of datafile xxxx found to restore", with reference to the 4 files that were added while the backup was in progress.
I guess if the datafiles were added after the backup had finished, we'd be fine because they'd be created during recovery with our archive logs (we have all of those).
I found some suggestions for first doing a "restore controlfile;" -- did that and it worked fine -- then mounting the database and creating the datafiles manually. I added that to my RMAN restore script and tried it, like so:
run { allocate channel d4 type disk format '/BK01/dbX/stream1/df_%t_s%s_s%p' ; sql "alter database create datafile ''/uXX/oradata/dbX/datafile_58.dbf''"; restore database ; }
The datafiles were created successfully, and the restore began .. but then it failed with this:
creating datafile fno=4216 name=/uXX/oradata/dbX/datafile_58.dbf ... RMAN-03002: failure of restore command at 06/20/2013 17:27:28 ORA-01119: error in creating database file '/uXX/oradata/dbX/datafile_58.dbf ORA-27038: created file already exists
So RMAN seems to be telling me that if these 4 datafiles don't exist in the backupset, then RMAN won't automatically create them. But if I manually create them first, then RMAN will try to restore them and complain that they already exist. And for that matter, I would have expected that RMAN would be smart enough to detect that those 4 files were added while the backup was active, and just include them in the backup. Maybe there's something I needed to do to tell RMAN to do that?
This is just a test, so of course I can redo the backup from scratch and try again, but we have some pretty large databases which cannot be shut down for cold backups, so it's entirely possible this scenario could show up in a real disaster recovery. RMAN does such a good job of managing things.
I want to ask if I restore a control file from backup of say day2 and I recover till day1 using RMAN script, then what will be the state of my database? I mean day2 control file may be having SCN-Day2, and I am instructing RMAN to recover till past point in time that is SCN-Day1.
2nd Incremental #1 Files updates between the 1st and 2nd - Monday 3rd Incremental #2 Files updates between the 2nd and 3rd - Tuesday 4th Incremental #3 Files updates between the 3rd and 4th - Wednesday 5th Incremental #4 Files updates between the 4th and 5th - Thrusday 6th Incremental #6 Files updates between the 5th and 6th - Friday 7th Incremental #7 Files updates between the 6th and 7th - Saturday 8th Full Backup #8 Files updates from 1st,2nd to 7th - Sunday 9th Incremental #9 Files updates between the 8th and 9th _ Monday 10th Incremental #10Files updates between the 9th and 10th - Tuesday 11th Incremental #11 Files updates between the 10th and 11th - Wednesday 12th Incremental #12 Files updates between the 11th and 12th - Thrusday 13th Incremental #13 Files updates between the 12th and 13th - Friday 14th Incremental #14 Files updates between the 13th and 14th - Saturday 15th Full Backup CRASHES - NOT COMPLETED - Sunday
I would need to restore now from #8 ( full backup ) and #9 to #14 ( incremental backup )
Tell me the "restore command" to achieve the output?
I have oracle 10g installed on my system and name of the database is "ORCL" for which I have schedule the incremental backup everyday. Mentioned below are the steps followed
*************PARAMETERS TO BE CHANGED****************** configure channel 1 device type disk format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U'; configure channel 2 device type disk format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U'; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalcntrl_%U'; CONFIGURE RETENTION POLICY TO REDUNDANCY 7; CONFIGURE CONTROLFILE AUTOBACKUP ON; *******************************************************
*******COMMAND FOR THE CONNECTING TO RMAN************** rman LOG = \192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incremental rmanlog_%date:~4,2%-%date:~7,2%-%date:~10%.txt APPEND CONNECT TARGET SYS/ORACLE@ORCL *******************************************************
********INCREMENTAL BACKUP COMMAND********************* RUN { BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_backup' DATABASE; BACKUP ARCHIVELOG ALL DELETE INPUT; } ********************************************************************
Now I want to restore this backup to some other system with new database. How to do this recovery to some other database on new system.
We are running a 5Tb database backup which takes really a long time to backup and impacts the performance in general during the backup. We got a DataGaurd database in place which we want to utilize to run the RMAN backup on to avoid performance impacts and just use DG database for backup and DR purposes. My Question is if we run the backups on DataGaurd Database, How would a RMAN DG database backup would clear the archive logs from Primary production and from DataGaurd Database during the backup process?
My boss gave me a 1GB Oracle .dmp file, and I told him that I could handle it easily (ie, install Oracle on a machine, import the .dmp file, and export / move it onto a MS SQL server).
Oracle has turned out to be far more difficult to learn than I originally thought, however. Even after a week of reading search results and watching YouTube videos, I still feel completely in the dark.
Restoring an Oracle backup? (Once the backup is restored, that should be it - I have an ETL tool (Scribe Insight) for reading an Oracle database and moving it to SQL. I can use GoToMeeting for screen sharing.)
In my catalog for the "source" database (rman target db), I have the backupsets for a full database backup ended at Feb. 7, 03:43:37. These are online backups. So, there are archived redo logs being generated while it runs and the following archived redo logs finished at Feb. 7, 04:00:24.
We duplicate databases all the time. So, this is not a new concept for us. The one thing that has changed is that we now back up to disk (using the flashback recovery area) and then later on, initiate a backup to tape. Prior to this go-live, we did all of our backups directly to tape. The catalog does not seem confused. It knows it needs to go to tape because it's beyond the retention for disk backups. The only problem is that it is going to the backup prior to the backupset I want, only for a couple of files.
In the past, when all went directly to tape, we would do a set until time 'Feb. 7, 03:43:37' and it would automatically restore the backupset that finished then and apply archived redo logs as necessary to make a consistent copy. Now, if I use the same model, it's going to a backup set from the prior date for 3 particular files. If I change the time to when the archived redo logs ended their backup, 04:00, it still goes back to the day before, but only for 2 files.
I can list a backup of each specific file and see that the file is in the backupset for which I expect RMAN to pull. How can I figure out a date/time to go back to if not using the method of reviewing the catalog entries and timestamps?
I tried to clone a 2 node rac database to single instance non rac database using existing backup. I have not used connectivity to target or catalog. rman duplicate finished with below messages:
rman auxiliary sys/******@dbracdup RMAN> duplicate database to dbrac spfile backup location '/oracle/backup'; ... ... Finished recover at 25-JUL-12 Segmentation fault
And the database was in mount stage, and when i tried to open database it failed with below error:
SQL> alter database open; alter database open * ERROR at line 1: ORA-19838: Cannot use this control file to open database .
How one should know whether RMAN is using target database control file or using separate catalog database. Also what one should do if he dont have catalog users credentials.
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 have a active data guard database which is copy of my production database. can i backup the active database using RMAN? The ADG is a read only and dont know, if RMAN can backup an read only database.
I'm going to backup this un-maintained Oracle 11g server in my office. I'm being told it's never been backed up and extremely critical to our success so tomorrow I'll be performing my 1st backup of the database using RMAN. My question is if I connect to the Oracle 11g database and run the:
[oracle@db1 ~]$ rman target=/ Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 13 13:18:05 2012 connected to target database: CQDB (DBID=1854033249)
RMAN> shutdown immediate
using target database control file instead of recovery catalog database closed database dismounted Oracle instance shut down
BACKUP DATABASET FORMAT �/oracle/u01/app/oracle/backup/%d-%T-%s-%P�;
My question is the above sufficient for a safe full backup? We only have the one single target database called 'cqdb' which houses several schemas. Can you tell me if this is correct? I've shut the database down so it's in a cold state so I don't think I need to configure the FRA (Flash / Fast Recovery Area) but I honestly don't know. This is my 2nd time on a Oracle DBMS.
What about the 'archivelog' files? Do I back those up? Do I need them in case a recovery? Also what about the 'controlfile'? Do I need to back those up as well as the mentioned above?
I have done many duplication before in sinlge instance databases using a backup tool and rman catalog. At the moment i was trying to do a RAC database duplication and facing some issues. For this i was doing a testing on my 1-node RAC. Primary and duplicated database is on the same Host and oracle version is 10.2.0.3. I perfomed following steps:
1.Created a DUPL database using DBCA.
2.Created a pfile using spfile.
3.Dropped all the datafiles, controlfiles and redo log files.
4.Started the database in nomount using pfile.
5.Disable cluster related parameters in pfile.
6.Took a full backup of the MAIN database with archivelog on disk.
6.Duplicate the database and it is done successfully.
7.Shutdown the instance and enabled cluster parameters.
8.Start instance using SRVCTL fails with error CRS-0215: Could not start resource 'ora.DUPL.DUPL1.inst'
But if start the instance using sqlplus it comes up nicely. There is not much information in alert log files.
I want to duplicate a prod database in to a dev db.I am using catalog database to connect to target and auxiliary datbase.I copied all backupsets to the local disk on Dev env in the correct path.For RMAN duplicate ,does the backuppeices need to be present on PROD filesystem as well or just DEV filesystem or both.
starting full resync of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of allocate command at 02/18/2013 05:00:06 RMAN-03014: implicit resync of recovery catalog failed RMAN-03009: failure of full resync command on default channel at 02/18/2013 05:00:06 ORA-02291: integrity constraint (REPOSDB.ORL_F1) violated - parent key not found
I would like to duplicate to the different server Oracle Database with RMAN. I've configured flash recovery area for Oracle Database. My questions are:
Source Server ( target ) : ORACLE_SID : DB11G AUXILIARY Server (duplicate ): ORACLE_SID : CLONE
1- if backup files (autobackup and backup set)/ Archived Logs are in a different path on the source host (not default FRA Path) then how can I use the DUPLICATE command? BTW, only the flashback logs are in the default location (/u01/app/oracle/fra/flashback). Path: /u01/app/oracle/oradata/DB11G/autobackup and /u01/app/oracle/oradata/DB11G/backupset.
2 - Do I have to add *_CONVERT parameters for different SID as shown below? e.g. : DB_FILE_NAME_CONVERT , LOG_FILE_NAME_CONVERT.
DB11G.__java_pool_size=4194304 DB11G.__large_pool_size=4194304 DB11G.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment DB11G.__pga_aggregate_target=155189248 [code]......
for rman backup with standby database with datagaurd but no active DG. I wanted to do a rman tablespace backup. but I am stuck at sql 'alter system archive log current' in rman with standby as target. which gives following errors with or without noswitch clause
RMAN> sql 'alter system archive log current noswitch';sql statement: alter system archive log current noswitch RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of sql command on default channel at 10/05/2013 18:15:12RMAN-11003: failure during parse/execution of SQL statement: alter system archive log current noswitchORA-01109: database not open Recovery Manager: Release 11.2.0.1.0Oracle databaes Release 11.2.0.1.0 64 bitOS:RHEL 6 x86-64 bit Secondly,
do I need to cancel manged recovery while taking rman backups on standby. I scanned thru MOS but could find solutions for rman with active DG.