In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
-- hbase shell filter-- create 'test1',' lf', 'sf'-- lf: column family of LONG values
© 2024 shulou.com SLNews company. All rights reserved.