| | Syntax to crosscheck archive logs in RMAN
Sometimes you end up with missing archive logs for whatever reason, and RMAN backup fails. Running crosscheck will fix the problem.
$ rman
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Sep 1 10:05:02 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: [SID] (DBID=[DBID])
RMAN> crosscheck ... | | More... 09/01/10 | | | | |
|
| | How to drop RMAN catalog
The drop command has to be run twice to drop RMAN catalog, i.e. (replace RMANDB with the database where you have RMAN schema installed):
rman catalog rman/rman@RMANDB
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Oct 7 13:55:42 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> drop ... | | More... 10/07/08 | | | | |
|
| | How to create RMAN catalog schema
1. Run the following commands in sqlplus:
$ sqlplus "/ as sysdba"
SQL> create user rman identified by rman
default tablespace tools
temporary tablespace temp
quota unlimited on tools;
SQL> grant connect, resource, recovery_catalog_owner to rman;
SQL> exit;
2. Run the following rman commands:
rman catalog rman/rman
RMAN> create catalog tablespace tools;
RMAN> exit; | | More... 10/07/08 | | | | |
|
| | How to get list of backed up data files from RMAN catalogue schema
To get a list of datafiles with sizes in Kb for the current incarnation of a database (in this example TESTDB) directly from RMAN catalogue database - login as the catalogue schema owner and run the query below:
select d.NAME || ',' || d.BYTES/1024 as name_kb
from RC_DATAFILE d, RC_DATABASE_INCARNATION i
where d.DB_NAME ... | | More... 09/10/08 | | | | |
|
| | Make backupset unavailable in RMAN
This may be useful when you want to restore archive logs which were backed up more than once. These archivelog files will be included in multiple backup sets in the RMAN catalog, by default it will attempt to restore from the latest backup. But what if at the moment you ... | |  More... 07/25/07 | | | | |
|
| | How to register database with RMAN recovery catalog
Replace username/password with the actuall username and password for recovery catalog; and MYDB with the name of the recovery catalog database
1. Change SID to the database you want to register
. oraenv
ORACLE_SID
2. Connect to RMAN catalog database
rman target / catalog username/password@MYDB
3. Register database
RMAN> register database;
| |  More... 11/23/05 | | | | |
|
| | Reset database to a specific incarnation.
When trying to backup a database that was previously restored the backup will fail unless this procedure has been applied to rman catalog.
$ . oraenv
$ORACLE_SID
$ rman target / catalog user/passwd@CATDB
RMAN> reset database;
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID ... | | More... 09/23/05 | | | | |
|
|
|