Backup & Recovery :: Archive Log File Using RMAN
Feb 1, 2012When we see archive log destination is full , in that case how to backup archive log files using RMAN ?
View 1 Replies
ADVERTISEMENT
Backup & Recovery :: Identify Particular Archive-log File Have Backup Or Not From RMAN Catalog?
May 30, 2012How can be identify a particular archive-log file have backup or not from rman catalog?
View 2 Replies View RelatedBackup & Recovery :: RMAN Hot Backup Plus Archive Log Files?
Jan 11, 2008I had a production db with archive logging enabled
SQL> select name,status
2 from v$archived_log;
NAME STATUS
---------------------------------------- -
D:ORACLEARCHIVE_ORCL11_13.DBF A
D:ORACLEARCHIVE_ORCL11_14.DBF A
D:ORACLEARCHIVE_ORCL11_15.DBF A
[code]...
So i need to restore archivelogs by using sequence
RMAN>RESTORE ARCHIVELOG FROM SEQUENCE 20 UNTIL SEQUENCE 28;
So the restore is completed successfully
So its very hard to monitor archivelog files
i feel i should have included all archivelog files while taking RMAN backup
RMAN >backup database plus archivelog all delete input;
but the problem is my RMAN backup is already 360GB in size and it takes 4-5 hrs to complete .so i need to schedule RMAN backup at one time (e.g sunday) ,delete the archivelog files older than sundayand now schedule the archivelog backup at another day (e.g wed &sat)
my question is where i have to change my script to backup all avaialbe archivelog files if old archivelog files are deleted at os level?
RMAN> run {
2> allocate channel c1 type disk;
3> sql 'alter system archive log current';
4> backup archivelog all format 'D:oracleackuplog_t%t_s%s_p%p' delete input;
5> release channel c1;
6> }
Backup & Recovery :: RMAN - Missing Archive Logs Files
Oct 7, 2012We have a nightly rman backup that was complete and clean.The backup contains a Data File, Control File and a backup Archive Log file.The database server crashed with all the subsequent archive logs lost.
We are trying to recover from the three backup files.We are bumping into the backup piece missing as all the archive logs are done. how to restore with the exising backup files. the lost archive logs are probably salvageable.
Backup & Recovery :: Archive Log File Missed
Jan 30, 2012Today we have taken a backup of the Live database, due to some issue, it got deleted before applying into the Disaster Recovery Location.
View 12 Replies View RelatedBackup & Recovery :: RMAN Full Backup Failing When Backing Up Temp File?
Jan 28, 2011I 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
Backup & Recovery :: RMAN Backup Fails On Windows When Using Batch File?
May 3, 2011I 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.
Backup & Recovery :: RMAN Control File Auto Backup Error?
Dec 13, 2011This 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.
Backup & Recovery :: Windows RMAN - Bat File Using Variable?
Oct 16, 2012I'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 RelatedBackup & Recovery :: No RMAN Records In Control File
Dec 7, 2012We'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
Recovery Manager (RMAN) :: How To Make Only 1 File Backup
Jan 22, 2013During 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 RelatedBackup & Recovery :: Running RMAN Commands In RUN File To Duplicate A Database
Dec 17, 2012I 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]....
Backup & Recovery :: RMAN - Control File Be Used To Store Scripts Which Are Used To Perform Backups?
May 12, 2011Can 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?
Backup & Recovery :: How To Get All Archive Logs In Backup Piece
Nov 8, 2008Is there any way I can get all the archive log files present in a backup piece. I tried following but it always gives me all the log files for each piece:
****
SQL> select s.set_stamp, s.set_count, s.PIECES, s.backup_type,
s.controlfile_included from v$backup_set s, v$backup_piece p where
s.set_stamp=p.set_stamp and s.set_count=p.set_count and
p.handle='5mjv4do0_1_1';
[code]....
Backup & Recovery :: How To Apply Archive On Consistent Backup
Feb 15, 2011Actually, i have test database open in read only and i want to apply archive files carry from production database at daily level.
When i'm going for recovery, since database is already in consistent state, it is not asking for recovery.
RMAN Archive Log Backup
Mar 27, 2013We are having an intermittent problem related to failing RMAN archive log backups. Normally everything works fine but once every fortnight or so the archive log backup starts to fail with the below message. We run two Oracle instances on this windows box, so they are using same oracle and TSM client binaries, but it is only of the instances that have this problem - the largest instance though. Restarting the Oracle instance solves the problem and everything is back to normal, until next time ...
This is the error message in the rman log file
CODERMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on c1 channel at 03/27/2013 11:00:29
ORA-03113: end-of-file on communication channel
Alert log contains this
CODEWed Mar 27 11:00:27 2013
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E, 000000007716324E]
Errors in file R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\trace\sdc002_ora_12328.trc (incident=523573):
ORA-07445: exception encountered: core dump [PC:0x7716324E] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E] [UNABLE_TO_READ] []
Incident details in: R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\incident\incdir_523573\sdc002_ora_12328_i523573.trc
Trace file
CODE
Trace file R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\trace\sdc002_ora_12328.trc
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Windows NT Version V6.1 Service Pack 1
CPU : 40 - type 8664, 20 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:85656M/147445M, Ph+PgF:96175M/157683M
Instance name: sdc002
Redo thread mounted by this instance: 1
Oracle process number: 57
Windows thread id: 12328, image: ORACLE.EXE (SHAD)
*** 2013-03-27 11:00:27.255
*** SESSION ID:(530.31175) 2013-03-27 11:00:27.255
*** CLIENT ID:() 2013-03-27 11:00:27.255
*** SERVICE NAME:(SYS$USERS) 2013-03-27 11:00:27.255
*** MODULE NAME:(rman.exe) 2013-03-27 11:00:27.255
*** ACTION NAME:(0000001 STARTED1) 2013-03-27 11:00:27.255
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E, 000000007716324E]
*** 2013-03-27 11:00:27.473
Incident 523573 created, dump file: R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\incident\incdir_523573\sdc002_ora_12328_i523573.trc
ORA-07445: exception encountered: core dump [PC:0x7716324E] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E] [UNABLE_TO_READ] []
I have the incident file as well if that is of any use.
Could the problem be related to running two backups in parallel?
We run full backups once a week and both this time and last time the archive log backup failed it was in conjunction to when the full backup also was running.
Is there any other solution to the problem than restarting the oracle instance?
Since this is a busy production instance it is a big problem for us to restart it outside of maintenance windows.
RMAN :: Archive Log Backup
Feb 13, 2013We have 100 archive log files out of that 20 archive log file are deleted, We want take full Database backup plus archivelog files using RMAN
Is it possible to take backup without 20 archivelog file using RMAN?
Is it possible to take full database backup with 80 archivelog file using RMAN?
Backup & Recovery :: RMAN Recovery Failing With Incremental Level 0 Backup
Feb 10, 2011We are trying to restore a database on the different server using RAM incremental level 0 and 1 backups. We have weekly Incremental level 0 backups along with incremental backups on daily basis. During recovery of Incremental level 0 backup, RMAN is expecting/looking for Incremental Level 0 backup of prior week as well. Is this the usual process for RMAN to look for prior level 0 backup though we need to restore from the current level 0 backup and roll forward by a week with subsequent Level 1 backup.?
We intend to restore from the Level 0 of 1/16 and roll forward with daily incrementals till 1/22. RMAN is expecting level 0 backupsets from 1/9 backup as well and keep failing since those backups are not available. quick inputs since we are in middle of recovery and trying to resolve if this is even doable.
RMAN :: Incremental Backup - Archive Log?
Jun 6, 2012We are going to implement oracle 11g. Now I wanna use rman to take the incremental backup in the follwing way:
Level-0 backup weekly, in the way:
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
BACKUP incremental level 0 DATABASE
TAG 'Weekly_full' FORMAT 'E:RMAN_backupweekly_full_%d_%Y%M%D_s%s_p%p.bak';
backup archivelog all not backed up 1 times delete input
TAG 'Weekly_full_arc' FORMAT 'E:RMAN_backupweekly_full_arc_%d_%Y%M%D_s%s_p%p.bak';
[code].....
and RETENTION POLICY TO RECOVERY WINDOW is set to 10 days, so that there is no chance that i will delete expired backup before taking backup.
Now my question is,
1) Is the way is correct that there is no wrong configuration. My main concern is about archive log, is it correct?
2) As i am deleting archive log files with the backup and after that the expired archive log backup is also deleted, so is there any chance of failure in recovery.
3) here how archive log backup will work with 10 days retention policy.
Backup & Recovery :: How To Extract Archive Log Backup Set
Jun 1, 2012There is a archive log backupset,and the backup set contains many archive log file,and now i want extract to a directory,how can i do?
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3 86.20M DISK 00:00:21 02-JUN-12
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20120602T113622
Piece Name: /u02/rman_bak/20120602/archive_log_t784899382_s4_p1
Backup & Recovery :: Backup Archive Log Files
Aug 4, 2011I have one question to clarify regarding backup.
There is an incident that in production database 1000 archive log files generated.From 1000 files, 100 archive log files have been removed.When i take incremental backup next day , what will happen in database?
Recovery Manager (RMAN) :: Not Deleting Archive Logs
Aug 6, 2012I have Oracle 10gR2 database on a windows server, I have scheduled rman backup for this database from Solaris server
set echo onrun {
crosscheck archivelog all;
backup check logical database plus archivelog;
delete noprompt obsolete device type DISK;
}
exit;
It is deleting the obsolete backup pieces but it is not deleting old archive logs (obsolete archive logs) and it is not even showing old archives as obsolete when I check thru report obsolete
Backup & Recovery :: RMAN Using Target Database Control File / Separate Catalog Database
Mar 14, 2012How 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.
View 3 Replies View RelatedRecovery Manager (RMAN) :: Archive Logs Group By Dates
Apr 30, 201310.2.0.4
SLES 11
This is the folder groupings of our archivelog folder:
oracle@sdb51:/u01/app/oracle/flash_recovery_area/PROD/archivelog> ls -lt
total 32
drwxr-x--- 2 oracle oinstall 4096 2013-04-30 12:42 2013_04_30
drwxr-x--- 2 oracle oinstall 4096 2013-04-29 12:35 2013_04_29
drwxr-x--- 2 oracle oinstall 4096 2013-04-28 23:42 2013_04_28
drwxr-x--- 2 oracle oinstall 4096 2013-04-24 12:20 2013_04_24
drwxr-x--- 2 oracle oinstall 4096 2013-04-23 22:00 2013_04_23
drwxr-x--- 2 oracle oinstall 4096 2013-04-21 02:01 2013_04_21
drwxr-x--- 2 oracle oinstall 4096 2013-04-19 22:00 2013_04_19
drwxr-x--- 2 oracle oinstall 4096 2013-04-18 18:46 2013_04_18
Are there supposedly complete folder by dates each day? So I am missing archivelogs of 27th, 26th,25th, etc?
Backup & Recovery :: RMAN Backup Deleted Even Within Recovery Window
Oct 18, 2011I have problem on using "delete obsolete" in RMAN.
First, let describe my backup configuration.
1. Full backup every Monday (17-Oct, 10-Oct, 3-Oct, 26-Sep)
2. Incremental backup for other days
3. Enable autobackup of control file
4. Backup archive log every day
5. RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS
6. Execute "Delete obsolete" every day
7. control file is used instead of catalog
The results observed:
1. Backup of control files older than 30 days will be deleted
2. Backup of archive log files older than 30 days will be deleted.
3. Backup of datafiles older than ~14 days but before 30 days are also DELETED.
In my example, the backup of datafiles created at 26-Sep is deleted at 16-Oct.
I tried "restore database validate until time "sysdate-22"" at 17-Oct. And RMAN reported "datafile xx will be created automatically during restore operation". It seems that RMAN failed to do restoration up to 22 days ago. The retention policy I set seems not effective on datafile backups.
I checked view v$backup_set and the "Keep" is "No" and "Keep until" is empty.
The only thing I can think of, is the settings of "CONTROL_FILE_RECORD_KEEP_TIME". It is marked "7" in the Oracle, which is less than the retention. But I suppose this only causes the backup not deleted, but NOT be deleted earlier.
Backup & Recovery :: Restore With Archive Log Only
Aug 9, 2013We have a 9.2.8.0 database in archive log mode. We want to restore that db to a specified point in time. What is the fastest way to do it ?
View 3 Replies View RelatedBackup & Recovery :: Keep Archive Log All The Time?
Jun 6, 2012after backup a full database ,the archive log need to keep all the time ?
View 3 Replies View RelatedBackup & Recovery :: Archive Log Format
Jun 9, 2012The log_archive_format parameter is set to %t_%s_%r.dbf,but the archive log is generate as o1_mf_1_10_7x6lby27_.arc, why?
SQL> show parameters log_archive_format;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.dbf
[oracle@hxl 2012_06_09]$ ls -lr
total 93468
-rw-r----- 1 oracle oinstall 51229184 Jun 9 10:00 o1_mf_1_9_7x5ckqbv_.arc
-rw-r----- 1 oracle oinstall 43131392 Jun 9 09:01 o1_mf_1_8_7x581vgo_.arc
-rw-r----- 1 oracle oinstall 74240 Jun 9 21:06 o1_mf_1_11_7x6lksyp_.arc
-rw-r----- 1 oracle oinstall 1131008 Jun 9 21:02 o1_mf_1_10_7x6lby27_.arc
Backup & Recovery :: Restore Archive Log
Aug 18, 2011I need to restore few archivelog from one of stage database to refresh dev database.
Stage database got refreshd before try to restore the arch files.
Now stage database does not contain arch sequence information.
I tried to restore arch fiels from tape using catalog connection. Is there any way to restore
channel c1: sid=521 devtype=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2007071006)
Starting restore at 18-AUG-11
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/18/2011 09:20:21
RMAN-06004: ORACLE error from recovery catalog database:
RMAN-20242: specification does not match any archive log in the recovery catalog
RMAN :: How To Backup Archive Logs In Standby Database
Nov 15, 2013I trying to backup archive logs using rman in standby database. I'm able to backup archive logs using simple command it get's successfully completed. rman > BACKUP ARCHIVELOG ALL When i'm trying to do with keep command it's getting failed.I'm trying to do on physical standby databaseBACKUP ARCHIVELOG ALL KEEP UNTIL TIME 'SYSDATE+100' TAG = 'TEST'.
View 1 Replies View Related