11/20/2023 0 Comments Xee kanal![]() Input datafile file number=00004 name=/oradata/ORCL/users01.dbfĬhannel ORA_DISK_1: starting piece 1 at 18-APR-18 Input datafile file number=00001 name=/oradata/ORCL/system01.dbf Input datafile file number=00002 name=/oradata/ORCL/sysaux01.dbf Input datafile file number=00003 name=/oradata/ORCL/undotbs01.dbf RMAN> backup database tag 'BEFORE-IMPORT-PRODUCTION-2018Q1' Ĭhannel ORA_DISK_1: SID=701 device type=DISKĬhannel ORA_DISK_1: starting full datafile backup setĬhannel ORA_DISK_1: specifying datafile(s) in backup set Total System Global Area 20199768064 bytes RMAN> shutdown immediate Ĭonnected to target database (not started) Please notice that all actions can be done in RMAN command prompt. Here I demonstrate how I implement this solution.įirst of all, bounce the database to MOUNT state. Since the development database does not need any archived logs for easy maintenance, I choose to keep NOARCHIVELOG mode unchanged. Which means, you have to bounce the database twice in this way, it may be a little annoying for your users. The drawback is that you have to bounce the database again to bring the database back to READ WRITE. RMAN> shutdown immediate RMAN> startup open read only RMAN> backup database tag 'BEFORE-IMPORT-PRODUCTION-2018Q1' You have to bounce the database server to read-only, then perform your backups. You can find out more Managing Archived Redo Log Files at Oracle documentation.īut if you don't want to change NOARCHIVELOG mode, please continue reading the following two ways. No more RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode, because it has been switched to ARCHIVELOG mode. Then, you can run whatever RMAN scripts you want. You have to shutdown the database and startup to mount state, then issue: SQL> shutdown immediate SQL> startup mount SQL> alter database archivelog SQL> alter database open
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |