Hot answers tagged

7 votes

Right way to delete the archive - Oracle

In order to delete them you can do: RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; , you can also include the delete input clause when you back them up, and they ...
user avatar
6 votes
Accepted

RMAN - no datafile found during recovery

Asking the database to do the impossible. You changed the TAG, so you created a new initial set of image copies. As diskspace was becoming increasingly tight, I changed the backup script to use ...
user avatar
  • 38.2k
6 votes
Accepted

RMAN - How to add date in backup tag

Construct the tag in your script and pass it as a substitution variable. Example on Linux with bash: $ cat BKP_FULL.rcv run { backup as compressed backupset incremental level 0 database tag '&1'...
user avatar
  • 38.2k
5 votes

Right way to delete the archive - Oracle

If RMAN doesn't know about the archives on disk (were copied from some other location), then you can tell RMAN about the archive files via the catalog command: RMAN> CATALOG START WITH '/disk2/...
user avatar
5 votes
Accepted

Why bother with rman?

It is not the fault of RMAN if the person using it does not know how to configure the database. With RMAN you can: restore your database to any point in time in the past that your backups cover, not ...
user avatar
  • 38.2k
5 votes
Accepted

Oracle 11g Rman restore with another database name from backup in windows platform

By default, the controlfile is backed up with your data. This is turned on or off by this command: CONFIGURE CONTROLFILE AUTOBACKUP ON; But as a matter of habit, I usually follow my data backups ...
user avatar
  • 2,086
4 votes

How to restore operational Oracle 11g Database from full backup?

In short - yes, there are standard operating procedures for doing all of this with Oracle. You should start by looking into RMAN (Recovery MANager). I have put together a high level overview of RMAN ...
user avatar
  • 3,045
4 votes
Accepted

Delete backups from old incarnation in rman

I couldn't find any clause to the REPORT or LIST commands which would allow you to specify the incarnation of interest. You could however correlate your latest incarnation reset time with backup ...
user avatar
  • 3,075
4 votes

Possible RMAN orphan files in backup directory

Maybe those files are not cataloged by RMAN? I would CATALOG them and then DELETE OBSOLETE once again.
user avatar
  • 151
4 votes
Accepted

Oracle: duplicate schema to another database

Use expdp with the flashback_scn or flashback_time parameters, along with SCHEMAS= to export the schema at a consistent point in time. This is the same as using CONSISTENT=Y in the legacy exp utility....
user avatar
  • 30.8k
4 votes

Duplicate database leaves orphan archivelog files

The duplicate database ... from active database is designed to work without any existing backup. I would expect Oracle to clean up the archivelogs which were used during the clone process. So I would ...
user avatar
  • 1,309
4 votes
Accepted

what exactly does an RMAN backup do?

In the simplest case, when you restore a database, you tell RMAN to recover it to the most recent point in time by applying all the redo (archived and online) that is available. That will re-apply ...
user avatar
4 votes
Accepted

How to avoid Recovery Catalog's metadata being purged after 60 days?

This is described in the note: How to Clean up The information in EM Backup Report (Doc ID 430601.1) Edit recover.bsq, find the procedure cleanupRSR, change the default value 60 as needed: DELETE ...
user avatar
  • 38.2k
4 votes

What do these RMAN listings mean?

Re Column Indicates Key A unique key identifying this backup set. If you are connected to a recovery catalog, then BS Key is the primary key of the backup set in the catalog. It corresponds to BS_KEY ...
user avatar
  • 41
4 votes

Oracle database 11g - RMAN delete archive logs

maybe there aren't any! run this and see if there are any archivelogs older than 5 days list backup of archivelog all;
user avatar
4 votes
Accepted

Why are backups of a previous incarnation marked obsolete without regard to redundancy?

For The Interested RMAN Beginners The RMAN policies REDUNDANCY and RECOVERY WINDOW are mutually exclusive. This means you can either set one or the other. Redundancy Policy Having set REDUNDANCY 2 ...
user avatar
3 votes

RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?

Just completing the answer from @kubanczyk, which is very good. When you issue the recover database command, the RDBMS will try a complete recovery, meaning that it will look for the archived logs ...
user avatar
  • 282
3 votes

Exadata RMAN vs. Non-Exadata RMAN - any differences?

There are no architecture differences in RMAN itself. The difference is in the speed of the backups if written to the Exadata on-board storage. So the advantages that Exadata brings in terms of ...
user avatar
  • 118
3 votes
Accepted

Does restoring an Oracle backup of the whole database restore schema objects?

You're issuing a "recover database" command, which will recover the database as far as possible. If that includes the archivelogs/redo logs which contain your "truncate" command, then this will also ...
user avatar
  • 1,877
3 votes
Accepted

RMAN error RMAN-06207,RMAN-06208,RMAN-06210,RMAN-06211,RMAN-06212,RMAN-06213,RMAN-06214

Use crosscheck copy before deleting: RMAN>crosscheck copy RMAN>delete noprompt obsolete; Crosscheck on it's own (without copy) doesn't do anything. You could also have done: crosscheck ...
user avatar
3 votes
Accepted

RMAN restore from tag

Proper backup syntax should have been: backup database tag "first" plus archivelog tag "first"; Now if you look into your list backup output you can notice that only backupsets with archivelogs has ...
user avatar
3 votes
Accepted

Move PDB to a new host

Option 3. Unplug the PDB: Unplugging a PDB ALTER PLUGGABLE DATABASE salespdb UNPLUG INTO '/oracle/data/salespdb.xml'; Copy the files (XML + database files), then perform the checks listed below: ...
user avatar
  • 38.2k
3 votes

DB cloning on daily basis

This can be done in a few minutes with storage snapshots/cloning. If you can't do that, just go for RMAN duplicate. Both method can be scripted and scheduled to run automatically.
user avatar
  • 38.2k
3 votes
Accepted

Backup and Restore with RMAN Oracle 12c

This is absolutely normal when you try to perform a complete recovery from a hot backup, because that is how hot backups work, you will never have the latest changes in your backups. Your backup ...
user avatar
  • 38.2k
3 votes
Accepted

Restore data from an old rman backup - ORA-01152

Lets see the information provided by oerr utility. ORA-01152: file 1 was not restored from a sufficiently old backup Cause: An incomplete recovery session was started, but an insufficient number of ...
user avatar
  • 8,406
3 votes

Oracle 11g ORA-01190: control file or data file 1 is from before the last RESETLOGS

Since you've done an open resetlogs, you've changed the incarnation and are now trying to restore to a previous incarnation. From the Backup and Recovery User's Guide: The procedure for DBPITR ...
user avatar
  • 1,929
3 votes

Oracle 11g ORA-01190: control file or data file 1 is from before the last RESETLOGS

I always believe that the output given by oerr utility helps alot to resolve the problem. Oerr: Oerr is an Oracle utility that extracts error messages with suggested actions from the standard ...
user avatar
  • 8,406
3 votes
Accepted

Identify rman files and delete them

If the database does not know about those files, you should catalog them in RMAN: catalog start with '/path/to/files'; After that you can use your above commands for identifying or deleting these ...
user avatar
  • 38.2k
3 votes

List expiration dates of Oracle backups

Oracle, in contrast with the name, can not predict the future. If you have a retention policy configured as recovery window of 14 days or redundancy 2, the database does not know when your next full ...
user avatar
  • 38.2k

Only top scored, non community-wiki answers of a minimum length are eligible