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 ...
- 156
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 ...
- 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'...
- 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/...
- 1,098
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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.
- 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....
- 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 ...
- 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 ...
- 20k
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 ...
- 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 ...
- 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;
- 532
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 ...
- 15k
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 ...
- 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 ...
- 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 ...
- 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 ...
- 56
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 ...
- 1,732
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:
...
- 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.
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 38.2k
Only top scored, non community-wiki answers of a minimum length are eligible