How to Restore the Database Using AMDU after Diskgroup Corruption
1. Create pfile of lost database , from database alert.log startup messages.
2. Startup database in nomount
3. Get the controlfile number from db alert log , it will show while starting the database here in this eg. its 256
eg., control_files='+DATA/orcl/controlfile/current.256.709676643'
If you have controlfile backup already in non-asm location edit the pfile to point to location of non-asm and then mount the database
If you dont have controlfile backup then go to step 4 after determining the file# from step 3
4. $ amdu -diskstring -extract DATA.256
5. shutdown the database and change the control_file location to point to the extracted file location
6. startup mount the database
7. once mounted, get the datafile file numbers using "select name from v$datafile"
And get online redo logfile from "select * from v$logfile".
8. Extract all datafiles and redolog files in similar manner
9. alter database rename to < newly extracte location>
10. open the database
2. Startup database in nomount
3. Get the controlfile number from db alert log , it will show while starting the database here in this eg. its 256
eg., control_files='+DATA/orcl/controlfile/current.256.709676643'
If you have controlfile backup already in non-asm location edit the pfile to point to location of non-asm and then mount the database
If you dont have controlfile backup then go to step 4 after determining the file# from step 3
4. $ amdu -diskstring
5. shutdown the database and change the control_file location to point to the extracted file location
6. startup mount the database
7. once mounted, get the datafile file numbers using "select name from v$datafile"
And get online redo logfile from "select * from v$logfile".
8. Extract all datafiles and redolog files in similar manner
9. alter database rename
10. open the database
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15747463/viewspace-1083815/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- guarantee restore points-Flashback after RMAN restoreREST
- [翻譯]-Detect And Repair Corruption in an Oracle DatabaseAIOracleDatabase
- Crunchy PostgreSQL database restore via pgo commandSQLDatabaseRESTGo
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- RMAN restore validate database報ORA-19693RESTDatabase
- recover database using backup controlfile理解Database
- How to get the description of blast hit using blastdbcmd?AST
- How to develop locally a Laravel app using LaragondevLaravelAPPGo
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another NoRESTDatabase
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- SQLSERVER 2012從2000還原失敗:Restore of database failedSQLServerRESTDatabaseAI
- How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1)Database
- How to create the Gold gold using RGB color values All In OneGo
- You may fail to backup log or restore log after TDE certification/key rotation.AIREST
- G009-ORACLE-ASK Using In-Database ArchivingOracleDatabase
- PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.16.00.00 in TARGET database isSQLPackageRESTDatabase
- How to redirect to a specific web page after sign out from Entra IDWeb
- How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1OracleGo
- [20221222]How to Enable and Disable Database Options in oracle 11g.txtDatabaseOracle
- How To Retry Multiple Errored Approval Workflow Processes After A Fix Or Patch Has Been ImplementedErrorAPP
- Bug 12725963 - New database connection fails with ORA-12541 after vip failoverDatabaseAI
- Oracle Database 19c(19.9) RAC On RedHat 8.3 Using VirtualBox and MacBookOracleDatabaseRedhatMac
- diskgroup "DATADG" cannot be mounted
- Oracle ASM AMDU工具的使用OracleASM
- canvas restore()CanvasREST
- AMDU資料抽取案例一則
- canvas save()和restore()CanvasREST
- DOCKER特性 - LIVE RESTOREDockerREST
- C/C++ 恨透了 double free or corruptionC++
- Oracle 12C ASM asmcmd amdu_extractOracleASM
- 資料恢復:AMDU資料抽取恢復資料恢復
- DBMS_BACKUP_RESTORE.DBMS_BACKUP_RESTORE用於特殊情況下的恢復REST
- MySQL 索引優化 Using where, Using filesortMySql索引優化
- [LeetCode] 93. Restore IP AddressesLeetCodeREST
- git操作之二:git restoreGitREST
- provider for back&restore app datyaIDERESTAPP
- How to ssh
- MySQL explain結果Extra中"Using Index"與"Using where; Using index"區別MySqlAIIndex
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST