Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Giving RMAN amnesia
whats this all say... you might ask - it seems RMANS memory is not all
in the control file, so amnesia can become a messy proposition (not an
option), I need to brush up on all the cleanup maintenance commands
Bob
*C:\>rman target sys/***@recoq
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Oct 12 18:46:34 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: RECOQ (DBID=481565284)
RMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ---------------
1 Full 592.11M DISK 00:00:59 19-SEP-06 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20060919T215526 Piece Name:
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ---------------
2 Full 6.80M DISK 00:00:02 19-SEP-06 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20060919T215526 Piece Name:
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ---------- 1 1 RECOQ 481565284 PARENT 1 30-AUG-05 2 2 RECOQ 481565284 CURRENT 534907 19-SEP-06
RMAN> exit
Recovery Manager complete.
################### REBUILD THE CONTROL FILE HERE syntax end ofmessage ############
C:\>rman target sys/***@recoq
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Oct 12 18:59:28 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: RECOQ (DBID=481565284)
RMAN> list incarnation;
using target database control file instead of recovery catalog
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ---------- 1 1 RECOQ 481565284 CURRENT 534907 19-SEP-06
RMAN> list backup;
RMAN>
##################################################################STARTUP NOMOUNT
GROUP 1 'D:\RECOQ\RECOQ\REDO01.LOG' SIZE 50M, GROUP 2 'D:\RECOQ\RECOQ\REDO02.LOG' SIZE 50M, GROUP 3 'D:\RECOQ\RECOQ\REDO03.LOG' SIZE 50MDATAFILE
################# rebuild the control file with new dbname
RMAN> list incarnation;
using target database control file instead of recovery catalog
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ---------- 1 1 RECOQNEW 481565284 PARENT 534907 19-SEP-06 2 2 RECOQNEW 481565284 CURRENT 2919536 12-OCT-06
RMAN>
####################################################STARTUP NOMOUNT
GROUP 1 'D:\RECOQ\RECOQ\REDO01.LOG' SIZE 50M, GROUP 2 'D:\RECOQ\RECOQ\REDO02.LOG' SIZE 50M, GROUP 3 'D:\RECOQ\RECOQ\REDO03.LOG' SIZE 50MDATAFILE
Control file created.
NOT CONNECTED > alter database open resetlogs;
Database altered.
NOT CONNECTED > shutdown abort
NOT CONNECTED > startup mount restrict;
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes Variable Size 92275392 bytes Database Buffers 188743680 bytes Redo Buffers 7139328 bytesDatabase mounted.
NOT CONNECTED > drop database;
Database dropped.
Disconnected from Oracle Database 10g Enterprise Edition Release
10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
NOT CONNECTED >
*
-- "Oracle error messages being what they are, do not highlight the correct cause of fault, but will identify some other error located close to where the real fault lies." -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 12 2006 - 18:23:48 CDT