Restore Adventure works DB backup on MSSQL Server 2017 DB using GUI Method

step 1




Step 2 :



STEP 3:





STEP 4:




STEP 5 :





STEP 6:

Query to check recovery model in MSSQL Server Database

Query to check recovery model in database excluding  'master','model','tempdb','msdb'


select [name], DATABASEPROPERTYEX([name],'recovery')
from sysdatabases
where name not in ('master','model','tempdb','msdb')

Recovery model query to simple below:

--Change the recovery mode:

USE master;

GO

-- Set recovery model to SIMPLE

ALTER DATABASE smrmindev  SET RECOVERY SIMPLE;

GO

Recovery model query to full mode below:

 -- Set recovery model to FULL

--Change the recovery mode:

USE master;

GO

 -- Set recovery model to FULL

ALTER DATABASE smrmindev SET RECOVERY FULL;

-- Set recovery model to FULL

ALTER DATABASE smrtest SET RECOVERY FULL;

GO

--- Check the status of recovery model.

select [name], DATABASEPROPERTYEX([name],'recovery')
from sysdatabases
where name not in ('master','model','tempdb','msdb')

Rlink (Doc ID 1536057.1) after Operating System Kernel Upgrade SLES 12 SP4 to 12 SP5 on 2 Node RAC 12.1.0.2.0

Kindly check link below for previous update :

Method 1 OS kernel upgrade


How To Relink The Oracle Grid Infrastructure Standalone (Restart) Installation Or Oracle Grid Infrastructure RAC/Cluster Installation (11.2 or 12c). (Doc ID 1536057.1)

B) How To Relink The Oracle Grid Infrastructure RAC/Cluster Installation.

1. Stop crs grid service 
2. disable crs  to avoid auto start after reboot
3. Install suse 12sp5 local repository (option we can use wget)
4. zypper update 
5. Install package for oracleasm sles 12 sp5 (oracleasm-kmp-default-2.0.8_k4.12.14_120-7.20.x86_64.rpm) either after reboot or before reboot.
6.  As root OS user, please unlock the Grid Infrastructure Oracle Home (on every node) as follows:

Note: On 12.1/12.2/18c releases, rootcrs.sh can be used instead of rootcrs.pl. Command as "rootcrs.sh -unlock"
directory: /u01/app/12.1.0/grid/crs/install

# perl rootcrs.sh -unlock

7) As the Oracle Grid Infrastructure owner (on every node) relink the Grid Infrastructure Oracle Home as follows:

Directory : /u01/app/12.1.0/grid/bin

grid@suse2:/u01/app/12.1.0/grid/bin> relink all

8) As root OS user again, please execute the next commands (on every node):

On 12.1, use "rootcrs.sh -patch". On 12.2/18c, use "rootcrs.sh -lock" then "crsctl start crs"

Directory : /u01/app/12.1.0/grid/crs/install

# perl rootcrs.sh -patch

9) Check clusterware service crsctl status resource -t

NOTE : Apply same on the 2nd node.


grid@suse2:/u01/app/12.1.0/grid/OPatch> su root
Password:
suse2:/u01/app/12.1.0/grid/OPatch # . oraenv
ORACLE_SID = [grid] ? +ASM2
The Oracle base has been set to /u01/app/grid

• suse2:/u01/app/12.1.0/grid/OPatch # crsctl stop crs

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'suse2'
CRS-2673: Attempting to stop 'ora.crsd' on 'suse2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'suse2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'suse2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'suse2'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'suse2'
CRS-2677: Stop of 'ora.CRS.dg' on 'suse2' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.rac.pretaf_preconnect.svc' on 'suse2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'suse2'
CRS-2677: Stop of 'ora.rac.pretaf_preconnect.svc' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.suse2.vip' on 'suse2'
CRS-2677: Stop of 'ora.scan1.vip' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'suse1'
CRS-2677: Stop of 'ora.suse2.vip' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.suse2.vip' on 'suse1'
CRS-2676: Start of 'ora.scan1.vip' on 'suse1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'suse1'
CRS-2676: Start of 'ora.suse2.vip' on 'suse1' succeeded
CRS-2672: Attempting to start 'ora.rac.pretaf_preconnect.svc' on 'suse1'
CRS-2674: Start of 'ora.rac.pretaf_preconnect.svc' on 'suse1' failed
CRS-2673: Attempting to stop 'ora.rac.db' on 'suse2'
CRS-2677: Stop of 'ora.rac.db' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'suse2'
CRS-2677: Stop of 'ora.DATA.dg' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'suse2'
CRS-2677: Stop of 'ora.FRA.dg' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'suse2'
CRS-2677: Stop of 'ora.asm' on 'suse2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'suse1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'suse2'
CRS-2677: Stop of 'ora.ons' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'suse2'
CRS-2677: Stop of 'ora.net1.network' on 'suse2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'suse2' has completed
CRS-2677: Stop of 'ora.crsd' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'suse2'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'suse2'
CRS-2673: Attempting to stop 'ora.crf' on 'suse2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'suse2'
CRS-2673: Attempting to stop 'ora.evmd' on 'suse2'
CRS-2673: Attempting to stop 'ora.storage' on 'suse2'
CRS-2677: Stop of 'ora.storage' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'suse2'
CRS-2677: Stop of 'ora.mdnsd' on 'suse2' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'suse2' succeeded
CRS-2677: Stop of 'ora.crf' on 'suse2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'suse2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'suse2' succeeded
CRS-2677: Stop of 'ora.asm' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'suse2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'suse2'
CRS-2677: Stop of 'ora.cssd' on 'suse2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'suse2'
CRS-2677: Stop of 'ora.gipcd' on 'suse2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'suse2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
suse2:/u01/app/12.1.0/grid/OPatch #


suse2:/u01/app/12.1.0/grid # cd crs/install/

suse2:/u01/app/12.1.0/grid/crs/install # pwd
/u01/app/12.1.0/grid/crs/install
suse2:/u01/app/12.1.0/grid/crs/install # ll
total 1276
-rw-r--r-- 1 root oinstall     87 Feb 12 19:58 ParentDirPerm_suse2.txt
-rwxr-xr-x 1 grid oinstall  11777 Feb 12 19:40 appcluster.pl
-rwxr-xr-x 1 grid oinstall   1276 Feb 12 19:58 cmdllroot.sh
-r-xr-xr-x 1 grid oinstall   1184 Feb 12 19:37 crsconfig_addparams.sbs
-rwxr-xr-x 1 grid oinstall   5424 Feb 12 19:39 crsconfig_params
-rwxr-xr-x 1 grid oinstall   6451 Feb 12 19:39 crsconfig_params.sbs
-rwxr-xr-x 1 root oinstall  88088 Feb 12 19:40 crsdeconfig.pm
-rwxr-xr-x 1 root oinstall 118860 Feb 12 19:40 crsgpnp.pm
-rwxr-xr-x 1 grid oinstall 107043 Feb 12 19:40 crsinstall.pm
-rwxr-xr-x 1 root oinstall  14549 Feb 12 19:40 crska.pm
-rwxr-xr-x 1 root oinstall  12995 Feb 12 19:40 crsoc4j.pm
-rwxr-xr-x 1 grid oinstall  27732 Feb 12 19:40 crsohasd.pm
-rwxr-xr-x 1 root oinstall  41908 Feb 12 19:40 crspatch.pm
-rwxr-xr-x 1 root oinstall   7650 Feb 12 19:40 crstfa.pm
-rwxr-xr-x 1 root oinstall 186945 Feb 12 19:40 crsupgrade.pm
-rwxr-xr-x 1 grid oinstall 320568 Feb 12 19:40 crsutils.pm
-rwx------ 1 grid oinstall   3955 Feb 12 19:58 dropdb
-rwx------ 1 grid oinstall   1478 Feb 12 19:39 dropdb.pl
-rw-r--r-- 1 grid oinstall     68 Feb 12 19:37 inittab
-rwxr-xr-x 1 grid oinstall    294 Feb 12 19:37 install.excl
-rwxr-xr-x 1 grid oinstall      0 Feb 12 19:37 install.incl
-rwxr-xr-x 1 grid oinstall     27 Feb 12 19:37 installRemove.excl
-rwxr-xr-x 1 root oinstall  50389 Feb 12 19:40 oraacfs.pm
-rwxr-xr-x 1 root oinstall  19301 Feb 12 19:40 oraafd.pm
-rw-r--r-- 1 grid oinstall    220 Feb 12 19:37 oracle-ohasd.conf
-rw-r--r-- 1 grid oinstall    361 Feb 12 19:37 oracle-ohasd.service
-rwxr-xr-x 1 root oinstall  16251 Feb 12 19:40 oracss.pm
-rw-r--r-- 1 grid oinstall    414 Feb 12 19:37 paramfile.crs
-rwxr-xr-x 1 root oinstall  17971 Feb 12 19:40 rootcrs.pl
-rwxr-x--- 1 root oinstall    818 Feb 12 19:58 rootcrs.sh
-rwxr-xr-x 1 root oinstall   9467 Feb 12 19:40 roothas.pl
-rwxr-x--- 1 root oinstall    818 Feb 12 19:58 roothas.sh
-rwxr-xr-x 1 grid oinstall   3587 Feb 12 19:39 s_crsconfig_defs
-rwxr-xr-x 1 root oinstall    999 Feb 12 19:58 s_crsconfig_suse2_env.txt
-rwxr-xr-x 1 grid oinstall 106689 Feb 12 19:40 s_crsutils.pm
-rwxr-x--- 1 root oinstall  28721 Feb 12 19:40 tfa_setup
suse2:/u01/app/12.1.0/grid/crs/install # pwd
/u01/app/12.1.0/grid/crs/install

• suse2:/u01/app/12.1.0/grid/crs/install # perl rootcrs.sh -unlock

Using configuration parameter file: /u01/app/12.1.0/grid/crs/install/crsconfig_params
2020/02/26 18:08:57 CLSRSC-4012: Shutting down Oracle Trace File Analyzer (TFA) Collector.

2020/02/26 18:10:36 CLSRSC-4013: Successfully shut down Oracle Trace File Analyzer (TFA) Collector.

2020/02/26 18:10:37 CLSRSC-347: Successfully unlock /u01/app/12.1.0/grid


suse2:/u01/app/12.1.0/grid/bin #

suse2:/u01/app/12.1.0/grid/bin # su grid

grid@suse2:/u01/app/12.1.0/grid/bin> . oraenv
ORACLE_SID = [+ASM2] ?
The Oracle base remains unchanged with value /u01/app/grid

• grid@suse2:/u01/app/12.1.0/grid/bin> relink all

writing relink log to: /u01/app/12.1.0/grid/install/relink.log
grid@suse2:/u01/app/12.1.0/grid/bin>


grid@suse2:/u01/app/12.1.0/grid/crs/install> su root
Password:
suse2:/u01/app/12.1.0/grid/crs/install # . oraenv
ORACLE_SID = [+ASM2] ?
The Oracle base remains unchanged with value /u01/app/grid

• suse2:/u01/app/12.1.0/grid/crs/install # perl rootcrs.sh -patch

Using configuration parameter file: /u01/app/12.1.0/grid/crs/install/crsconfig_params
2020/02/26 18:18:16 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.

2020/02/26 18:18:28 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.


CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'suse2'
CRS-2672: Attempting to start 'ora.evmd' on 'suse2'
CRS-2676: Start of 'ora.mdnsd' on 'suse2' succeeded
CRS-2676: Start of 'ora.evmd' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'suse2'
CRS-2676: Start of 'ora.gpnpd' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'suse2'
CRS-2676: Start of 'ora.gipcd' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'suse2'
CRS-2676: Start of 'ora.cssdmonitor' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'suse2'
CRS-2672: Attempting to start 'ora.diskmon' on 'suse2'
CRS-2676: Start of 'ora.diskmon' on 'suse2' succeeded
CRS-2676: Start of 'ora.cssd' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'suse2'
CRS-2672: Attempting to start 'ora.ctssd' on 'suse2'
CRS-2676: Start of 'ora.ctssd' on 'suse2' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'suse2'
CRS-2676: Start of 'ora.asm' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'suse2'
CRS-2676: Start of 'ora.storage' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'suse2'
CRS-2676: Start of 'ora.crf' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'suse2'
CRS-2676: Start of 'ora.crsd' on 'suse2' succeeded
CRS-6017: Processing resource auto-start for servers: suse2
CRS-2672: Attempting to start 'ora.net1.network' on 'suse2'
CRS-2676: Start of 'ora.net1.network' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'suse2'
CRS-2672: Attempting to start 'ora.ons' on 'suse2'
CRS-2672: Attempting to start 'ora.net1.network' on 'suse1'
CRS-2672: Attempting to start 'ora.suse1.vip' on 'suse2'
CRS-2672: Attempting to start 'ora.suse2.vip' on 'suse2'
CRS-5017: The resource action "ora.net1.network start" encountered the following error:
CRS-5008: Invalid attribute value: eth0 for the network interface
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/suse1/crs/trace/crsd_orarootagent_root.trc".
CRS-2674: Start of 'ora.net1.network' on 'suse1' failed
CRS-2679: Attempting to clean 'ora.net1.network' on 'suse1'
CRS-2681: Clean of 'ora.net1.network' on 'suse1' succeeded
CRS-2676: Start of 'ora.cvu' on 'suse2' succeeded
CRS-2676: Start of 'ora.suse1.vip' on 'suse2' succeeded
CRS-2676: Start of 'ora.suse2.vip' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'suse2'
CRS-2672: Attempting to start 'ora.scan1.vip' on 'suse2'
CRS-2672: Attempting to start 'ora.net1.network' on 'suse1'
CRS-5017: The resource action "ora.net1.network start" encountered the following error:
CRS-5008: Invalid attribute value: eth0 for the network interface
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/suse1/crs/trace/crsd_orarootagent_root.trc".
CRS-2674: Start of 'ora.net1.network' on 'suse1' failed
CRS-2679: Attempting to clean 'ora.net1.network' on 'suse1'
CRS-2681: Clean of 'ora.net1.network' on 'suse1' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'suse2'
CRS-2676: Start of 'ora.ons' on 'suse2' succeeded
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'suse2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.rac.db' on 'suse2'
CRS-2676: Start of 'ora.rac.db' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.rac.pretaf.svc' on 'suse2'
CRS-2676: Start of 'ora.rac.pretaf.svc' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.net1.network' on 'suse1'
CRS-2676: Start of 'ora.net1.network' on 'suse1' succeeded
CRS-2673: Attempting to stop 'ora.suse1.vip' on 'suse2'
CRS-2677: Stop of 'ora.suse1.vip' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.suse1.vip' on 'suse1'
CRS-2676: Start of 'ora.suse1.vip' on 'suse1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'suse1'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'suse1' succeeded
CRS-2672: Attempting to start 'ora.rac.pretaf_preconnect.svc' on 'suse1'
CRS-2676: Start of 'ora.rac.pretaf_preconnect.svc' on 'suse1' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'suse2'
CRS-2672: Attempting to start 'ora.scan3.vip' on 'suse2'
CRS-2676: Start of 'ora.scan2.vip' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'suse2'
CRS-2676: Start of 'ora.scan3.vip' on 'suse2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'suse2'
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'suse2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'suse2' succeeded
CRS-6016: Resource auto-start has completed for server suse2
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [0].

suse2:/u01/app/12.1.0/grid/crs/install #

suse2:~ # crsctl status resource -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       suse1                    STABLE
               ONLINE  ONLINE       suse2                    STABLE
ora.DATA.dg
               ONLINE  ONLINE       suse1                    STABLE
               ONLINE  ONLINE       suse2                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       suse1                    STABLE
               ONLINE  ONLINE       suse2                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       suse1                    STABLE
               ONLINE  ONLINE       suse2                    STABLE
ora.asm
               ONLINE  ONLINE       suse1                    Started,STABLE
               ONLINE  ONLINE       suse2                    Started,STABLE
ora.net1.network
               ONLINE  ONLINE       suse1                    STABLE
               ONLINE  ONLINE       suse2                    STABLE
ora.ons
               ONLINE  ONLINE       suse1                    STABLE
               ONLINE  ONLINE       suse2                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       suse1                    STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       suse2                    STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       suse2                    STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       suse2                    169.254.170.106 192.
                                                             168.10.6,STABLE
ora.cvu
      1        ONLINE  ONLINE       suse2                    STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       suse2                    Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       suse2                    STABLE
ora.rac.db
      1        ONLINE  ONLINE       suse1                    Open,STABLE
      2        ONLINE  ONLINE       suse2                    Open,STABLE
ora.rac.pretaf.svc
      1        ONLINE  ONLINE       suse1                    STABLE
ora.rac.pretaf_preconnect.svc
      1        ONLINE  ONLINE       suse2                    STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       suse1                    STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       suse2                    STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       suse2                    STABLE
ora.suse1.vip
      1        ONLINE  ONLINE       suse1                    STABLE
ora.suse2.vip
      1        ONLINE  ONLINE       suse2                    STABLE
--------------------------------------------------------------------------------
suse2:~ #