I am using oracle 11.2.0.3.0, i have taken database backup using rman , after backup i have added a new datafile . My database has been crash , can i restore the database including the new data file which does not include in backup . I have all the archive logs.
View 6 RepliesDoes the full cold backup of rman include online redologs?
So that at the time of recovery when i restore the database the online redologs also restored to that point?
how i can recover my drop table using until time in rman scenario.
View 3 Replies View Relatedi need to restore one dropped table which i mistakenly deleted from my UAT Server. My flashback was off also. How to recover the lost table by RMAN.
View 8 Replies View RelatedMy server hard disc crashed yesterday and i don't have any backups.
I am able to recover the .dbf files by using a recovery tool.
is it possible to use this .dbf files into new server and recover my data.
how to take backup and recover of oracle database and which method is best for to protect our data from lost
View 3 Replies View RelatedOur client has this scenario:May 23th 4:00 PM a user truncate a critical table. The customer need to recover the data before truncate.
The recover materials list like this:
1. A cold backup of this database at May 1th.
2. The archive log except May 1th ~ May 15th.
3. Every day exp at 00:30 and 12:00.
Is there any way to recover the data before truncate table with these material?
I am Doing Data Guard in single Machine
Primary Database (chicago) ---- Standby database (boston)
1) shutdown immediate
2) startup mount
3) alter database archivelog
4) alter database force logging
5) alter database open
[code]...
..... Now the problem i could able sync with primary Database.
0ra-16004 backup database requires recover.
I delete some of the data from a table unfortunately and make commit on that on my production server.
getting back my all data of this table only of last 15 minutes.
I have a database for which I use RMAN for backup & recovery. The database is in archivelog mode. Online redo log files are multiplexed and I have more than one destinations for archive logs. If, due to a disk crash, all data files and redo log files are gone - and I have archive logs, one member of each redo log group and a full database backup available, I can recover till the last archived log. But I want to ask that what about the transactions which were not archived at the time of media failure? How can I recover committed transactions which were not archived at the time of crash, and I have a mirrored copy of log group which was current at the time of failure?
View 5 Replies View RelatedI am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..Command that i am useing is ...
brbackup -u / -c force -t online_split -m full -p initBR1_onlinefull.sap
The backup goes thru but i get this erro on the end...
BR0522I 57 of 57 files/save sets processed by RMAN
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28
[code]...
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42
[code]...
Recovery Manager complete.
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman
[code]...
I have check on the system .. There is not file like that but thwre on on the db i,e
eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1
My Rman log location is d:kp man.log, how can i fetch the result of backup into this log file after windows scheduler runs backup..
View 6 Replies View RelatedI am trying to setup incremental backup on my windows OS based server using RMAN command in batch file. When I use batch file in OS scheduler it is working fine, when I am calling same batch file from my LOCAL desktop PC it throws errors as below.
D:> \3.193.211.19sgdba
mankp_acressit.bat
D:>rman catalog rman/******@acressit target / cmd
file=E:sgdba
mankp_arch.rcv log E:sgdba
mansit_arch_rman_backup.log
RMAN-00557: could not open MSGLOG "E:sgdba
[code]....
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "E:sgdba
mankp_arch.rcv"
[code]....
* on my DB server I am login using my administrator account, on my PC I dont have admin account.
* I have checked remote execution using local user as well as admin user.
* I have checked the permission and my local ID & EVERYONE has all permission in that folder.
How can be identify a particular archive-log file have backup or not from rman catalog?
View 2 Replies View RelatedThis is what I run
run {
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dd_oraback/tkprod/%F';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 22 DAYS;
sql 'alter system archive log current';
[code]...
So /dd_oraback is a Data Domain mount. Not sure if that makes any difference or not.
Oracle Database Version : 9.2.0.8.0
Some of the datafiles status have been changed to 'RECOVER', because the datafiles are physically missing.
Now, how can i find that when (timestamp) the status of the datafiles have been changed, as i am unable to find when the datafiles have been physically lost?
Please consider both the case :
1) when the database is in ARCHIVELOG Mode.
2) when the database is in NOARCHIVELOG Mode.
Oracle database 11.2
What is the difference between
recover database until cancel using backup controlfile; and alter database recover automatic until cancel;
1. in user managed and server managed backups. What would be the location of the controlfile which is used in (recover database until cancel using backup controlfile;) .
2. why user first option and why use second option.
I am trying to create my database on a new server using rman incremental hot backups.
I have already restored and recovered my level 0 database on new server, but i am not able to restore/recover the level 1 backup on the new server. I have transported level 1 backup irom the old server to the new one. Do i need to recover lvl 1 bkp only or restore it also.
When we see archive log destination is full , in that case how to backup archive log files using RMAN ?
View 1 Replies View RelatedI have RMAN backup on TAPE. I need to restore control file for particular date on another host. How do I restore control file to new host for particular date?
EXAMPLE:
4949 Full 11.25M SBT_TAPE 00:01:09 06-AUG-12
BP Key: 4949 Status: AVAILABLE Compressed: NO Tag: TAG20120806T223455
Handle: COTSPRD_c-4007601229-20120806-00 Media: 030256
SPFILE Included: Modification time: 28-MAR-12
SPFILE db_unique_name: COTSPRD
Control File Included: Ckp SCN: 237324864 Ckp time: 06-AUG-12
Can I rrun command like :
RESTORE CONTROLFILE FROM TAG 'TAG20120806T223455;
I need to clone from tape to another server for particular date.
I'm trying to write a bat file for the rman backups that can be used for any of our databases. I'm passing variables into the bat file and that is working fine (i.e. oracle_sid, drive letter, oracle_home), my problem is when the rman actually runs and calls the ctl file, the variables aren't being passed thru to that file.
View 3 Replies View RelatedWe're running 10.2.0.4 Database on AIX with no catalog Database.We keep all the backup info in controlfiles only.When we do that backup, we're able to successfully back it up (including archivelogs). But I'm unable to find any records in the controlfiles.
SQL> select * from V$BACKUP_SET;
no rows selected
and
SQL> sho parameter control
NAME TYPE VALUE
------------------------------------ ------------------------------
control_file_record_keep_time integer 14
During the last week, we faced many network issues that prevent our RMAN files to be copied completely. Backup team offer a temporary solution that we have to generate only one backup file to be transferred from source to destination (tape).
View 5 Replies View RelatedI faced one strange behaviour of rman backup after adding new file system for datafiles . I have OMF datafiles . 4 days ago i had only one file system /data01 and my DB_CREATE_FILE_DEST is set to /data01. my rman backup was creating 14 to 15 bacup pieces with parallelism 5 . which is normal with 84 datafiles .Now i added one more file system /data02 . but after adding this file system rman backup is creating so many backup-pieces around (40-45) with same rman configuration . nothing changes at rman script .
View 3 Replies View Relatedwhere does the control file auto-backup information gets stored? or how does a RMAN knows from where to restore a controlfile in auto backup?
View 12 Replies View RelatedI have a RUN file within a script to duplicate a database. As part of this RUN file I also run the command configure controlfile autobackup off; as part of this RUN file. However, this command has turned off backup of the control file on the AUXILLARY database (i.e. production) as well as the TARGET database (test). Is this supposed to happen?
My run file is:
rman TARGET sys/XXXX@${DB}-SOURCE AUXILIARY /
RUN {
allocate AUXILIARY channel a1 type disk;
allocate AUXILIARY channel a2 type disk;
allocate AUXILIARY channel a3 type disk;
allocate AUXILIARY channel a4 type disk;
[Code]....
I have installed oracle 11.2 on virtual machine and made two copy of this vm i.e vm1 and vm2...i have taken fullbackup with rman on vm1 and autobackup of control file.Now i want to restore this backup on vm2, for this i have configured channel and other setting. run following command
catalog start with '\server3database_backup
manC-3507808503-20130531-00';
"C-3507808503-20130531-00" is the name of control file autobackup.
RESTORE CONTROLFILE ;
it gives me error RMAN-06496: must use the TO clause when the database is mounted or open...then i use following command
RESTORE CONTROLFILE to 'C:oracleAdministratororadataslate';
then it gives me error RMAN-06024: no backup or copy of the control file found to restore...how to restore control file to vm2
I have an oracle autoback of controlfile and spfile. I am trying to restore the production database using this backup, into a new server with a different directory structure.
I have completed the following steps in the restore process.
1. Creating a pfile from spfile
2. Changing the the location of cdump, udump, bdump and the control files ( there are three )
3. Then creating a spfile from this pfile
I am stuck on the next step where to rename all the datafiles and tempfile and restore the database. Following is what I did.
After mounting the database in RMAN, tried to run the following.
RMAN> run
2> {
3> allocate channel c1 device type disk
4> ;
5> @/home/oracle/rman_scripts/newloc.rman
6> SET NEWNAME FOR DATAFILE 1 TO '/u02/oradata/dorian/system01.dbf';
7> SET NEWNAME FOR DATAFILE 2 TO '/u02/oradata/dorian/undotbs01.dbf';
8> SET NEWNAME FOR DATAFILE 3 TO '/u02/oradata/dorian/sysaux01.dbf';
9> SET NEWNAME FOR DATAFILE 4 TO '/u02/oradata/dorian/users01.dbf';
[code]....
I am getting the following error message.
Starting restore at 25-JAN-2012 21:26:48
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/25/2012 21:26:49
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 30
RMAN-06100: no channel to restore a backup or copy of datafile 29
RMAN-06100: no channel to restore a backup or copy of datafile 28
[code]....
Can the control file be used to store scripts which are used to perform backups? I know the RMAN recovery catalog can.
Does the SHOW command display detailed reporting on the RMAN catalog contents other than configuration information?
I have many backup sets of my database.
I need to recover a especific set of data, but where these data are. I thought of install oracle in a new machine and recover the backups one by one.