UKOUG conference day 1 and to my eye there does not seem to be that many differences between Manchester Central and Birmingham ICC. Lots of smaller halls and a large main hall, a similar lunch available, the same lack of seating. I understand that attendance is seen comparable as (more...)
So there I was, looking for a script to calculate the backup size. After several thoughts, it was not exactly what I was looking for.
Here’s the one I created.
SELECT TO_CHAR(completion_time, 'YYYY-MON-DD') completion_time, type, round(sum(bytes)/1048576) MB, round(sum(elapsed_seconds)/60) min FROM ( SELECT CASE WHEN s.backup_type='L' THEN 'ARCHIVELOG' WHEN s. (more...)
First and foremost, thank you to all the bloggers sharing their knowledge.
Free Block Corruption is from a data file block which is now Free but used (more...)
Here are 2 good documents for reference:
Merged Incremental Backup Strategies (Doc ID 745798.1)
Oracle Backup and Recovery for a VLDB
You can find my playing around here
I did find the results of switch database to copy awkward with the data file name.
LAX:(SYS@db01)> show parameter db_create NAME (more...)
So there I was, reading on the internet about having set echo on for RMAN and started to incorporate it into RMAN scripts.
It was a waste of time since it is not needed according to my test cases.
Lesson learned is that don’t trust what is provided to you (more...)
rman target /
Recovery Manager: Release 22.214.171.124.0 - Production on Wed Sep 18 20:47:38 2013
When I read the list of 12c new features the one that interested me immediately was the ability to be able to recover a table from an RMAN backup. This seemed to be quite challenging as RMAN is an image copy of blocks and a table is normally copied using (more...)
I want to cover ASM to non-ASM (more...)
So there I was, working on a request for how to restore from a specific backup.
Since the backup was using TAG, the easy solution is:
start database mount.
restore controlfile from autobackup
startup mount database
restore database from tag ‘TAG’;
recover database / recover database until sequence
open database (more...)
So I’ve performed some tests and decided to (more...)
RMAN backup keeps the backup metadata information in the reusable section of the controlfile. Its depends on the parameter CONTROL_FILE_RECORD_KEEP_TIME. CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused. In the … read more
Creating Recovery Catalog … 1.Create Tablespace: Create tablespace RCAT_TBS datafile ‘/u02/oradata/rcatdb/RCAT_TBS01.dbf’ size 500M; 2.Create the Recovery catalog schema/owner: SQL> CREATE USER rcat IDENTIFIED BY rcat DEFAULT TABLESPACE rcat_tbs TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON rcat_tbs; User created. SQL> GRANT CONNECT, … read more
We usually need to duplicate our databases to test servers which have different disk layouts than production server. So we need to distribute the datafiles according to the disk space and directory structure of the new server. It becomes a time-consuming task if you’re dealing with hundreds of datafiles. Today (more...)
Flashback database is not enabled by default so first step would be to enable it. When enabled a process RVWR (Recovery Writer) copies modified blocks to flashback buffer. Later this buffer (more...)
But I think it’s much better (more...)
When the 126.96.36.199.1 release of the Exadata Storage Server software was released, I was a little excited. There were numerous oneoff patches for the previous release, 188.8.131.52.0, which was the first version to support the Exadata X3, writeback flashcache, run UEK on the X#-2 systems, etc. With that many large changes introduced in one version, it was likely to see some bugs in the .0 release. Fortunately, Oracle was quick to fix many of those issues, but it resulted in several separate patches to update the cellsrv software.
I was working with (more...)
Recently, I’ve asked to help a client who was having doubts about their backup strategy. The client was considering image backup of database which would be constantly recovered and backed up to tape on the daily basis, by using “backup recovery area” command. However, there was a problem: there is no “restore recovery area” command. The utility to restore the recovery area seems to be missing, thus the name of this article became “The Case of Missing Utility”.
So, let’s see some definitions. This is what the client has envisioned:
RMAN> backup incremental level 1 for recover of copy database;
I have announced my webinar on Oracle ZFS Storage Appliance for Exadata Backup & Recovery in NYOUG DBA webinar series. You can download webinar slides and voice recod from NYOUG web site