Shulou(Shulou.com)06/01 Report--

(1) Database backup

Before backup, all applications need to be closed, database checkpoint and crchive log current operations should be carried out, and the database should be complete without external program links to ensure database consistency.

The detailed steps for backup and recovery are as follows:

Lsnrctl stop

Export ORACLE_SID=oracle11

Sqlplus / nolog

Conn / as sysdba

Alter system checkpoint

Alter system archive log current

Exit

Rman target /

Backup database format'/ home/oracle/rman/%U'

Exit

Lsnrctl start

Wait about 10 minutes for the database to be backed up (depending on the size of the library), and the backup set is in the / oracle/rman directory.

(2) Database recovery

The database closes all applications for full backup before backup, so there is no need to restore archive logs during fallback recovery, but can be restored directly through the backup set.

Su-oracle

Export ORACLE_SID=oracle11

Rman target /

Shutdown immediate

Startup mount

Restore database

Alter database open

Tip:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1:'/ app/oracle/oradata/oracle11/system01.dbf'

RECOVER DATAFILE'/ app/oracle/oradata/oracle11/system01.dbf'

Recover tablespace system

RECOVER DATABASE

ALTER DATABASE OPEN; (complete recovery)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.