Backup & Recovery :: Incremental Backup Level 1 Or Level 0 Without Archivelogs?
Oct 22, 2012
Can you take an incremental backup level 1 or level 0 without archivelogs?
syntax would bebackup as compressed backupset cummulative level 1 database.
The reason I ask is because when I run backup as compressed backupset cummulative level 1 database plus archivelogs # it runs fine, but when I run backup as compressed backupset cummulative level 1 database it just hangs.
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.
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.
Operating System - WindowXP oracle version 10.2.0.1
I was learning some recovery part in my home laptop. Database is in Archivelog, flashback mode. All of sudden, i deleted it from OS level with out taking backup of it.
When i tried to open database, it failed to start. Database is in mount mode.while trying to open, it gives message -
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: 'F:ORACLEPRODUCT10.2.0ORADATADBSYSTEM01.DBF'
I tried to create on file named "UNDOTBS01.DBF" but oracle is not recognizing it.
I am trying to practice some RMAN configuration settings.Version 11.2.0.1OS - Linux X86-64 What i wanted to validate is if there is no level 0 backup of database taken, then the level 1 backup will be automatically backing up all the blocks of the database(similar to full backup). RMAN> report schema; Report of database schema for database with db_unique_name DB101 List of Permanent Datafiles
I am not sure what these input bytes are which is not matching with the database size(posted in the beginning of thread)? why it has to show as db full when i actually run a incremental?
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.
I am using the following query to determine if my rman backup succeeded for failed. I look for "COMPLETED WITH ERRORS"
col input_type format a10 col bck_hrs format 99.9 heading "Run|Time" col status format a21 col end_dt format a20 heading "End|Time" col mbytes_per_sec format 9,999 heading "Output|Rate|MB/sec"
[code]...
output ======
End Run Output Rate INPUT_TYPE STATUS Time Time Size GB MB/sec ---------- --------------------- -------------------- ----- ---------- ------ ARCHIVELOG COMPLETED 2011-12-24 06:03:54 .5 189.4 106 DB INCR COMPLETED 2011-12-24 05:33:05 9.3 3,392.6 103 ARCHIVELOG COMPLETED 2011-12-23 10:12:27 .2 73.3 105
I know that the DB INCR is an INCR 0 backup but is there some way query I can join with my example above to tell me this is INCR 0 or FULL BKUP?
I was thinking maybe setting "COMMAND_ID" some text like INCR 0 or INCR 1 or FULL BKUP. Does that sound feasible
I have main database Server which is located on Server A, now I have to take the RMAN Backup of Server A and then shift the complete database on new Server B.
I am confused whether to use Backup command with AS COPY option or take the backup as backup sets. Which are the best option that I can use for the RMAN Backup.
I've a little question : Is it possible to use RMMAN to backup 2 tables incrementally ? I don't want to backup all the database but only these 2 tables.
I use kill -9 <pid> and kill the job and then i check ps -ef | grep rman and get no process of RMAN but when i login into Enterprise Manager and click on performance tab so i see the graph of RMAN (yellow in colour) which is still continue and means the RMAN backup is in progress , then i checked the top consumer page so there i see backup incr datafile(SYS$USERS)(26.8%), so i want to down this RMAN backup.i also used the this query to check the RMAN job running or not
select * from V$SESSION where MODULE like 'rman%'; it came up with no rows
2nd Incremental #1 Files updates between the 1st and 2nd - Monday 3rd Incremental #2 Files updates between the 2nd and 3rd - Tuesday 4th Incremental #3 Files updates between the 3rd and 4th - Wednesday 5th Incremental #4 Files updates between the 4th and 5th - Thrusday 6th Incremental #6 Files updates between the 5th and 6th - Friday 7th Incremental #7 Files updates between the 6th and 7th - Saturday 8th Full Backup #8 Files updates from 1st,2nd to 7th - Sunday 9th Incremental #9 Files updates between the 8th and 9th _ Monday 10th Incremental #10Files updates between the 9th and 10th - Tuesday 11th Incremental #11 Files updates between the 10th and 11th - Wednesday 12th Incremental #12 Files updates between the 11th and 12th - Thrusday 13th Incremental #13 Files updates between the 12th and 13th - Friday 14th Incremental #14 Files updates between the 13th and 14th - Saturday 15th Full Backup CRASHES - NOT COMPLETED - Sunday
I would need to restore now from #8 ( full backup ) and #9 to #14 ( incremental backup )
Tell me the "restore command" to achieve the output?
I'm running ora 11gr2 on windows environment and I got a doubt on a specific situation.
I have to locations for my rman bkps, A and B, which point to different devices, one local and the other remote.
Imagine I take a LEVEL 0 backup on day 20 pointing to both locations, A and B. On day 21, 22 and 23 I take a level 01 backup pointing just to the local destination A. On day 24 I take another LEVEL 0 backup pointing just to location A again....
Now, I want to take a level 1 backup to location B, just to backup the blocks changed since the backup level 0 taken on day 20, bypassing the blocks already taken on days 21, 22, 23...
Is that possible? To control the levels 01 backup from 02 different destinations?
Question: does oracle recover past the scn mentioned in the control file or do you need recover using backup control file for it? No specific scn,time specified.
Scenario: Restore database on new server + copy archivelogs from original to minimize data loss. Backup : 5 AM Archivelogs: 7 AM
New server: Configure dummy instance Restore spfile from tape Restore controlfile from tape: SCN 5AM Restore database (no scn specified) from tape: : SCN 5AM Copy archivelogs from old server to archivelog new location: SCN 7AM. Recover database open database -> SCN 5AM or 7AM?
Does it recover till SCN 5AM (controlfile) or SCN 7AM (latest scn in copied archivelog)
We have faced database(10.2.0) issue cause incomplete recovery and have performed open resetlogs. This DB is of 12Tb. In 10g opening database with reset logs do not invalidate previous backups. we have another replica(no reset state)of this database which we sync using archives.how we can apply those archives(reset database)to previous database?
Our client is having requirements that data should be encrypted through-out the process (from transaction level to backup level).
Requirements are as below -
1) Data should be encrypted and can be access only through application (through front end). 2) Even if pl/sql, sql installed, developer user cannot able to fetch data from database. 3) Even DBA, should not have access to fetch the data from the database. 4) Only assigned DBA, should fetch details from database (provided he/she should have details of database as well as application's user / password). 5) It should be restricted by ip and user details (such as ip of application server with user/password of user). 6) Changes should be purely done from database level only.
Oracle 11G...After creating a new datafile, it was accidentally deleted at OS level (AIX).Because it was new there are no backups of it.Now tablespace thinks there are 3 datafiles in it, but one of them is missing.
Is it possible to recreate an empty data file on-the-fly?It has let me set the datafile to offline, but wouldnt let me do anything else.
Now my backups are failing as it recognises :"the status of database file is RECOVER".
7 of days ago Full backup has been taken to disk due to issues with tape devices.3 days ago tape devices have been fixed and we switched to CommVault managed tape backups. CommVault calls RMAN with following command:
These backups done successfully.Then archivelog backup taken similar way.But when I issue RESTORE DATABASE PREVIEW SUMMARY; RMAN starts with Full backup set, though newer Incremental Level 0 ones are available.Why it does not use these newer ones?
I want to write a sql query which will fetch the data from manual_temp_master and manual_temp_detl.But from manual_temp_detl table, Price_bkt_cds columns should be displayed as columns. Like the should look like as below:
what is the difference on DBMS_STATS for table level and partition level , which will provide the best optimizer . If the table xxxx is partitioned from 1 to 10 ,then running gather stats on table xxxx as whole table level or partition level which will provide best result on the performance.
I 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)
I would like to rman command syntax only for the following scenarios.I have archivelogs the disk , sequence = 40, 41, 42 , 43and say, I backed up only sequence 41 file. next time I want to list (not backup) which archivelogfiles have not been backed up since the last backup (which was sequence 41 was backedup).I would like to be able to list 40, 42. 43 that needed to be backed up as a list in the RMAN. I understand that I can look at find from v$archived_log view and I can backup using (backup archivelog all not backed up 1 times to device type disk - i am ok with this).I need to be able to list the archivelogs that need backup from existing disk-directory of archivelog files from RMAN prompt.
by default backup area is FRA, It can be change by db_recovery_file_dest FRA contains archivelog ,backupset,datafile,onlinelog folders..
NOW, i specially want to change backup dest. of archvelog to C: (suppose i have C , D, E, F , G) - (i know for archivelogs its log_archive_dest_N command can backup copies to other location but it also goes to default FRA )
backupset to D: datafile to E: onlinelog to F: controlfile to G: ALL SHOULD CONTAIN ONLY 1 DESTINATION NOT 2 FOR BACKUPS
I 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.