recover database using backup controlfile利用archivelog files.
recover database using backup controlfile;
1 指定日誌: {
auto
2 指定日誌: {
cancel
或者:
2 指定日誌: {
D:oracleproduct10.2.0oradatatestREDO01.LOG --filename
filename
SQL> select status,group# from v$log;
STATUS GROUP#
---------------- ----------
CURRENT 1
INACTIVE 3
INACTIVE 2
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9907339/viewspace-1049818/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- recover database using backup controlfile理解Database
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- Crunchy PostgreSQL database backup via pgo commandSQLDatabaseGo
- Flashback database必須要有之前的archivelog嗎?DatabaseHive
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM
- ORA-279 signalled during: alter database recover logfileDatabase
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- G009-ORACLE-ASK Using In-Database ArchivingOracleDatabase
- 利用Omni Recover恢復IOS資料iOS
- PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.16.00.00 in TARGET database isSQLPackageRESTDatabase
- Oracle 19c透過recover standby database from service修復GAP案例OracleDatabase
- Oracle Database 19c(19.9) RAC On RedHat 8.3 Using VirtualBox and MacBookOracleDatabaseRedhatMac
- [重慶思莊每日技術分享]-ORA-1142 signalled during: ALTER DATABASE END BACKUPDatabase
- cron with recover
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- Error: --recode does not support multipass recoding of very large files.Error
- 【轉】恢復archivelog介紹Hive
- PG 自動刪除archivelogHive
- Controlfile 重建控制檔案 noresetlogs, resetlogs..
- Will attempt to recover by breaking constraintAI
- md_backup
- ORA-19599 When Backing up an Archivelog that is CorruptHive
- 【譯】defer-panic-and-recover
- rman 還原歸檔日誌(restore archivelogRESTHive
- rman備份archivelog出現ORA-19625Hive
- MySQL 索引優化 Using where, Using filesortMySql索引優化
- MySQL explain結果Extra中"Using Index"與"Using where; Using index"區別MySqlAIIndex
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- Oracle 11G 隱含引數“_controlfile_autobackup_delay”Oracle
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- Golang Recover的一個小坑Golang
- CREATE CONTROLFILE修改DB_NAME一定不能使用REUSE
- Using hints for PostgresqlSQL
- String interpolation using $
- using的用法
- Using mysqldump for backupsMySql