-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
When AUTOBACKUP is turned on Oracle will create backup of controlfile and spfile. When one runs backup of the database… READ MORE
Using the debug option one can turn on trace information, this can be used to troubleshoot an issue. Example: $ORACLE_HOME/bin/rman… READ MORE
Steps if you need to restore all datafiles in a tablespace is corrupted so you would need to restore the… READ MORE
To take backup manually or when cloning a database using the following SQL one can place the database in backup… READ MORE
If archive logs are missing RMAN will fail with the following error also in cases when the archive logs are… READ MORE
Using the steps below one take cold backup using RMAN. As it’s a cold backup the database as the database… READ MORE
To find RMAN catalog version log-in to the catalog through SQL*Plus and query the table rcver will print version. SQL>… READ MORE
1) Create tablespace for example name catalog_tbs 2) Create user for example user rman_catalog and assign catalog_tbs as default tablespace… READ MORE
Using CLEAR one can set the retention policy to default and using NONE have no retention policy. The example below… READ MORE
control_file_record_keep_time – the value indicates number of days before reusable record is overwritten, if set to 0 reusable record is… READ MORE
When doing a incomplete recovery (i.e. database is open with resetlogs) and when running RMAN to backup that database after… READ MORE
One of the scenario we ran into when one of the data file reported there was block corruption as RMAN… READ MORE
If one is keeping archive logs available on disk and also have them archived to tape and would like to… READ MORE
Using the following rman command one can setup to keep 2 days of archive log on disk and also archive… READ MORE
If one needs to restore archive logs to disk and not apply them, for example in case when cloning a… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 