Backup & Recovery :: RMAN - Missing Archive Logs Files
Oct 7, 2012
We 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.
View 9 Replies
ADVERTISEMENT
Jan 11, 2008
I 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> }
View 4 Replies
View Related
Dec 9, 2012
We are using the following commands to take hot backup of our RAC database. Hot backup is fired by "backup" user on Linux system.
=======================
rman target / nocatalog <<EOF
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$backup_dir/$date/%F';
run {
allocate channel oem_backup_disk1 type disk format '$backup_dir/$date/%U';
#--Switch archive logs for all threads
[code]......
=======================
Due to which after command (used 2 times) "sql 'alter system archive log current';" I see the following lines in alert log 2 times. Because of this all the online logs are not getting archived (Missing 2 logs per day), the backup taken is unusable when restoring. I am worried about this. I there any to avoid this situation.
=======================
Errors in file /u01/oracle/admin/rac/udump/rac1_ora_3546.trc:
ORA-19504: failed to create file "+DATA/rac/1_32309_632680691.dbf"
ORA-17502: ksfdcre:4 Failed to create file +DATA/rac/1_32309_632680691.dbf
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
=======================
View 1 Replies
View Related
Aug 6, 2012
I 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
View 7 Replies
View Related
Apr 30, 2013
10.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?
View 7 Replies
View Related
Nov 15, 2013
I 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
Nov 8, 2008
Is 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]....
View 27 Replies
View Related
Aug 4, 2011
I 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?
View 10 Replies
View Related
May 30, 2012
How can be identify a particular archive-log file have backup or not from rman catalog?
View 2 Replies
View Related
Feb 1, 2012
When we see archive log destination is full , in that case how to backup archive log files using RMAN ?
View 1 Replies
View Related
Apr 23, 2013
While Configuring Data Guard for ORacle 10g (10.2.0.4) 64 bits on Windows 2007 Server 64 bits.I got few questions
1. What is the Default mode of Standby Database?
2. Should we Always Start Physical Standby Database to Recover Missing Redo Archive Log?
SQL> startup mount;
ORACLE instance started.
Total System Global Area 591396864 bytes
Fixed Size 2067496 bytes
Variable Size 163578840 bytes
Database Buffers 419430400 bytes
Redo Buffers 6320128 bytes
Database mounted.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
3. When there are missing Redo Log Archives e.g.
----On Standby Database--------
SQL> SELECT RESETLOGS_ID,SEQUENCE#,STATUS,ARCHIVED FROM V$ARCHIVED_LOG
2 ORDER BY RESETLOGS_ID,SEQUENCE#;
RESETLOGS_ID SEQUENCE# S ARC
------------ ---------- - ---
812980008 15 A YES
812980008 16 A YES
812980008 17 A YES
812980008 18 A YES
[code]....
65 rows selected. Log 8, 9, 10, 11, 12, 13, 14, 15 are missing.
How to Apply / Recover These Logs on Standby Database?
View 11 Replies
View Related
May 8, 2013
Is it possible to recover files from backup tapes which are gone obsolete (as per retention policy)?
View 4 Replies
View Related
Mar 27, 2013
I took backup of Datafiles , archivelog files and controlfile through RMAN. Now, i want 3 backup file will created as a output of RMAN operation. It would be :
1 backupfile for all the datafiles
1 backupfile for all the archivelog files
1 backupfile for controlfile.
It have to be regardlessly whatevr my DB size is. It it possible to do so. How i can can write rman script to accomplish the task.
View 7 Replies
View Related
Aug 26, 2013
I have an environment in which backup is performed of Oracle 10/11 databases with the use of RMAN and Tivoli Storage Manager (Data Protection for Oracle).There are several databases and for every one there is a daily full backup and hourly archive logs backup.
Sometimes when full db backup takes longer (up to 4 hours) archive logs backups are missed - as TSM node cannot perform two backups at a time. I would like not to have those missed backups.
Option A was to delete association of the arch log scheduler during full backup. But when removing association we lose historical data about backup. And we need historical data to be able to create weekly / monthly / quarterly statistics of completed backups. We need to have 99% completed.
Option B was to create two nodes in TSM (TDPO) and one will do full backup only and another one only arch logs backup. So the problem is moved to RMAN. But from RMAN specialist I heard that this may cause problems with full backup. During full backup also archive logs are backed up (at the start and end) so there might be a problem with accessing the file that is used by another process. And this may cause problem with full backup - which we want to avoid especially.
View 3 Replies
View Related
Aug 30, 2012
My oracle database is 11.2.0.2 RAC RDBMS on RHEL 5.6
We recently created physical standby database. How do we delete standby archive logs from physical standby?
View 2 Replies
View Related
May 10, 2011
My supervisor wants to remove all the archivelogs since it was just a test for 1 year the DB is not actually YET been used. Problem is they want it to be used as soon as possible w/o recreating again the database and just removing some data on tables and removed archive logs. how to safely removed the existing archived logs and create a full backup with archived fresh to sequence 1.
View 2 Replies
View Related
Jun 8, 2012
As per Client requirement, i need to configure archive log and backups in flashback.
View 3 Replies
View Related
Jul 26, 2013
I am trying to remove archive log file on my standby site but I am getting the following message. There are lots of archive logs are present on the storage but rman is unable to displaying that.
RMAN> list archivelog all;
specification does not match any archived log in the repositoryRMAN>
View 7 Replies
View Related
May 13, 2011
Backup entire database, without archived logs, while the database is open for user activity and also This backup should be the base for an incremental backup strategy.
View 10 Replies
View Related
Dec 1, 2010
I am running the following command to backup my archive logs and want to keep at least two hours of .arc files on disk.
rman < connect target login/password
connect catalog login/password
show all;
sql "alter system archive log current";
backup filesperset 5 archivelog until time 'sysdate-2/24'
format $FILE_DEST_ARCH
delete input ;
resync catalog;
EOT
On some occassions, there will not be any archive logs that meet this criteria and I get the following error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/01/2010 12:50:58
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specificati
on does not match any archive log in the recovery catalog
Is there anything I can do to the rman command above that will prevent this error from happening but yet keeping same functionality?
View 2 Replies
View Related
Jul 28, 2013
Assuming you have a 9i database . where you have it enabled in archive mode , yet constantly deleting the archived redo logs , due to space constraints .
Will you be able to perform a full level 0 backup , and the following incremental backups , in the absence of the archived redo logs ? And are these incremental backups enough to recover the database or particular data files , to the point of the backup itself at least ?
View 5 Replies
View Related
Feb 10, 2011
I want to do the recovery of my database using the archive log files but one of the archive log in between is missing,
View 17 Replies
View Related
Jul 25, 2012
URL....I'm practicing for the OCP test and one of the questions is that there is a backup from yesterday and the last archived logs are from the day before yesterday not mentioned if it's cold or hot backup.
If its a cold backup - cant we recover it? is it a must to have the archived redo logs also when recovering a cold backup? That sounds not logical since those logs are made only for a hot backup. URL.....
View 1 Replies
View Related
Jan 6, 2013
I am making incremental backups via RMAN, the backups are staying at disk. And the infrastructure team will copy this files backups to tape. And they want delete the files that will staying in disk via RMAN. Until now it's ok.
But and if I need of backups that stay on tape, it's possible make a recovery of deleted files by rman.
View 3 Replies
View Related
Feb 15, 2011
Actually, 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.
View 2 Replies
View Related
Mar 5, 2013
what type of storage systems used for saving archive files and backup files "especially for oracle databases"
View 5 Replies
View Related
Mar 27, 2013
We 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.
View 4 Replies
View Related
Feb 13, 2013
We 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?
View 7 Replies
View Related
Feb 10, 2011
We 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.
View 11 Replies
View Related
Jun 6, 2012
We 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.
View 10 Replies
View Related
