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 database plus archivelog delete all input命令DatabaseHivedelete
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- recover database using backup controlfile理解Database
- How to use Qt Designed Ui fileQTUI
- 翻譯|How to Use the useReducer HookuseReducerHook
- Crunchy PostgreSQL database backup via pgo commandSQLDatabaseGo
- How to Use the Stdin, Stderr, and Stdout Streams in Bash
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM
- How to use “cat” command on “find” command's output?
- React 16.0+ 新特性初探(How to use)React
- How to solve of ORA-04063 and RMAN-06429
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- RMAN restore validate database報ORA-19693RESTDatabase
- RMAN-03009: failure of backup command on ORA_DISK_1 channelAI
- Linguistics-English-Would, Should, and Could: How to Use Them CorrectlyNGUI
- 2018-06-13 Use rpsblast to search Cdd databaseASTDatabase
- How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1)Database
- 使用RMAN複製資料庫 active database資料庫Database
- How to use VS Code to debug Next.js applications All In OneJSAPP
- PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.16.00.00 in TARGET database isSQLPackageRESTDatabase
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another NoRESTDatabase
- Quartz叢集增強版_00.How to use?(如何使用)quartz
- [20221222]How to Enable and Disable Database Options in oracle 11g.txtDatabaseOracle
- 透過RMAN備份standby database成功恢復還原Database
- use database 切換提示You can turn off this feature to get a quicker startupDatabaseUI
- [重慶思莊每日技術分享]-ORA-1142 signalled during: ALTER DATABASE END BACKUPDatabase
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid不同UXDatabaseOracle
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid相同UXDatabaseOracle
- md_backup
- 【轉載】Kano Model — Ways to use it and NOT use it
- 【RMAN】RMAN備份至ASMASM
- nginx useNginx
- Oracle 11G RAC複製備庫RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 RMAN-10038Oracle
- 【RMAN】RMAN的備份保留策略
- How to ssh
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- ORACLE rman與RMAN-00054&ORA-09945Oracle
- RMAN(轉)
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI