重建controlfile后发现后datafile 漏了 rman catalog recovery area

最新推荐文章于 2024-08-20 15:06:19 发布
最新推荐文章于 2024-08-20 15:06:19 发布
阅读量939 收藏 8
点赞数 21
文章标签： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jnrjian/article/details/140089341
版权

SYMPTOMS

ORA-01110: data file 10: '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010'
ORA-01565: error in identifying file '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010'
ORA-27037: unable to obtain file status
 

SYS AS SYSDBA>select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/system01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/sysaux01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/undotbs01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/rman01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/users01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_02.dbf
/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010

CHANGES

 Customer recreated the controlfile

CAUSE

Customer recreated the controlfile, and one of the datafile missed in create controlfile statment.
 

SOLUTION

 If the datafile exists on the filesystem, and DB was opened with resetlogs, after recreating the controlfile,

Option 1: If datafile still exists on filesystem (available at OS level)

======

Restart the database in mount mode and rename the datafile

SYS AS SYSDBA>shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS AS SYSDBA>startup mount
ORACLE instance started.

Total System Global Area 2063595328 bytes
Fixed Size 8898368 bytes
Variable Size 704643072 bytes
Database Buffers 1342177280 bytes
Redo Buffers 7876608 bytes
Database mounted.
SYS AS SYSDBA>alter database rename file '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010' to '/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_03.dbf';

Database altered.

SYS AS SYSDBA>select FILE#,STATUS,ERROR,RESETLOGS_TIME,CHECKPOINT_COUNT from v$datafile_header;

FILE# STATUS ERROR RESETLOGS CHECKPOINT_COUNT
---------- ------- ----------------------------------------------------------------- --------- ----------------
1 ONLINE 27-OCT-23 1645
2 ONLINE 27-OCT-23 1173
3 ONLINE 27-OCT-23 1634
4 ONLINE 27-OCT-23 1589
5 ONLINE 27-OCT-23 1319
7 ONLINE 27-OCT-23 1632
8 ONLINE 27-OCT-23 1047
9 ONLINE 27-OCT-23 1043
10 OFFLINE WRONG RESETLOGS 08-MAY-23 420

9 rows selected.

 Now run recover datafile command and bring it back to online (in mount mode only

RMAN> recover datafile 10;

Starting recover at 27-OCT-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 device type=DISK

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 27-OCT-23

RMAN> alter database datafile 10 online;

Statement processed

RMAN> alter database open;

Statement processed

RMAN> alter system checkpoint;

Statement processed

RMAN>

 Now check the Datafile status again

SYS AS SYSDBA>select FILE#,STATUS,ERROR,RESETLOGS_TIME,CHECKPOINT_COUNT from v$datafile_header;

FILE# STATUS ERROR RESETLOGS CHECKPOINT_COUNT
---------- ------- ----------------------------------------------------------------- --------- ----------------
1 ONLINE 27-OCT-23 1647
2 ONLINE 27-OCT-23 1175
3 ONLINE 27-OCT-23 1636
4 ONLINE 27-OCT-23 1591
5 ONLINE 27-OCT-23 1321
7 ONLINE 27-OCT-23 1634
8 ONLINE 27-OCT-23 1049
9 ONLINE 27-OCT-23 1045
10 ONLINE 27-OCT-23 423

9 rows selected.

 Option 2:- If datafile does not exists at OS level, but the backup does exists, prior to recreating the controlfile

Try to restore datafile with set new name

RMAN> run {
2> set newname for datafile 10 to '/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_03.dbf';
3> restore datafile 10;
4> recover datafile 10;
5> }

executing command: SET NEWNAME

Starting restore at 27-OCT-23
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=139 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/27/2023 07:03:24
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 10 found to restore

RMAN> list incarnation;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCL1930 4194918935 PARENT 85128967 27-OCT-23
2 2 ORCL1930 4194918935 CURRENT 85135204 27-OCT-23

RMAN> catalog recovery area;   没有用catalog start with

searching for all files in the recovery area

List of Files Unknown to the Database
=====================================
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300790_lmpmopc3_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151302951_lmpos84h_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300699_lmpmlw81_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300777_lmpmo9jm_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151302142_lmpnzy9s_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3y8_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8p4_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_ncnnf_TAG20231027T054627_lmpmoo1g_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8kx_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8n5_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3wq_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3ym_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8tw_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8j8_.bkp
File Name: /refresh/home/FRA/ORCL19300/flashback/o1_mf_lkwz7y30_.flb
File Name: /refresh/home/FRA/ORCL19300/flashback/o1_mf_l9r86g2c_.flb
File Name: /refresh/home/FRA/ORCL19300/flashback/o1_mf_l9oqd3qp_.flb
File Name: /refresh/home/FRA/ORCL19300/flashback/o1_mf_l99k5615_.flb
File Name: /refresh/home/FRA/ORCL19300/flashback/o1_mf_l9pq3ktv_.flb
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_159_lmpnq334_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnq61r_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnq57v_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnzlt2_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_158_lmpnq1qq_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnzlvv_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_162_lmpnzlxg_.arc

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300790_lmpmopc3_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151302951_lmpos84h_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300699_lmpmlw81_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151300777_lmpmo9jm_.bkp
File Name: /refresh/home/FRA/ORCL19300/autobackup/2023_10_27/o1_mf_s_1151302142_lmpnzy9s_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3y8_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8p4_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_ncnnf_TAG20231027T054627_lmpmoo1g_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8kx_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8n5_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3wq_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3ym_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8tw_.bkp
File Name: /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8j8_.bkp
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_159_lmpnq334_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnq61r_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnq57v_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnzlt2_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_158_lmpnq1qq_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnzlvv_.arc
File Name: /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_162_lmpnzlxg_.arc

RMAN> run {
2> set newname for datafile 10 to '/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_03.dbf';
3> restore datafile 10;
4> recover datafile 10;
5> }

executing command: SET NEWNAME

Starting restore at 27-OCT-23
using channel ORA_DISK_1

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 00010 to /refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_03.dbf
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3y8_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_nnnd0_TAG20231027T054402_lmpmk3y8_.bkp tag=TAG20231027T054402
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 27-OCT-23

Starting recover at 27-OCT-23
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/27/2023 07:05:35
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover
if needed datafile 10
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 10 is unknown - rename to correct file
ORA-01110: data file 10: '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010'
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01111: name for data file 10 is unknown - rename to correct file
ORA-01110: data file 10: '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010'

RMAN> switch datafile 10 to copy;

datafile 10 switched to datafile copy "/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_03.dbf"

RMAN> recover datafile 10;

Starting recover at 27-OCT-23
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 158 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_158_lmpnq1qq_.arc
archived log for thread 1 with sequence 159 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_159_lmpnq334_.arc
archived log for thread 1 with sequence 160 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnq57v_.arc
archived log for thread 1 with sequence 161 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnzlvv_.arc
archived log for thread 1 with sequence 162 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_162_lmpnzlxg_.arc
archived log for thread 1 with sequence 1 is already on disk as file /refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_1_lmpqw34o_.arc
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=147
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8j8_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8j8_.bkp tag=TAG20231027T054616
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_147_lmprbrgl_.arc thread=1 sequence=147
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_147_lmprbrgl_.arc RECID=9 STAMP=1151305560
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=148
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=149
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=150
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8kx_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8kx_.bkp tag=TAG20231027T054616
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_148_lmprbsp1_.arc thread=1 sequence=148
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_148_lmprbsp1_.arc RECID=10 STAMP=1151305561
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_149_lmprbspv_.arc thread=1 sequence=149
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_149_lmprbspv_.arc RECID=11 STAMP=1151305561
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_150_lmprbsqq_.arc thread=1 sequence=150
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_150_lmprbsqq_.arc RECID=12 STAMP=1151305561
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=151
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=152
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=153
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8n5_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8n5_.bkp tag=TAG20231027T054616
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_151_lmprbtyt_.arc thread=1 sequence=151
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_151_lmprbtyt_.arc RECID=13 STAMP=1151305562
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_152_lmprbv0o_.arc thread=1 sequence=152
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_152_lmprbv0o_.arc RECID=14 STAMP=1151305563
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_153_lmprbv22_.arc thread=1 sequence=153
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_153_lmprbv22_.arc RECID=15 STAMP=1151305563
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=154
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=155
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=156
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8p4_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8p4_.bkp tag=TAG20231027T054616
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_154_lmprbw98_.arc thread=1 sequence=154
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_154_lmprbw98_.arc RECID=16 STAMP=1151305564
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_155_lmprbwb3_.arc thread=1 sequence=155
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_155_lmprbwb3_.arc RECID=17 STAMP=1151305564
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_156_lmprbwbw_.arc thread=1 sequence=156
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_156_lmprbwbw_.arc RECID=18 STAMP=1151305564
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=157
channel ORA_DISK_1: reading from backup piece /refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8tw_.bkp
channel ORA_DISK_1: piece handle=/refresh/home/FRA/ORCL19300/backupset/2023_10_27/o1_mf_annnn_TAG20231027T054616_lmpmo8tw_.bkp tag=TAG20231027T054616
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_157_lmprbxkc_.arc thread=1 sequence=157
channel default: deleting archived log(s)
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_157_lmprbxkc_.arc RECID=19 STAMP=1151305565
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_158_lmpnq1qq_.arc thread=1 sequence=158
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_159_lmpnq334_.arc thread=1 sequence=159
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_160_lmpnq57v_.arc thread=1 sequence=160
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_161_lmpnzlvv_.arc thread=1 sequence=161
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_162_lmpnzlxg_.arc thread=1 sequence=162
archived log file name=/refresh/home/FRA/ORCL19300/archivelog/2023_10_27/o1_mf_1_1_lmpqw34o_.arc thread=1 sequence=1
media recovery complete, elapsed time: 00:00:00
Finished recover at 27-OCT-23

RMAN> alter database datafile 10 online;

Statement processed

RMAN>

 Now check the status of datafile

SYS AS SYSDBA>set lines 300
SYS AS SYSDBA>select FILE#,STATUS,ERROR,RESETLOGS_TIME,CHECKPOINT_TIME from v$datafile_header;

FILE# STATUS ERROR RESETLOGS CHECKPOIN
---------- ------- ----------------------------------------------------------------- --------- ---------
1 ONLINE 27-OCT-23 27-OCT-23
2 ONLINE 27-OCT-23 27-OCT-23
3 ONLINE 27-OCT-23 27-OCT-23
4 ONLINE 27-OCT-23 27-OCT-23
5 ONLINE 27-OCT-23 27-OCT-23
7 ONLINE 27-OCT-23 27-OCT-23
8 ONLINE 27-OCT-23 27-OCT-23
9 ONLINE 27-OCT-23 27-OCT-23
10 ONLINE 27-OCT-23 27-OCT-23

9 rows selected.

jnrjian
关注
  • 21
    点赞
  • 踩
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle catalog归档,使用rman catalog命令恢复数据库
weixin_42500454的博客
04-05 1170
有这样的一种需要恢复数据库场景：当前数据库有一份全备，归档，联机重做日志都没有损坏或丢失，但是控制文件意外的损坏了，而且更糟糕的是，居然没有备份的控制文件(当然， 这种情形很少见)，这种情形下，只有重建控制文件，但是重建控制文件也是一件很棘手的事情，如果数据库有上百个数据文件，要写在控制文件里，不是件容易的是，这就要求数据库管理员对数据库结构相当熟悉。这也是说明了控制文件的重要性了。我这里的场景是...
catalog方式的rman备份与恢复示例
09-10
通过catalog方式进行RMAN备份与恢复，就是通过创建一个专门的恢复目录来管理备份信息，而不是直接在控制文件（controlfile）中记录。以下是从给定文件中提取的知识点： 1. Catalog方式与NoCatalog方式的对比 - ...
catalog recovery area后回到incarnation任一时刻
jnrjian的博客
06-16 994
一定要比list incarnation 中的值大于1，否则就是早一个的incarnation。2. catalog recovery area 后默认最新的incarnation，需要结合 SCN号切换incarnation.1. controlfile 一定要足够早，那就是list incarnation 只有两个的时候。
备份oracle后_control file自动过期,SPFILE和CONTROLFILE自动备份
weixin_31703753的博客
04-11 221
Oracle从9i以后把SPFILE也纳入备份的策略当中，如果启用了控制文件自动备份配置，则进行控制文件自动备份的时候，会自动把SPFILE备份到备份集当中[oracle@021Y-SH-BKAP~]$rmantarget/RecoveryManager:Release11.2.0.1.0-ProductiononTueJan2710:11:362015Copyrig...
RMAN（Recovery Manager）入门
jetliu05的博客
04-18 7872
1. RMAN环境概述 RMAN（Recovery Manager）是一个Oracle数据库客户端，它在数据库上执行备份和恢复任务和自动管理备份策略。它大大地简化了备份，还原（restore）和恢复（recover）数据库文件。 RMAN环境包括在备份数据时扮演各个角色的工具和数据库。RMAN环境至少包括以下组件： 1）目标（target）数据库，RMAN使用TARGET关键字连接的数据库。目标数据库是RMAN执行备份和恢复操作的数据库。RMAN总是在数据库的控制文件中维护关于它对数据库的操作的元数据（me
rman reset database incarnation 重建controlfile
jnrjian的博客
06-02 933
run {RecoveryJoyHello Joy,CheersSureshHi Joy,Thanks,RenuFlagQuoteOff TopicLikeMeowMeowHi Suresh,Thank you,Joy(Failed)FlagQuote。
RMAN Recovery Catalog
Watson的专栏
01-10 2281
下面是Rman recovery catalog相关的知识和实验：   一，创建Recovery catalog RMAN恢复目录数据库：  必须OPEN 目标数据库：  根据不同情况，必须MOUNT或OPEN 启动target 数据库 [oracle@even ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Produc
rman catalog start 注册备份集
jnrjian的博客
06-02 698
RMAN 备份分2种，Catalog 和Nocatalog，对于Nocatalog，oracle 会使用控制文件来保存RMAN备份的一些记录。因为之前备份集的位置发生改变，导致corsscheck之后，将之前备份的记录标记为expired，我们后来手工删除了这些expired的备份集信息。在我们RMAN 进行异地恢复的时候，就会遇到路径的问题，如果路径不同，就没办法进行有效的恢复，我们看这时候怎么处理。（1） 使用RMAN 的nocatalog 进行备份，然后将备份转移到其他的目录， 在进行恢复。
oracle 11g rman catalog,Oracle 11g RMAN复制数据库的测试
weixin_34829543的博客
04-07 322
RMAN支持两种类型复制：活动数据库复制和基于备份的复制，主要用来建立测试库。分别进行测试我们把要复制的数据库称为源数据库(SOURCE DB=orcl)，复制后的数据库成为目标数据库(TARGET DB=bdup)，不容易搞混。一、基于备份的测试测试环境：同一台主机，OS=RHEL 6.4; DB=Oracle11gR21.在目标数据库上创建密码文件[oracle@myrac1 ~]$ cd /...
RMAN-06023: no backup or copy of datafile 1 found to restore
文档搬运工
04-13 1597
- 再次还原控制文件 ，再次catalog ，发现化身是13年的了 ，而且在RMAN中catalog的记录中，没有catalog FRA的目录。在异机还原数据库的时候，发现报RMAN-06023，提示一些文件没有备份，实际查看备份，这些文件是备份过的。-- 重新catalog 后，数据库化身，又变成了22年9月21日的 ，同时，在alert log中显示数据库化身变成了5。-- 在OS上查看这些文件，文件是存在的，权限不存在问题，other组的权限是读，RMAN可以读这些文件。或，设置正确的数据库化身。
Oracle 12c Rman Backup and Recovery
11-09
9. **恢复数据文件**：通过`RESTORE DATAFILE`命令恢复单个数据文件。 10. **恢复数据库**：使用`RESTORE DATABASE`命令恢复整个数据库。 #### 五、RMAN高级特性 - **加密**：RMAN支持对备份数据进行加密，增强...
Oracle RMAN基于catalog-配置与使用指南.docx
10-15
create tablespace rman_tbs datafile 'D:appAdministratororadataheheman_tbs.dbf' size 2G; ``` 2. 创建 RMAN 用户 接下来，需要创建 RMAN 用户，指定表空间为 rman_tbs。例如： ``` create user rman ...
Oracle19c rac备份数据通过rman恢复到单实例
07-02
RMAN> restore controlfile from '/home/oracle/rman/1/ctl1_XZDB_57_1_1p184ve9.bak'; ``` - 恢复完成后，使用`alter database mount`命令挂载数据库。 3. **修改redo文件位置**： - 使用以下SQL脚本更改redo...
RMAN参考手册.pdf
05-18
RMAN（Recovery Manager）是Oracle数据库提供的一个用于数据库备份、恢复以及迁移的工具。它能够备份和恢复Oracle数据库中的数据文件、控制文件、参数文件和归档日志文件等关键组件。RMAN可以与目标数据库进行通信，...
[数据库][知识]SQL Server、MySQL 和 Oracle 的默认端口和数据库链接
一名不太专业的程序员
08-17 302
请确保在实际使用中，根据您自己的数据库配置（如主机名、端口、数据库名、用户名和密码等）来调整上述连接信息。同时，确保已经添加了相应数据库的 JDBC 驱动到您的项目依赖中。SQL Server、MySQL 和 Oracle 的默认端口号、连接 URL 和驱动类名。请注意，SQL Server 的 JDBC URL 格式可能需要根据实际的数据库实例进行调整，例如，如果数据库实例名称不是默认的。参数用于指定字符集，如果需要其他字符集设置，可能需要调整这些参数。指定了连接的主机和端口，
查询数据库版本、查询数据字符集sql
qq_39564710的博客
08-18 308
查询数据库版本、查询数据字符集sql
Mongodb、redis、mysql、mssql、oracle、PostgreSQL服务简介和默认运行端口
2301_77000936的博客
08-18 451
MongoDB 简介: MongoDB 是一个开源的 NoSQL 文档数据库,使用类似 JSON 的 BSON 格式存储数据。它是一个高性能、高可用、自动伸缩的分布式数据库。 默认端口: 27017 Redis 简介: Redis 是一个开源的内存数据库,常用作缓存和消息队列代理。它支持多种数据结构,如字符串、哈希、列表、集合等,并且具有持久化功能。 默认端口: 6379 MySQL 简介: MySQL 是一个开源的关系型数据库管理系统,使用传统的关系数据库模型。它是最流行的开源数据库之一,
高效分页策略：掌握 LIMIT 语句的正确使用方法与最佳实践
最新发布
yqq962464的博客
08-20 939
生产环境高效 limit分页策略
ORACLE RMAN备份与恢复实战手册
控制文件丢失时，可以通过RMAN的CREATE CONTROLFILE命令重建；参数文件丢失可重新创建并配置；密码文件丢失需重新生成；redo日志丢失需寻找其他可用日志或从备份中恢复；表空间损坏时，可以单独恢复受损的表空间。 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值