-
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
In 10g oracle has introduced the concept of recycle bin one can recover tables that were dropped. When a table… 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
|
As RMAN needs a consistent view of the control file it takes a backup of the controlfile by creating a… READ MORE
In 10g using dbms_flashback one can flashback using timestamp or SCN. If a user accidentally deletes rows or updates rows… 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
“Control what I can control”
~ Alex Lima
Alex Lima 