Backup & Recovery :: Restore Archive Log
Aug 18, 2011
I 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
View 3 Replies
ADVERTISEMENT
Aug 9, 2013
We 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 Related
Oct 14, 2012
Is there anyway to backup Flashback Data Archive (FBDA) data and can be restore on new database. I cannot find Oracle's document or any document explain about backing up this data.
View 6 Replies
View Related
Aug 13, 2013
My scenario is: database is in archivelog mode.
I run DLY cold backups including controlfile & archivelogs and keep 3 gens of backups and archivelogs to 3 days also. What is the correct procedure to restore back to an old cold backup. Database is backed up Mon,Tue,Wed on Thur we require to bring database back to Tuesday DLY security.
I have tried:
startup mount
restore database from tag 'DLYTUE'
recover database
( this just rolls forward on all archive logs once it restores datafiles, not getting to point to alter database open resetlogs.)
Next tried to :
recover database archivelog tag 'DLYTUE'
( same outcome )
What is the correct rman procedure including should I remove old archive logs from working OS directory ? Also need to know once I restore back and open database to TUE security how do you tidy up the archive logs and dumps which are no longer require i.e. : weds..
I have read about using the set until time option but how to I get absolute time from when cold backup completed if this is the correct procedure.
View 9 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 7, 2011
I have a doubt regarding the process the RMAN follows for restore and recovery of the database.
My Level 0 full backup completes on Saturdays at around 11 am after taking 8 hours (It starts at 3am).On Sunday, I ask RMAN to restore (on a different box) till Saturday 11:30 am.Then, after the restore is successful, I recover it till 11:45 am.
The recovery also goes fine and Iam able to clone to test box.
Till what time is the database restored? I assume its till 11 am since the L0 backup finishes at 11 am though I have asked it to restore till 11:30 am
During the recovery, ONLY the archives generated between Saturday 3 am and till the time i asked for recovery (Saturday 11:45 am ) are required. But, checking the recovery log file, i was surprised to see that RMAN has restored archive files starting from Friday 9:30 pm (Much before the time the Level 0 backup even started).
why does RMAN require the old archive log files.
View 4 Replies
View Related
Feb 26, 2012
We 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?
View 1 Replies
View Related
Feb 9, 2011
Is it possible to restore dropped table OR wrongly updated table using RMAN backup.
View 18 Replies
View Related
Jun 21, 2011
We are using Oracle 10g R2 in Windows Server 2003. I'm trying to restore a database in a new server, using RMAN backups.
Our external consultant configured RMAN scripts for full and incremental backups but never tested them . Since he just doesn't show up, I'm forced to tested them, restoring the whole database in a new server.
My instance is named MTDPROD, and I will create all from scratch.
At current server, RMAN files are generated in:
//192.168.1.149/g$/XXXSRV4-ArcLogs/MTDPROD/RMAN
At new server, I run all these commands:
C:>oradim -new -sid MTDPROD -intpwd mtdprod
Instance created
-- I created the relevant folder hierarchy under <ORACLE_BASE>
directory
-- Then, I created the relevant directories for Oracle Database, as
follows:
--a. Create BDUMP, CDUMP, and UDUMP directories under '<ORACLE_ BASE>
[code]....
By instance, I see a lot of this kind of files:
- FULL_MTDPROD_20110529_386_1.BAK
- INCR_MTDPROD_20110621_480_7.BAK
And only see these two files:
- C-2169285856-20110527-03
- C-2169285856-20110527-04
It seems that this C-2169285856-.... files only were on 27/05/2011 and then no more. However, the FULL_... and INCR_.. files are generated every day. The FULL is generated at the end of each month and INCR is generated every day.
This is the backfull.sql:
run {
allocate channel c1 type disk maxpiecesize=4G;
CROSSCHECK archivelog all;
backup
incremental level 0
format '\192.168.1.149g$XXXSRV4-arclogsMTDPRODRMANFULL_
[code]....
This is the backincr.sql:
run {
allocate channel c1 type disk maxpiecesize=4G;
CROSSCHECK archivelog all;
backup
incremental level 1 cumulative
format '\192.168.1.149g$XXXSRV4-arclogsMTDPRODRMANINCR_
%d_%T_%s_%p.bak'
[code]....
View 6 Replies
View Related
Nov 7, 2010
We have the requirement of performance testing of our proposed production platform, for this i am asked to take RMAN backup of clean position (Say Day0 or baseline backup) and restore it multiple times for few rounds of testing. My question is after 1st restore (with set until time of day0 position) if i open the database with resetlogs, would i be able to restore same clean backup again? I am using control file in the environment instead of RMAN catalog database. What i can do to make this scenario work? I am already in preperation of setting rman catalog database.
View 3 Replies
View Related
Feb 13, 2012
I am attempting to use an rman backup form our live server to restore live data over an existing dev database with a different name. I cant use the duplicate command as the versions of oracle are different (10.2.0.4 EE on live, 10.2.0.5 SE on dev) So I copied the backup sets including an autobackup control file onto the dev server. I set the ORACLE_SID to the DEV version (SUN43DEV) and startup nomount and restore controlfile from the backup location. This works and restored the live controlfile. However, I then wanted to mount the database and catalog the backupsets before making a note of the last archivelog etc and restoring the backup with set newname options. But when I try to mount the database I am told that the database has a different name (SUN43 is not SUN43DEV). I read somewhere that I need to set the ORACLE_SID to the live value (SUN43) and restore as that, then use nid TO RESET THE DBID and DATABASE NAME. However, my tnsnames on DEV has no entry for the live database, and we do not have any service defined through ORADIM for the live instance on the dev server. Should I be creating an entry in DEV tnsnames that actually looks at the LIVE server? or do I need to create a service and tns entry etc for SUN43 on my DEV server pointing at the DEV server I have not seen any mention in instructions of creating a service or adding the entry to tnsnames, or indeed adding an entry to the listener for the original live sid. I am worried that if I actually point to the live server then the restore would be attempted on the live server not dev even though I am running it from Dev.
Also, do I need to drop the existing database on DEV before I restore or will RMAN just restore over the top of it?
Finally, if I try to add an entry to the LISTENER.ORA for the new sid, when I stop and start the listener, or reload, the entry is not recognised. I also noticed that the existing SUN43DEV entry is not in there either, yet I can still use that SID - I am assuming that is because the listener is not being used and the sid is recognised from the existence of the service in windows services instead?
View 2 Replies
View Related
Jun 10, 2013
I am having a issue, we are trying to restore our db from control files using Symantec Backup exec, but job fails giving me error go to table spaces select all table spaces and unchecked roll forward.
i am unable to find way to uncheck the table spaces. Here is the complete description.
Cause
The system catalog tablespace "syscatspace" contains all of the system catalog information for the tables. Syscatspace needs to be rolled forward first, and then the other tablespaces must be rolled forward.
Solution
Workaround:
When the restore operation is run from a tablespace level backup, perform the rollforward for the syscatspace tablespace first and then for other tablespaces.
Execute the rollforward operation as a DBA operation. The sequence of the recovery process should be as follows:
1. Select all tablespaces, uncheck the rollforward option and run the restore job.
2. Run the rollforward operation as a DBA initiated operation:
rollforward syscatspace to point in time / end of logs. e.g. db2 => rollforward database UEXIT to end of logs and complete Tablespace (SYSCATSPACE) online
3. Perform rollforward of all other tablespaces.
e.g. db2 => rollforward database UEXIT to end of logs and complete tablespace (SYSTOO LSPACE,USERSPACE1) online
Refer to IBM DB2 documentation for more information on DBA-initiated operations.
View 9 Replies
View Related
Mar 13, 2012
1. My RAC (old RAC) had got a failures from one node, then there was only one existing node now.
2. I configured a RAC (new RAC) on 2 other servers, both of them (old-RAC and new-RAC) has got same OS version, platform and Oracle version release.
3. I took a full backup yesterday plus archivelog in the node of old-Rac, configure NFS in new-Rac to make the backup within remote-share NFS.
The only problem still now that I've restore/recovery/duplicated single instance, not Rac. So, may you guide me to do it?
Information:
Old-Rac & New-Rac:
+ Cluster 11g: CFS
+ Database: 2 nodes with same instance name (cbs1-cbs2)
+ Location for CRS_HOME and ORACLE_HOME: Same to be.
+ Location of archivelog: Same to be (+ARCHIVE)
View 1 Replies
View Related
Apr 28, 2011
How can i take a cancel based recovery and time based recovery using rman. ?
View 3 Replies
View Related
Dec 13, 2011
can we restore database from obsolete backup using rman
View 2 Replies
View Related
Jan 31, 2011
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.
View 1 Replies
View Related
Aug 1, 2012
I need to restore entire database(sp+control+datafile) to new host.I have started the instance with nomount( and it has created a dummy parameter file).Now, I need to fire the command to restore spfile.
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS='...';
RESTORE SPFILE TO PFILE '?/oradata/test/inittrgta.ora' FROM AUTOBACKUP;
SHUTDOWN ABORT;
}
My questions:-
1.How will RMAN find the location of backupset(Since there is controlfile for neither target or catalog database)?
2.How does RMAN reache the backupset in case of a)tape b)disk?
View 4 Replies
View Related
Mar 27, 2012
I 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.
View 7 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
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
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
Jan 31, 2011
n my last post I asked abt the issues that I was facing while restoring the full backup of RMAN on a new server. I mentioned the steps as well, Now my Question is what If I want to restore the incremental backup on the new server?
What all steps do I have to follow after restoring the zero level backup on a new server.
View 18 Replies
View Related
May 13, 2012
my restore scenario bellow.
I have hot full backup that processed by NetBackup Policy. the backup policy are;
1.Full backup database in Monday. Daily_Monday_RMAN <- 1 volume pool=1 media
2.Full backup database in Tuesday .Daily_Tuesday_RMAN <- 1 volume pool=1 media
3.Full backup database in Wednesday. Daily_Wednesday_RMAN <- 1 volume pool=1 media
4.Full backup database in Thursday. Daily_Thursday_RMAN <- 1 volume pool=1 media
5.Full backup database in Friday. Daily_Friday_RMAN <- 1 volume pool=1 media
6.Full backup database in Saturday. Daily_Saturday_RMAN <- 1 volume pool=1 media
How to restore database from one of medias?
View 5 Replies
View Related
Feb 10, 2011
I take hot backup of database at 10:00 am.After taking the hot backup 50 archived logs are created.Out of 50 i have backed up first 25 of them and at 5:00pm i lose complete database including control,data and the last 25 archived log files that were not backed up.So I am using latest hot backup to recover
I restore the control file backup and datafile backup taken during ho tbackup(10 am) and i issue the command
.......startup mount
>>>>>>>Recover database until cancel
!!!!!!! Apply the available 25 archive logs
then i give "cancel" since I dont have the next redo log .Now in which mode will the database open(Reset logs or no reset logs)
View 6 Replies
View Related
Dec 2, 2011
I ran the Full database backup as,
RUN {ALLOCATE CHANNEL CH0 TYPE 'sbt_tape';
BACKUP DATABASE FORCE PLUS ARCHIVELOG FORCE NOT BACKED UP DELETE INPUT;
RELEASE CHANNEL CH0;
}
Then I ran the restore, it failed with Quote:RMAN-06054: media recovery requesting unknown archived log....
When I backup archivelogs and choose to delete the input, it does not delete the multiplexed copy, but the specific file being backed up.So, ideally it should find it in Flah Area or at least in the backed up pieces which are there with it.Still why is it failing?
Also, in recovery, it is deleting the archived log after applying, RMAN does this if we use recover... delete archivelog command.I am using only RECOVER, still in output I can see RMAN deleting the log after it has applied it. WHY?
View 3 Replies
View Related
Dec 9, 2011
I want to restore control file from backup set,just as the flowing command,where location does the control file be restored to? how can i specify the location when restore control file?
restore controlfile from '/u01/rman_backup/mybak/df_768589733_7_1.bak';
View 2 Replies
View Related
Sep 7, 2012
i want to clone the test db to dev db but i dont want default users and tablespaces(SYS,SYSAUX,...) in the test db datapump and exp are not working, then contacted ORACLE support and they concluded that test db sysaux was corrupted.i took RMAN all tablespace bkup except default tablespaces. then created new database using DBCA and now i want to restore and recover all those test db tablesapces but while i'm doing restore its saying
RMAN> restore tablespace MAIN_DATA;
Starting restore at 07-SEP-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=129 device type=DISK
creating datafile file number=20 name=/opt/oracle/oradata/DEV71/main_data01.dbf
restore not done; all files read only, offline, or already restored
Finished restore at 07-SEP-12
i created all tablespaces in dev same as test db,
View 6 Replies
View Related
Jun 1, 2012
There 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
View 6 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
Jun 14, 2013
I would like get a copy of an oracle 10g database off the production server(windows 2003) and set it up on Windows 2003 virtual server to use for dev/testing.
What would be the safest and most efficient way.??
View 2 Replies
View Related
