steps by step backup of oracle database 12c using RMAN while the database is in noarchivelog.
meda Marked as closed 16/04/2022
step by step backing up of oracle database 12c( Noarchivelog mode), single instance, using Oracle Recover Manager (RMAN) client.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 | ---- Connect to RMAN client ---SQL> $rman target "'/ as sysbackup '" Recovery Manager: Release 12.2.0.1.0 - Production on Mon Feb 7 20:50:51 2022 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1623755738) ----Check that the database is in noarchivelog mode----RMAN> select name,log_mode,db_unique_name from v$database; using target database control file instead of recovery catalogNAME LOG_MODE DB_UNIQUE_NAME--------- ------------ ------------------------------ORCL NOARCHIVELOG primary---- view the default configuration parametersRMAN> show all; RMAN configuration parameters for database with db_unique_name PRIMARY are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP ON; # defaultCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # defaultCONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\APP\ADMIN\VIRTUAL\VIRTUAL\PRODUCT\12.2.0\DBHOME_1\DATABASE\SNCFPRIMARY.ORA'; # default---- backup your database using backup database commandRMAN> backup database; Starting backup at 07-FEB-22allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=145 device type=DISKRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of backup command at 02/07/2022 20:52:48RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode----Shutdown the database and change the status to mountRMAN> shutdown immediate; database closeddatabase dismountedOracle instance shut downRMAN> startup mount; connected to target database (not started)Oracle instance starteddatabase mounted Total System Global Area 2499805184 bytes Fixed Size 8749920 bytesVariable Size 687869088 bytesDatabase Buffers 1795162112 bytesRedo Buffers 8024064 bytes---- do the backup while the database is at mount stateRMAN> backup database; Starting backup at 07-FEB-22allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=379 device type=DISKchannel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00001 name=D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\SYSTEM01.DBFinput datafile file number=00005 name=D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\UNDOTBS01.DBFinput datafile file number=00003 name=D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\SYSAUX01.DBFinput datafile file number=00007 name=D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\USERS01.DBFchannel ORA_DISK_1: starting piece 1 at 07-FEB-22channel ORA_DISK_1: finished piece 1 at 07-FEB-22piece handle=D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\BACKUPSET\2022_02_07\O1_MF_NNNDF_TAG20220207T205514_K02Q84RF_.BKP tag=TAG20220207T205514 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:35Finished backup at 07-FEB-22 Starting Control File and SPFILE Autobackup at 07-FEB-22piece handle=D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\AUTOBACKUP\2022_02_07\O1_MF_S_1096059216_K02QC59O_.BKP comment=NONEFinished Control File and SPFILE Autobackup at 07-FEB-22---- Backup is completed. Open the databaseRMAN> alter database open; Statement processed---- Finally, check list of your backups using LIST backup commandRMAN> list backup; List of Backup Sets=================== BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------1 Full 10.19M DISK 00:00:02 06-FEB-22 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20220206T221843 Piece Name: D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\ORCL\AUTOBACKUP\2022_02_06\O1_MF_S_1095977924_K007ROOR_.BKP SPFILE Included: Modification time: 06-FEB-22 SPFILE db_unique_name: ORCL Control File Included: Ckp SCN: 1510775 Ckp time: 06-FEB-22 BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------2 Full 1.40G DISK 00:01:29 07-FEB-22 BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20220207T205514 Piece Name: D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\BACKUPSET\2022_02_07\O1_MF_NNNDF_TAG20220207T205514_K02Q84RF_.BKP List of Datafiles in backup set 2 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 1 Full 1515235 07-FEB-22 NO D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\SYSTEM01.DBF 3 Full 1515235 07-FEB-22 NO D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\SYSAUX01.DBF 5 Full 1515235 07-FEB-22 NO D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\UNDOTBS01.DBF 7 Full 1515235 07-FEB-22 NO D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\USERS01.DBF BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------3 Full 10.19M DISK 00:00:01 07-FEB-22 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20220207T205652 Piece Name: D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\AUTOBACKUP\2022_02_07\O1_MF_S_1096059216_K02QC59O_.BKP SPFILE Included: Modification time: 07-FEB-22 SPFILE db_unique_name: PRIMARY Control File Included: Ckp SCN: 1515235 Ckp time: 07-FEB-22 RMAN> |
meda Unselected an answer 16/04/2022