Recover a Database Having Added a Datafile Since Last Backup (Doc ID 29430.1)
How to Recover a Database Having Added a Datafile Since Last Backup (Doc ID 29430.1)
***Checked for relevance on 02-Sep-2013***
HOW TO RECOVER A DATABASE HAVING ADDED A DATAFILE SINCE THE LAST BACKUP
-----------------------------------------------------------------------
This bulletin outlines the steps required in performing database recovery
having added a datafile to the database since the last backup was taken.
Section A is applicable to Oracle release 7.x. Section B applies only to
Oracle releases 7.3.x and above.
PLEASE READ THROUGH ALL STEPS AND WARNINGS BEFORE ATTEMPTING TO USE THIS
BULLETIN.
A. Current controlfile, backup of datafile exists (Oracle release 7.x)
===================================================================
A valid (either hot or cold) backup of the datafiles exists, except for the
datafile created since the backup was taken. The current controlfile exists.
The database is in archivelog mode (see note (c) at bottom of page).
1. Restore ONLY the datafiles (those that have been lost or damaged) from the
last hot or cold backup. The current online redo logs and control file(s)
must be intact.
2. Mount the database
3. Create a new datafile using the 'ALTER DATABASE CREATE DATAFILE' command.
a. The datafile can be created with the same name as the original
file. For example,
SQLDBA> alter database create datafile
2> '/dev1/oracle/dbs/testtbs.dbf';
Statement processed.
b. The datafile can be created with a different filename to the original.
This option might be chosen if the original file was lost due to disk
failure and the failed disk was still unavailable; the new file would
then be created on a different device. For example,
SQLDBA> alter database create datafile
2> '/dev1/oracle/dbs/testtbs.dbf'
3> as
4> '/dev2/oracle/dbs/testtbs.dbf';
Statement processed.
The above command creates a new datafile on the dev2 device. The file
is created using information, stored in the control file, from the
original file. The command implicitly renames the filename in the
control file.
NOTE: IT IS VERY IMPORTANT TO SPECIFY THE CORRECT FILENAME WHEN
RECREATING THE LOST DATAFILE. IF YOU SPECIFY AN EXISTING
ORACLE DATAFILE, THAT DATAFILE WILL BE INITIALISED AND WILL
ITSELF REQUIRE RECOVERY.
4. Recover the database.
SQLDBA> recover database
ORA-00279: Change 6677 generated at 06/03/97 15:20:24 needed for thread 1
ORA-00289: Suggestion : /dev1/oracle/dbs/arch/arch000074.arc
ORA-00280: Change 6677 for thread 1 is in sequence #74
Specify log: {
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1160653/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Recover A Lost Datafile With No Backup (Doc ID 1060605.6)
- 冷備手工完全恢復(recover database,recover tablespace,recover datafile)Database
- Recover database after disk loss (Doc ID 230829.1)Database
- recover database using backup controlfile與 recover database 的區別Database
- RMAN10g: backup copy of database (Doc ID 266980.1)Database
- recover database using backup controlfileDatabase
- recover database using backup controlfile理解Database
- recover database using backup control fileDatabase
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- recover database until cancel using backup controlfileDatabase
- Recover database using backup controlfile until cancelDatabase
- Case two -- Recover a datafile in primary site from the backup taken in standby site without using c
- Case One -- Recover a datafile in primary site from the backup taken in standby site using catalog d
- recover database until cancel和 recover database區別Database
- recover database using backup controlfile利用archivelog files.DatabaseHive
- Recover_DatabaseDatabase
- rman recover databaseDatabase
- v$datafile中的last_change#AST
- Backup and Recovery Scenarios (Doc ID 94114.1)iOS
- alter database create datafileDatabase
- alter database create datafile '' as ''Database
- recover database until timeDatabase
- RMAN Backup Shell Script Example (Doc ID 137181.1)
- * Master Note: Database Performance Overview (Doc ID 402983.1)ASTDatabaseORMView
- Troubleshooting Database Hang Issues (Doc ID 1378583.1)Database
- How to Duplicate a Database in NOARCHIVELOG mode (Doc ID 275480.1)DatabaseHive
- Renaming a Datafile in the Primary DatabaseDatabase
- 採用job定時執行recover datafile
- backup or restore OLR in 11.2 Grid Infrastructure (Doc ID 1193643.1)RESTASTStruct
- Oracle10G RMAN Database Duplication (Doc ID 259694.1)OracleDatabase
- How To Size the Database Smart Flash Cache (Doc ID 1317950.1)Database
- RMAN backup validate database on databases in noarchivelog modeDatabaseHive
- Manually Backup - Restore or Clone a Database to Another Node [ID 562556.1]RESTDatabase
- ALTER DATABASE DATAFILE OFFLINEDatabase
- Recover Database Fails with RMAN-06558 [ID 1185074.1]DatabaseAI
- oracle full database backupOracleDatabase
- Rman backup standby databaseDatabase
- Cold Database backup scriptDatabase