Oracle Cold backup and Hot backup Practices (original)

Refer to the Backup blog post and uploaded files, conducted a hot and cold backup practice and documented for later review, the practice of the environment is WIN10, installed oracle11g

One, cold backup

1, Cmd->sqlplus/nolog

2, Conn sys/123456 as Sysdba

Possible issues:Ora-12560:tns: Resolution of protocol Adapter errors

The reason is the re-instantiation of the database and the default ORCL inconsistencies. Workaround: Attribute--advanced--environment variable ---system variable--new , variable name =oracle_sid, variable value =xxxx, XXXX is your database SID, set the name of the environment variable

3, Shutdown immediate

4. Backup of data files and control files.

Pay special attention to controlling the backup of file 2, otherwise startup and shutdown will appear???? XXX error.

5. Startup

Delete several database records

6, Shutdown immediate

7. Restore the backed up data files and control files

8, startup and verify the correctness of the data.

Oracle Cold backup and Hot backup Practices (original)