Wednesday 15 December 2021

Rman - Different way to connect rman console

 

RMAN - Different way to connect rman  console 


Scenario :

Here different way or example  to connect rman console 

  • Example 1: 

[oracle@srv6 ~]$ export ORACLE_SID=sourcegg1



oracle@srv6 ~]$ rman target /


Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 8 19:35:37 2021

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


connected to target database: SOURCEGG (DBID=358165956)


RMAN> 

  • Example 2: 

[oracle@srv6 ~]$ export ORACLE_SID=sourcegg1

[oracle@srv6 ~]$ rman


Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 8 19:36:06 2021

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


RMAN> connect target /


connected to target database: SOURCEGG (DBID=358165956)


RMAN>

  • Example 3: 

[oracle@srv6 ~]$ rman target sys@sourcegg1

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 8 19:36:42 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

target database Password:
connected to target database: SOURCEGG (DBID=358165956)

RMAN> 

  • Example 4 : 
[oracle@srv6 ~]$ rman

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 8 19:36:56 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target sys/system123@sourcegg1

connected to target database: SOURCEGG (DBID=358165956)

RMAN> 

  • Example 5: 
[oracle@srv6 ~]$ rman

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 8 19:37:20 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target sys@sourcegg1

target database Password:
connected to target database: SOURCEGG (DBID=358165956)

RMAN>


SQL> alter system set control_file_record_keep_time=21 scope=both;

Automatic 
RMAN> configure controlfile autobackup on;

backup current controlfile;

Manual 

RMAN> backup tablespace user include current controlfile;

RMAN> configure controlfile autobackup on;

backup current controlfile;

backup as copy current controlfile format '/tmp/bkpcontrol.bkp';

No comments:

Post a Comment