Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

rman restore recover date is lost

env:rac 19c

problem description:Data in table t is lost after database restoration


1、Prepare test data:

SQL> select * from t;

    ID

----------

     1

2、rman backup

cat db_fullbak.sh 

#!/bin/bash

echo -e '******Start********_'$(date '+%Y-%m-%d %H:%M:%S')

source /home/oracle/.bash_profile

find /backup/rman/ -mtime +15 -name "mesdb_*" -exec rm -f {} \;

rman target / log=/backup/rman/fulldb_`date +%Y%m%d-%H%M%S`.log <<EOF

run{

allocate channel c1 type disk;

allocate channel c2 type disk;

crosscheck backup;

crosscheck archivelog all; 

sql"alter system switch logfile";

delete noprompt expired backup;

delete noprompt expired archivelog all;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center