oracle10g数据库备份与还原总结.doc

oracle 10g数据库备份与还原总结
Oracle 10g database backup and restore summary. TXT is in a bad mood today. I only have four sentep:
Copy the data file
Set tablespaces for normal mode
SQL > alter tablespace users end backup
the online backup failed
When performing the online backup, if appear routine failure, open the database again, if the data file is still in the ready state, will go wrong, the need to end the backup ©load database
SQL > startup force mount
Check all the data files in the online backup state
SQL > select file# from v $backup where status = 'active' ;
End online backup status
SQL > alter in tablespace end backup
Or alter in tablespace datafile backup:
Or recover datafile serial number
@ open the database
SQL > alter database open;
The reduction
1) fully recovered
Relevant command:
Recover database: restore multiple data files of the database
(running in MOUNT state)
Recover tadaspace: restore all data files in multiple tablespaces (running in open state)
Recover datafile: restore one or more data files (in mount, open state)
restore data files (for SYSTEM table space recovery) under mount
Load the database mount state
Identify the data files that need to be restored
SQL > select file#, error from v $recover_file
Copy back to the original position
Restore database recover. The above command
Open the database alter database open;
restore the