How to use rman backup a noarchivelog database
If a database runs in noarchivelog mode, then the only valid database backup is a consistent backup. So we need perform a clean shutdown first, then start the database in mount status.
1 Shutdonw the database consistently and then mount it.
shutdown immediate;
startup force DBA;
shutdown immediate;
startup mount;
2 connect the target database with rman and run the backup database command.
RMAN> backup database;
RMAN> backup as copy database;
3 open the database;
alter database open;
1 Shutdonw the database consistently and then mount it.
shutdown immediate;
startup force DBA;
shutdown immediate;
startup mount;
2 connect the target database with rman and run the backup database command.
RMAN> backup database;
RMAN> backup as copy database;
3 open the database;
alter database open;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29557342/viewspace-1140218/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN backup validate database on databases in noarchivelog modeDatabaseHive
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- How to Duplicate a Database in NOARCHIVELOG mode (Doc ID 275480.1)DatabaseHive
- Rman backup standby databaseDatabase
- rman backup database force 功能Database
- How to use the Automatic Database Diagnostic Monitor(一)Database
- 理解RMAN backup database plus archivelog命令DatabaseHive
- rman backup as copy database format '/tmp/%U.dbf'DatabaseORM
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- how to use typeset?
- To use Rman to duplicate database be careful of db_file_name_convertDatabase
- Archivelog & Noarchivelog mode in RMANHive
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- RMAN10g: backup copy of database (Doc ID 266980.1)Database
- how to use coffee script
- In Oracle,How to use dumpOracle
- rman backup database 出現 ORA-01422錯誤Database
- How to Quiesce a DatabaseUIDatabase
- 翻譯|How to Use the useReducer HookuseReducerHook
- how to use ghd hair straightenerAI
- How to use hints in Oracle sql for performanceOracleSQLORM
- oracle full database backupOracleDatabase
- Cold Database backup scriptDatabase
- Oracle 11g RMAN備份-RMAN的backup database plus archivelog命令背後的操作OracleDatabaseHive
- How to Perform a Healthcheck on the DatabaseORMDatabase
- How to enable the flashback database:Database
- How a Database Is Mounted (293)Database
- How to use Qt Designed Ui fileQTUI
- How to use sql result stored on shell variable?SQL
- How to use "for/" batch command in Dos extentionBAT
- rman backup script(引用)
- DP rman backup scripts
- Database Testing: How to Regression Test a Relational DatabaseDatabase
- Cold backup and restore the entire databaseRESTDatabase
- Oracle OCP 1Z0 053 Q544(BACKUP NOARCHIVELOG)OracleHive
- How to Perform a Health Check on the DatabaseORMDatabase
- [原創] How to Quiesce a DatabaseUIDatabase
- How a Standby Database Is Mounted (295)Database