Friday , July 21 2017
Home / Oracle DBA / Loss of full database in No Catalog mode – Oracle RMAN

Loss of full database in No Catalog mode – Oracle RMAN

 

 

 

RMAN> report schema;

using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name CHEYSAR

List of Permanent Datafiles
===========================
File   Size(MB) Tablespace    RB segs       Datafile Name
—-   ——–     ——————–    ——- ————————
1        690          SYSTEM                     ***            /u01/app/oracle/cheysar/system01.dbf
2      490          SYSAUX                      ***              /u01/app/oracle/cheysar/sysaux01.dbf
3       30           UNDOTBS1                ***             /u01/app/oracle/cheysar/undotbs01.dbf

4        5                  USERS                  ***                 /u01/app/oracle/cheysar/users01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 20 TEMP 32767 /u01/app/oracle/cheysar/temp01.dbf

RMAN>
[root@ssss4 ~]# su – oracle
[oracle@ssss4 ~]$ cd /u01/app/oracle/cheysar
[oracle@ssss4 cheysar]$ ls
control01.ctl redo02.log sysaux01.dbf temp01.dbf users01.dbf
redo01.log redo03.log system01.dbf undotbs01.dbf
[oracle@ssss4 cheysar]$ rm *
[oracle@ssss4 cheysar]$ ls
[oracle@ssss4 cheysar]$ cd /u01/app/oracle/fast_recovery_area/cheysar
[oracle@ssss4 cheysar]$ ls
control02.ctl
[oracle@ssss4 cheysar]$ rm control02.ct

[oracle@ssss4 cheysar]$ ls
[oracle@ssss4 cheysar]$
RMAN> shutdown abort

Oracle instance shut down

RMAN> startup nomount

connected to target database (not started)
Oracle instance started

Total System Global Area 523108352 bytes

Fixed Size 1345288 bytes
Variable Size 360712440 bytes
Database Buffers 155189248 bytes
Redo Buffers 5861376 bytes

[oracle@ssss4 ~]$ cd /u03/rmanbkp/
[oracle@ssss4 rmanbkp]$ ls
0cs8eidv_1_1 0es8eieo_1_1 0gs8eies_1_1 c-1251988537-20170703-05
0ds8eidv_1_1 0fs8eies_1_1 0hs8eijf_1_1
[oracle@ssss4 rmanbkp]$

 

RMAN> restore controlfile from ‘/u03/rmanbkp/c-1251988537-20170703-05’;

Starting restore at 04-JUL-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output file name=/u01/app/oracle/cheysar/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/cheysar/control02.ctl
Finished restore at 04-JUL-17

RMAN> startup mount

database is already started
database mounted
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 04-JUL-17
Starting implicit crosscheck backup at 04-JUL-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=20 device type=DISK
Crosschecked 6 objects
Finished implicit crosscheck backup at 04-JUL-17

Starting implicit crosscheck copy at 04-JUL-17
using channel ORA_DISK_1
using channel ORA_DISK_2
Finished implicit crosscheck copy at 04-JUL-17

searching for all files in the recovery area
cataloging files…
cataloging done

List of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/CHEYSAR/archivelog/2017_06_29/o1_mf_1_3_do9h7m0v_.arc
File Name: /u01/app/oracle/fast_recovery_area/CHEYSAR/archivelog/2017_06_29/o1_mf_1_2_do94zh47_.arc
File Name: /u01/app/oracle/fast_recovery_area/CHEYSAR/archivelog/2017_06_29/o1_mf_1_4_do9lf39q_.arc
File Name: /u01/app/oracle/fast_recovery_area/CHEYSAR/archivelog/2017_07_04/o1_mf_1_9_doptjvmo_.arc

using channel ORA_DISK_1
using channel ORA_DISK_2

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/cheysar/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/cheysar/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /u03/rmanbkp/0gs8eies_1_1
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00001 to /u01/app/oracle/cheysar/system01.dbf
channel ORA_DISK_2: restoring datafile 00004 to /u01/app/oracle/cheysar/users01.dbf
channel ORA_DISK_2: reading from backup piece /u03/rmanbkp/0fs8eies_1_1
channel ORA_DISK_1: piece handle=/u03/rmanbkp/0gs8eies_1_1 tag=TAG20170703T174604
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:17
channel ORA_DISK_2: piece handle=/u03/rmanbkp/0fs8eies_1_1 tag=TAG20170703T174604
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:02:27
Finished restore at 04-JUL-17

RMAN> recover database;

Starting recover at 04-JUL-17
using channel ORA_DISK_1
using channel ORA_DISK_2

starting media recovery

archived log for thread 1 with sequence 8 is already on disk as file /u01/app/oracle/fast_recovery_area/CHEYSAR/archivelog/2017_07_03/o1_mf_1_8_donfjqom_.arc
archived log for thread 1 with sequence 9 is already on disk as file /u01/app/oracle/fast_recovery_area/CHEYSAR/archivelog/2017_07_04/o1_mf_1_9_doptjvmo_.arc
archived log file name=/u01/app/oracle/fast_recovery_area/CHEYSAR/archivelog/2017_07_03/o1_mf_1_8_donfjqom_.arc thread=1 sequence=8
archived log file name=/u01/app/oracle/fast_recovery_area/CHEYSAR/archivelog/2017_07_04/o1_mf_1_9_doptjvmo_.arc thread=1 sequence=9
unable to find archived log
archived log thread=1 sequence=10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/04/2017 17:28:07
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 10 and starting SCN of 900674

RMAN> alter database open resetlogs;

database opened

RMAN>

[oracle@ssss4 rmanbkp]$ cd /u03/rmanbkp/
[oracle@ssss4 rmanbkp]$ ls
0cs8eidv_1_1 0es8eieo_1_1 0gs8eies_1_1 c-1251988537-20170703-05
0ds8eidv_1_1 0fs8eies_1_1 0hs8eijf_1_1 c-1251988537-20170704-00
[oracle@ssss4 rmanbkp]$ cd /u01/app/oracle/cheysar
[oracle@ssss4 cheysar]$ ls
control01.ctl redo02.log sysaux01.dbf temp01.dbf users01.dbf
redo01.log redo03.log system01.dbf undotbs01.dbf
[oracle@ssss4 cheysar]$ cd /u01/app/oracle/fast_recovery_area/cheysar
[oracle@ssss4 cheysar]$ ls
control02.ctl
[oracle@ssss4 cheysar]$ cd

Comments

comments

Check Also

DATA BASE LINKS

DATABASE LINKS: What are the db links? create a link from one database to another …

Leave a Reply

Your email address will not be published. Required fields are marked *