-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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
|
As RMAN needs a consistent view of the control file it takes a backup of the controlfile by creating a… 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
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
Using the steps below one can find the object that is unrecoverable from UNRECOVERABLE_CHANGE# in the v$datafile, one would use… READ MORE
If one needs to restore archive logs to disk and not apply them, for example in case when cloning a… READ MORE
As part of the RMAN script during backup to disk for example you may have a statement to delete the… READ MORE
|
Using block tracking one can improve performance of the backup time of incremental backup from hours to minutes depending on… READ MORE
|
One can check syntax for RMAN commands without running the RMAN. Example: Checking syntax of commands on the command line.… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 