Shulou(Shulou.com)06/01 Report--

This article will explain in detail what are the prerequisites for the use of Rman, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

# #

Prerequisites for using rman

# #

The database is in archive mode

Archivelog mount or open mode

(1) check whether the database is in archive mode:

SQL > archive log listDatabase log mode No Archive ModeAutomatic archival DisabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 13Current log sequence 15

(2) non-archiving mode, set to archiving mode

SQL > shutdownDatabase closed.Database dismounted.ORACLE instance shut down.SQL > startup mountORACLE instance started.Total System Global Area 1603411968 bytesFixed Size 2213776 bytesVariable Size 1174407280 bytesDatabase Buffers 419430400 bytesRedo Buffers 7360512 bytesDatabase mounted.SQL > alter database archivelog;SQL > alter database open;SQL > archivelog list Database log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 13Next log sequence to archive 15Current log sequence 15SQL > archive log all; / / Archive the redo logs at this point in time SQL > select dbid,name,open_mode from v$database DBID NAME OPEN_MODE--1413451383 ORCL READ WRITE what are the prerequisites for the use of Rman? that's it. I hope the above content can be of some help to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

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.