Backup & 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
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 :: 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.
Backup & 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 :: 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?
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 :: 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
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 View RelatedBackup & 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 :: Creating Archive Log In Network Drive?
Jul 29, 2011create Oracle archived log to network drive instead of Local drive.
Is there anyway that i can get my archive log created on network drive instead of local drive.
As we want to save our storage space and want to keep archivelog on network.
Is there a way that if Archive log creation on Network drives falis, Oracle create Archivelog on Local drive.
We are running Data warehouse and on daily basis we have 22 to 25 Gig of Archive log created
Backup & Recovery :: Change Archive Log Mode During DB Running?
Aug 24, 2011changing archive mode during DB running.Before in 9.2, 'ALTER SYSTEM ARCHIVE LOG START/STOP' is available for this job. But, after 10g/11g, it cause 'archive log stop has been deprecated'.
However, for my practice, I need to estimate archived logs size before backup them, so I need to stop archive log for a while and enable it later during DB running.
I check Oracle documents, it only mentions changing archive log mode at DB mounted but not open.
Backup & Recovery :: How To Change Archive Log Destination In Oracle 10g
Jan 11, 2013I want to change my archive log destination currently my database its in archive mode and this archive log detail as under
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination F:archivelogs
[Code]...
this my f drive space is full so i want to change this my archive destination to my another g drive so how can i do this.and if i change this my archive destination does its affect any problem while recover my database in future.
Backup & Recovery :: How To Check Archive Log Destination Utilization In Oracle 9i
Oct 24, 2011Is there any view in oracle 9i like V$RECOVERY_FILE_DEST where we can check the archive destination space utilization from database end ?
View 5 Replies View RelatedBackup & 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 :: RMAN Duplicate Set Until Time Using Wrong Backup Piece Name To Restore?
Feb 26, 2012We are doing RMAN Duplicate set until time to refresh daily our test database for our developers and it taking long time to finish. We noticed on the restore log that RMAN was using a day old old backup pieces to refresh the test database and don't immediately use the latest backup pieces instead.
For additional details here's the rman duplicate command we are using which we run daily(mon-sat) at 4am once daily full backup on production completed.
RMAN Duplicate commands:
run
{
set until time "to_date(to_char(sysdate,'Mon DD YYYY') || ' 04:00:00', 'Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
duplicate target database to testdb;
}
exit
Is there a way on how to let RMAN use the latest backup pieces instead?
Backup & Recovery :: Restore Time Based Recovery
Apr 28, 2011How can i take a cancel based recovery and time based recovery using rman. ?
View 3 Replies View RelatedBackup & Recovery :: Possible To Maintain Real Time Backup Using RMAN?
Mar 16, 2011Is it Possible to Maintain real Time Backup using RMAN ?
View 39 Replies View RelatedBackup & Recovery :: RMAN - Time Interval Backup And Restore?
Mar 27, 2012I have been updating data in my database by adding numerous rows and assume the insertion of rows started from 1st date of january month.
I have been entering somehow or the other part of data every day.And now the date is 25th of january.
How can i take a partial backup of my database of the transactions done between 15th of January to 20th of January Month
How to take Backup of a particular date say it be 12th of january month.
How to take backup of first 10 days i.e., 1st-10th of january.
Backup & Recovery :: Perform TSPITR Of Tablespace To Recover It To A Time
Apr 5, 2011 Imagine this situation
Current time :05 Apr 2011
I have to perform the TSPITR of a tablespace to recover it to a time 03-apr-2011 5 pm.Now I have done that.
Now I find that I need to actually recover it ti 04-apr-2011.Can I again recover the tablespace to 04-Apr after recovering it to 03-Apr by mistake I am not usng recovery catalog;
Backup & Recovery :: RMAN Command Hang Long Time?
Mar 20, 2012We would take backup regulary by RMAN(catalog). Last two days we could not take backup. Backup start but after take backup some datafile then rman does not do anything.
View 4 Replies View RelatedBackup & 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.
Backup & Recovery :: ORA-16004 / Backup Database Requires Recovery
Oct 20, 2011Here is the details
[oracle@localhost dbs]$ export ORACLE_SID=stby
[oracle@localhost dbs]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 20 09:47:34 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> !
[oracle@localhost dbs]$ pwd
/oraeng/app/oracle/product/10.2.0/dbs
[oracle@localhost dbs]$ exit
exit
[code].....
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 :: SCN Based Backup Do RMAN Generate Backup From Archivelogs
Oct 18, 2012understanding rman scn based Backup Algorithm .. In SCN based backup do rman generate backup from archivelogs ???
View 1 Replies View RelatedRecovery Area Cannot Be Used For Archive Log?
Sep 13, 2013I`m using the the version 11.0.2.3 for testing. I read a line as below from the OCP book.
If none of the LOG_ARCHIVE_DEST_n parameters have been set, then transitioning. the database to archivelog mode will internally set LOG_ARCHIVE_DEST_10 to the flash recovery area, if it has been configured. In my database the fast recovery already been set as below.
SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FASTRECOVERY
db_recovery_file_dest_size big integer 4248M
So I thought if I turn the database into archive log mode, then the log_archive_dest_10 will be set as the same value as db_recovery_dest.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> show parameter log_archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
See, after the database become archive, the log_archive_dest_10 still be empty. So is there any thing wrong with my understanding?
Backup & Recovery :: 2 Separate RMAN Backup One Backup Is Of Only Datafile
Jan 24, 2011I have 2 seperate rman backup one backup is of only datafile ,spfile and controlfile which i am able to restore and recover without any problem say bkp1 taken at 10 am
other set of backup is of only archive log files of same day but later time than datafile backup say bkp2 taken at 8pm...if i restore and recover bkp1 and try to restore bkp2 it gives error datafile exist (possibly due to fact both backup have control file)
if i just restore bkp1 and try to restore bkp2 so that i can do one recover at time
it gives error datafile permission issue (possibly due to fact both backup have control file)
I want to restore database upto 8pm time how can i use both bkp1 and bkp2 to do it(restore datafiles and apply all archive logs on it)
Backup Of Archive Files
Dec 1, 2010I 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?