RMAN

When Almost Everything of a Database is Missing

by Ed Chen
January 21, 2013May 31, 2023

I must assume that your Oracle software installed on OS is ready or not damaged before proceeding, otherwise, you should fix the software problem first.… Read More »

When Some of the Archived Logs are Missing

by Ed Chen
January 20, 2013April 15, 2023

If the missing archived logs are created before at least one database backup sets, there would be no problem at all while restoring a database.… Read More »

RMAN Configuration Under Nomount

by Ed Chen
December 31, 2012March 29, 2022

Did you have ever noticed that? RMAN can show the configuration when the controlfile is not mounted. See the demonstration below: [oracle@primary01 ~]$ rman target… Read More »

How to Perform Database Point-In-Time Recovery

by Ed Chen
December 30, 2012August 28, 2023

Sometimes, DBA may want the database back to a specific time just before a big mistake happened on the database. This is called database point-in-time… Read More »

When Several Datafiles Are Missing - Restore From Local Backups

by Ed Chen
December 29, 2012April 24, 2023

When several datafiles are accidentally deleted, we can use RMAN to restore and recover the datafiles individually. List the backup we have now. [oracle@primary01 ~]$… Read More »

When the SPFILE is Missing

by Ed Chen
December 28, 2012May 31, 2023

When you met the following situation, you are about to restore the spfile for your database. SQL> startup open; ORA-01078: failure in processing system parameters… Read More »

How to Restore Controlfile

by Ed Chen
December 27, 2012June 14, 2023

When the controlfile is missing, the database can't mount the controlfile, you need to restore the controlfile before going further. But first of all, you… Read More »

How RMAN Set NLS_DATE_FORMAT

by Ed Chen
October 9, 2012April 23, 2023

NLS_DATE_FORMAT for RMAN After you set RMAN log location, the next problem that you want to solve is the format of timestamp in the log,… Read More »

3 Ways to Set RMAN Log Location

by Ed Chen
October 9, 2012December 11, 2022

RMAN Log Location RMAN is a client side utility like sqlplus used to interoperate with DB, we usually compose a script file or a batch… Read More »

When RMAN met Resource Manager

by Ed Chen
October 9, 2012June 20, 2023

Users notified DBA that they found AP responded longer than normal starting from 22:00 everyday, especially when a period of running RMAN on the host,… Read More »

JavaScript is not enabled. Please enable it and reload the page.